1.创建学生表stu,插入三条记录。
输入:create table stu(s_id int(11) primary key,s_name varchar(20) not null,addr varchar(50) not null,tel varchar(50) not null);
create table stu(s_id int(11) primary key,s_name varchar(20) not null,addr varchar(50) not null,tel varchar(50) not null);
输入:INSERT INTO stu
-> VALUES(1,'zhangpeng','Hebei','13889075861'),
-> (2,'LiXiao','shandong','13953508223'),
-> (3,'HuangYun','shandong','13905350996');
INSERT INTO stu
-> VALUES(1,'zhangpeng','Hebei','13889075861'),
-> (2,'LiXiao','shandong','13953508223'),
-> (3,'HuangYun','shandong','13905350996');
查看:select * from stu;