MySQL之“增 （insert into）“

插入表记录命令格式

1.添加多条记录，给所有字段赋值

mysql> insert into user values(40,"tom","x",3002,3002,"teacher","/home/tom","/sbin/nologin"), (41,"tom","x",3002,3002,"teacher","/home/tom","/sbin/nologin");
mysql> select * from user; 

2…添加1条记录，给指定字段赋值，给user表中的name和homedir字段赋值

mysql> insert into user(name,homedir) values("alice","/home/alice");
mysql> select * from user; 

3…添加多条记录，给指定字段赋值

mysql> insert into user(name)  values("john"),("jack"),("lucy");
mysql> select * from user; 

注意