mysql 常用命令

1 alter table table_name drop column column_name;

2 alter talbe table_name drop column column_name;

3 rename talbe table_name to new_table_name;

4 alter talbe table_name add column column_name;

5 alter   table   employee   change   column   employeeID   empID   int;   

6 mysqladmin -u root -p password mypasswd

7  select *from articles LEFT JOIN categories ON     articles.categoryid=categories.categoryid ORDER by articles.id DESC limit $beginid,$endid