本文共 627 字,大约阅读时间需要 2 分钟。
use mydb;
createtable user(
userid int,
username varchar(20),
password varchar(20)
);
-- alter table user add email VARCHAR(20) first;
alter table user change email email varchar(50) after userid;
alter table user drop phone;
-- insert intouser(username,password,email)values('ls','123','ls@qq.com'),('ls','123','ls@qq.com');
insert intousers select * from user
update tbname set 字段=新值 [where ]
update user set username = 'ww' where userid =3;
delete from tbname [where]
delete from user where userid = 4;
转载地址:http://oyncx.baihongyu.com/