时间:2021-07-01 10:21:17 帮助过:9人阅读
1.查询当前数据库所有表名:
- <span style="color: #008080">--</span><span style="color: #008080"> 方案一:</span>
- <span style="color: #000000">show tables;
- </span><span style="color: #008080">--</span><span style="color: #008080">方案二:jeesite为数据库</span>
- <span style="color: #0000ff">select</span> table_name <span style="color: #0000ff">from</span> information_schema.tables <span style="color: #0000ff">where</span> table_schema<span style="color: #808080">=</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">jeesite</span><span style="color: #ff0000">‘</span> <span style="color: #808080">and</span> table_type<span style="color: #808080">=</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">base table</span><span style="color: #ff0000">‘</span>;
2,查询某张表的所有字段名:
- <span style="color: #008080">--</span><span style="color: #008080"> jeesite为数据库名,sys_role为表名</span>
- <span style="color: #0000ff">select</span> column_name <span style="color: #0000ff">from</span> information_schema.columns <span style="color: #0000ff">where</span> table_schema<span style="color: #808080">=</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">jeesite</span><span style="color: #ff0000">‘</span> <span style="color: #808080">and</span> table_name<span style="color: #808080">=</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">sys_role</span><span style="color: #ff0000">‘</span>;
3,查询mysql支持哪些存储引擎:
- show engines;
4,查看mysql当前默认的存储引擎:
- show variables <span style="color: #808080">like</span> <span style="color: #ff0000">‘</span><span style="color: #ff0000">%storage_engine%</span><span style="color: #ff0000">‘</span>;
5,备份一个数据库【在windows cmd 下面使用】
- mysqldump <span style="color: #808080">-</span>h hostname <span style="color: #808080">-</span>P port <span style="color: #808080">-</span>u username <span style="color: #808080">-</span>p dbname table1 table2 ... <span style="color: #808080">></span> d:\BackupName.sql
其中:
例如:使用root用户备份jeesite数据库下的fr_t_user表
- mysqldump <span style="color: #808080">-</span>u root <span style="color: #808080">-</span>p jeesite fr_t_user <span style="color: #808080">></span> D:\mysql\<span style="color: #0000ff">backup</span>\mysql20171126.sql
6,使用mysqldump命令 还原数据库的语法如下【在windows cmd 下面使用】:
- mysql -hlocalhost -P3306 -uroot -p dbname <<span> d:\mysql\backup\mysql20171126.sql</span>
Mysql的基本语句
标签:inf span div 输入密码 数据库名 center 端口 绝对路径 参数表