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
mysql 常用命令
最新推荐文章于 2024-06-05 22:54:12 发布