重命名表明 :alter table old_name rename to new_name;
查看数据库字符集类型: show variables like 'collation_%';
查看数据库有哪些存储引擎可以用: show engines;
导出数据:select pic_id from sp_photo_03 where pic_stat=1 into outfile '122.txt';
查看mysql状态:status;
重命名表明 :alter table old_name rename to new_name;
查看数据库字符集类型: show variables like 'collation_%';
查看数据库有哪些存储引擎可以用: show engines;
导出数据:select pic_id from sp_photo_03 where pic_stat=1 into outfile '122.txt';
查看mysql状态:status;