sudo apt-get update
　　sudo apt-get install mysql-server
　　sudo apt-get install python-mysqldb（如果python中要使用，請(qǐng)安裝）

mysql -u root -p

　　show databases;

use database_name;

　show tables;

create database database_name;

create database test1 default character set utf8 collate utf8_general_ci;

drop database database_name;
drop database database_name;

　drop database database_name;

　drop table table_name;

　insert into table_name(col1,col2) values(value1,value2);

update table_name set col1='value1',col2='value2' where where_definition;

select * from table_name where...

　delete from table_name where...

　alert table table_name add column field1 date ,add column field2 time...

alert table table_name drop field1;

show columns from table_name;

select * from table_name limit 3；//每頁(yè)只顯示3行
　　select * from table_name limit 3,4 //從查詢結(jié)果的第三個(gè)開(kāi)始，顯示四項(xiàng)結(jié)果。
　　此處可很好的用來(lái)作分頁(yè)處理。

select * from table_name order by field1,orderby field2;多重排序

MySQL:exit;

update test set contont=replace(replace(contont,char(10),''),char(13),'');

update test set contont=replace(contont,char(10),'')
　　update test set contont=replace(contont,char(13),'')

　show variables like 'char%';

show create database database_name;

alter database database_name character set utf8;

show create table table_name;

alter table table_name convert to character set utf8 collate utf8_general_ci;