Home >Database >Mysql Tutorial >工作中用到的mysql命令_MySQL
工作中用到的mysql命令_MySQL
- WBOYOriginal
- 2016-05-27 14:12:281474browse
bitsCN.com
通过cmd连接mysql：mysql -uroot -p123456 (需要配置path环境变量：C:/Program Files/MySQL/MySQL Server 5.6/bin )
创建数据库并使用utf8编码： create database utf8_test default character set utf8;
查看已有的数据库： show databases;
删除数据库：drop database utf8_set;（慎用）
查看当前数据的状态：status;（我主要是看当前数据所用的编码）
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：通过cmd命令连接mysql_MySQLNext article：Linux下MySQL数据文件目录搬迁_MySQL