数据库常用命令教程.docxVIP

存储引擎：Engine=innodb 字符集： charset=utf8 Character set utf8 查看字符集：show character set; show global variables like%char%; show global variables like%collation%; 显示字符序：show collation; 设置服务器级别：set global character_set_server=gbk; 显示服务器级别：show global variables like char%; 数据库进入命令：mysql -h hostname -u username -p? mysql -h localhost -u root –p 帮助：help Help create database; mydb数据库 数据库导入命令：mysqldump -h localhost -u root -p mydb e:\mysql\mydb.sql source e:/song.sql;从外部导入：mysql -h localhost -u root -p mydb2 e:\mysql\mydb2.sql 创建数据库：create dat