好久没写sql了,发现基本语法都忘了,复习下
mysql> create table a(
-> id INT,
-> name varchar(20)
-> );
mysql> create table b(
-> id INT,
-> store INT
-> );
insert into a (id,name) values(1,'a');
insert into a (id,name) values(2,'b');
insert into a (id,name) values(3,'b');
update b set store=22 where id=2;
delete from b where id=2;
阅读(1186) | 评论(0) | 转发(1) |