10.插入数据

语法:
INSERT INTO table [(column [, column...])] VALUES (value [, value...]);

实例

INSERT INTO USER
	(username,nickname,birthday,telephone)

VALUE('admin','管理员','2000-01-02','17745125669');

sql

insert  into `user`
(`id`,`username`,`nickname`,`birthday`,`telephone`,`create_time`,`status`) 
values
(1,'admin','管理员','2000-01-02','17745125669','2020-11-09 11:36:10','1'),
(2,'jshand','金山','2002-01-02','17745125669','2020-11-09 11:38:42','1'),
(3,'jshand1','金山','2002-01-02','17745125669','2020-11-09 11:38:48','1'),
(4,'jshand2','金山','2002-01-02','17745125669','2020-11-09 11:38:51','1'),
(5,'jshand4','金山','2002-01-02','17745125669','2020-11-09 11:38:56','1'),
(6,'jshand5','金山','2002-01-02','17745125669','2020-11-09 11:38:59','1'),
(7,'jshand6','金山','2002-01-02','17745125669','2020-11-09 11:38:59','1'),
(8,'jshand7','金山','2002-01-02','17745125669','2020-11-09 11:39:00','1'),
(9,'jshand8','金山','2002-01-02','17745125669','2020-11-09 11:39:00','1');

10.插入数据 ​

10.插入数据