- 导出:
mysqldump -u username -p password -h hostname databasename tablename > filename.sql
- 导入:
mysql -u username -p password -h hostname databasename < filename.sql
- 修改表字段类型:
alter TABLE addfunds_0 CHANGE topup_type topup_type enum('1','2','3','4','5');
- 显示建表语句:
show create table tablename;
- 增加表字段:
alter table addfunds_0 add column payout_id bigint(18) after updatetime;
- 删除表字段:
alter table addfunds_0 drop column payout_id;