MySQL 管理表(增删改查)
MySQL 管理表:
增加行:
添加一行: insert into user values
(42,"bbb","x",1003,1003,"teacher","/home/jingyaya3","/bin/bash"); #添加所有列 insert into tarena.user(name,uid,shell) values ("aaa",1002,"/sbin/nologin"); #不完全添加列,其他列为null
insert into tarena.user set name="aa" , uid=99 , gid=99 ; 添加多行: insert into tarena.user values #添加所有列 (41,"aaa","x",1002,1002,"teacher","/home/jingyaya2","/bin/bash"), (42,"bbb","x",1003,1003,"teacher","/home/jingyaya3","/bin/bash"); insert into tarena.user(name,uid,shell)values #不完全添加列,其他列为null ("b2",1002,"/sbin/nologin"), ("b3",1003,"/sbin/nologin");
删除行,删除表,删除库:
delete from user where id <= 10 ; #删除行
drop tables user; #删除表
drop database mysql; #删除库
修改行:
update user set comment=NULL where id <= 10 ;