SQL基本增删改查语句

查看表结构

desc [tableName];

插入一行数据

insert into ([tableName]

(columesName，...,))

values ([value],...);

插入多行数据

insert into ([tableName]

(columesName，...,))

values

([value],...),

...

([value],...);

更改一列

update [tableName] set [columesName] = ...;

更改指定行的数据

update [tableName] set [columesName] = ... where [条件表达式];

删除表中所有数据

delete from [tableName];

删除指定行的数据

delete from [tableName] where [条件表达式];

查看全表数据

select * from [tableName];

查看某行某列数据

select columeName,... from [tableName] where [表达式];