《MySQL必知必会》第19章

1、插入一整行的方法（两种：简洁但不安全；安全）
2、插入多个行的方法（两种：分号；逗号加部分省略）
3、插入检索出来的数据
注意点：省略的列若是不允许NULL值或者没有默认值，怎会出现错误。降低INSERT语句的优先级
INSERT LOW_PRIORITY INTO

############如何利用INSERT语句将数据插入表中###############
#插入用户信息到customers表中,不安全
INSERT INTO customers
VALUES (NULL,
    'Pep E. LaPew',
		'100 Main Street',
		'Los Angeles',
		'CA',
		'90046',
		'USA',
		NULL,
		NULL);

##插入用户信息到customers表中,更安全(一般使用给出列的列表INSERT语句)
INSERT INTO customers(cust_name,
cust_address,
cust_city,
cust_state,
cust_zip,
cust_country,
cust_contact,
cust_email)
VALUES('Pep E. LaPew',
		'100 Main Street',
		'Los Angeles',
		'CA',
		'90046',
		'USA',
		NULL,
		NULL)
	
#插入多条语句
#
INSERT INTO customers(cust_name,
cust_address,
cust_city,
cust_state,
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_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_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');
		
#将SELECT语句结果插入表中
INSERT INTO customers(cust_id, 
    cust_contact,
		cust_email,
		cust_name,
		cust_address,
		cust_city,
		cust_state,
		cust_zip,
		cust_country)
SELECT cust_id, 
    cust_contact,
		cust_email,
		cust_name,
		cust_address,
		cust_city,
		cust_state,
		cust_zip,
		cust_country
FROM custnew