mysql常用命令

http://www.runoob.com/mysql/mysql-union-operation.html

删除数据表

drop table name;

插入数据

insert into tablename(names)  values (value);

显示表

desc tablename;

查询数据

select name from tablename;

update查询

update myfirsttable set name='12' where name='123';

删除数据

delete from myfirsttable where name='234';

like子句

SELECT field1, field2,...fieldN 
FROM table_name
WHERE field1 LIKE condition1 [AND [OR]] filed2 = 'somevalue'