查看表结构
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 [表达式];
