查看数据库:
show databases
选择数据库
USE database_name
表定义信息
describe table_name
插入数据:
insert into table_name (filed_1 ... field_n) values (value_1 ... value_n)
eg: insert into person_no (NAME,AGE) values ('Tom',10)
更新数据:
update table_name set field_1 = value_1 ... filed_n = value_n where condition
eg: update person_no set AGE = 20 where NAME = 'Tom'
查询数据:
select * from table_name where condition
模糊查询:前匹配、后匹配和任意位置匹配
select * from table_name where field1 like ' %value1%' / like 'value2% / like '%value3'
注:该查询语句效率较低
排序查询:升序和降序
select field_1, field_n from table_name where condition order by field_name [ASC|DESC]
去重查询:
select distinct field_1, field_n from table_name
查询总数:
select count(*)/count(0) * from table_name
查询前100条数据:
select top 100 * from table_name
删除数据:
delete from table_name where condition