MySQL数据的插入、更新和删除_mysql 插入并更新-优快云博客

本文链接：https://blog.youkuaiyun.com/taifyang/article/details/117160107

这篇博客介绍了SQL中的基本数据操作，包括如何插入单行或多行数据到表中，如何更新特定列的值，以及如何删除数据。示例涵盖了单个记录的插入、批量插入以及使用SELECT语句从其他表中检索数据进行插入。同时，还展示了如何更新和删除指定ID的客户记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

插入完整的行

insert into customers 
values(NULL, 
	'Pep E .LaPew', 
	'100 Main Street', 
	'Los Angeles', 
	'CA', 
	'90046', 
	'USA', 
	NULL, 
	NULL);

insert into customers(cust_name,
	cust_contact,
	cust_email,
	cust_address,
	cust_city,
	cust_state,
	cust_zip,
	cust_country)
values('Pep E .LaPew', 
	NULL, 
	NULL, 
	'100 Main Street', 
	'Los Angeles', 
	'CA', 
	'90046', 
	'USA');

插入多个行

insert into customers(cust_name,
	cust_address,
	cust_city,
	cust_state,
	cust_contact,
	cust_zip,
	cust_country)
values('Pep E .LaPew', 
	'100 Main Street', 
	'Los Angeles', 
	'CA', 
	'90046', 
	'USA');
insert into customers(cust_name,
	cust_address,
	cust_city,
	cust_state,
	cust_contact,
	cust_zip,
	cust_country)
values('M. Martian', 
	'42 Galaxy Way', 
	'New York', 
	'NY', 
	'11213', 
	'USA');

或者

insert into customers(cust_name,
	cust_address,
	cust_city,
	cust_state,
	cust_contact,
	cust_zip,
	cust_country)
values('Pep E .LaPew', 
	'100 Main Street', 
	'Los Angeles', 
	'CA', 
	'90046', 
	'USA'),
	('M. Martian', 
	'42 Galaxy Way', 
	'New York', 
	'NY', 
	'11213', 
	'USA');

插入检索出来的数据

insert into customers(cust_name,
	cust_address,
	cust_city,
	cust_state,
	cust_contact,
	cust_zip,
	cust_country)
select cust_name,
	cust_address,
	cust_city,
	cust_state,
	cust_contact,
	cust_zip,
	cust_country
from custnew;

更新数据
更新单个列

update customers 
set cust_email = 'elmer@fudd.com' 
where cust_id = 10005;

更新多个列

update customers 
set cust_name = 'The Fudds',
	cust_email = 'elmer@fudd.com' 
where cust_id = 10005;

删除某个列的值

update customers 
set cust_email = null 
where cust_id = 10005;

删除数据

delete from customers 
where cust_id = 10006;