show databases;
use [database_name];
SHOW TABLES;
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]
查看当前数据库编码:
show variables like 'collation_%';
show databases;
use [database_name];
SHOW TABLES;
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]
查看当前数据库编码:
show variables like 'collation_%';
本文标题:MySQL命令
本文链接:https://www.haomeiwen.com/subject/aslpdxtx.html
网友评论