数据库增加 insert into 表名

插入行所有数据

1.INSERT INTO member VALUES(5,'wangkai','123456','15313929271',1,0,'2020-05-17 14:00:00');

插入行指定列

2.INSERT INTO member (id,regName) VALUES(6,'huididi')；

插入多条数据

3.INSERT INTO member (id,regName) VALUES(7,'jiawei'),(8,'changyong')

插入数据有不需要插入的数据 null id自增

4.INSERT INTO member VALUES(null,'wangkai','123456','15313929271',1,0,'2020-05-17 14:00:00');

插入数据 DEFAULT id自增

5.INSERT INTO member VALUES(DEFAULT,'wangkai','123456','15313929271',1,0,'2020-05-17 14:00:00');

高级插入

6.INSERT member SET id = 9,regName='kk';

将查找的数据插入表中

7.INSERT member(regName) SELECT regName from member;