mysql实例电子城项目&数据库作业（13） 任务三 对表的数据进行基本操作

1.所有字段批量插入用户表数据

phone	username	password	question	answer
13812345678	anne	annnepassword	favorite book	harry potter
18212345678	frank	Frankpassword	Favorite song	lonely
13212345678	alan	Alanpassword	First love	carry
13112345678	peter	Peterpassword	Who is your father	jack

insert into user_zhanghaili

    -> values (13812345678,"anne","annepassword","favorite book","harry potter"),

    -> (18212345678,"frank","frankpassword","favorite song","lonely"),

    -> (13212345678,"alan","alanpassword","first love","carry"),

    -> (13112345678,"peter","peterpassword","who is your father","jack");

2.所有字段批量插入卖家信息表数据

id	phone	open_date	name	nickname
S_20200703_00001	13812345678	2020-07-03	ledin	ledin
S_20201030_00001	18212345678	2020-10-30	hla	hla

insert into seller_zhanghaili values

    -> ("S_20200703_00001",13812345678,"2020-07-03","ledin","ledin"),

    -> ("S_20201030_00001",18212345678,"2020-10-30","hla