˳ʽquitexit.\q
mysqlshow -u root == show databases    //鿴ǰMYSQLϴڵݿ

mysqlshow -u root mysql = use 
                          show tables //鿴ǰMYSQLݿΪMYSQLб
ysqlshow -u root info info = describe info        //鿴ǰMYSQLݿΪMYSQLUSERĽṹ
mysql -u û -h  -p     //MYSQL
mysql -u root -p                     //ûrootMYSQL
mysqldump [в] ݿ []
mysqldump --opt mysql > mysql.sql    //--optŻݹ
mysqldump --add-drop-table           // ȡñļеݲصһݿ⣬
                                        ѾڣȻܹȷ
mysql ݿ < ļ

create database db_name                //½һݿ
drop database da_name                  //ɾһݿ
use db_name                            //һݿ    
create table                           //½һ
primary key                            //  
create table new_tb_name select * from table_name //һȫͬı
drop table tb_name                     //ɾһ


alter table                            //ıĽṹ
alter table tb_name RENAME new_tb_name //ı
alter table tb_name change ֶ ֶ ֶŪ() //޸ֶ
alter table tb_name modify ֶ  ֶŪ()       //޸ֶ
alter table tb_name add column ֶ ֶ()    //һֶ
alter table tb_name add index(ֶ)                   //һ
alter table tb_name add primary key(ֶ            //
alter table tb_name drop column ֶ                  //ɾ

INSERT INTO //
insert into tb_name values(ֵ1ֵ2ֵ3...)
insert into tb_name (ֶ1ֶ2ֶ3...)  values (ֵ1ֵ2ֵ3...)
insert into tb_name set 
                    ֶ=ֵ1,

                    ֶ=ֵ2,

                    ֶ=ֵ3
                     .
                     .
                     .
UPDATE //޸
update tb_name set 
                 ֶ=ֵ1
                 ֶ=ֵ2,
                 ֶ=ֵ3
                     .
                     .
                     .
                        where ()         

DELETE //޸
delete from tb_name where ()












SELECT //ѯ
select () from  WHERE ()  //select now();
select ֶ1,2... from  WHERE ()
select * from 
select * from  order by ֶ //

PHPMYSQL
mysql_connect();
mysql_close();       //ݿ
mysql_pconnect();    //ݿ
mysql_create_db      //һݿ
mysql_drop_db        //ɾһݿ
mysql_select_db()    //ѡݿ
mysql_list_fields()  //Ľṹ
mysql_query()        //ݿⷢһѯ
mysql_fetch_array()  //ӽȡõɵ
mysql_num_rows       //ȡýеĿ
