表名-------->test;
创建一个数据库:
create database 库名 charset 'utf8' ;
创建一章表:
create table test ( id int primary key,name varchar(50) not null) ;
插入一条数据:
insert into test (id,name) values (1,'tom');
插入多条数据:
insert into test (id,name) values
(1,'tom'),
(2,'tim'),
(3,'rose');
删除一条数据:
delete from test where id=1;
删除多条数据:
delete from test where id in (1,2,3);
修改一条数据:
update test set name='aa' where id=1;
修改多条数据:
update test
set name = case id
when 1 then 'vv'
when 2 then 'bb'
when 3 then 'cc'
end
where id in(1,2,3)