Mysql----基础操作

1 row affected (0.00 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | test | | test2 | +--------------------+ 6 rows in set (0.00 sec)

• 查看数据库：show databases;

mysql><span style="color: #000000;"><strong> create Database test2;</strong>
Query OK, </span><span style="color: #800080;">1</span> row affected (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
mysql</span>><span style="color: #000000;"> show databases;
</span>+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
| test2              |
+--------------------+
<span style="color: #800080;">6</span> rows <span style="color: #0000ff;">in</span> <span style="color: #0000ff;">set</span> (<span style="color: #800080;">0.00</span> sec)

• 选择数据库：use database_name

mysql><span style="color: #000000;"> show databases;
</span>+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
| test2              |
+--------------------+
<span style="color: #800080;">6</span> rows <span style="color: #0000ff;">in</span> <span style="color: #0000ff;">set</span> (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
mysql</span>><span style="color: #000000;"><strong> use information_schema;</strong>
Reading table information </span><span style="color: #0000ff;">for</span><span style="color: #000000;"> completion of table and column names
You can turn off </span><span style="color: #0000ff;">this</span> feature to <span style="color: #0000ff;">get</span> a quicker startup with -<span style="color: #000000;">A
<strong>Database changed #表示选择数据库成功</strong></span>

• 删除数据库：DROP DATABASE database_name

mysql><span style="color: #000000;"> show databases;
</span>+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| <strong>test</strong>               |
| test2              |
+--------------------+
<span style="color: #800080;">6</span> rows <span style="color: #0000ff;">in</span> <span style="color: #0000ff;">set</span> (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
mysql</span>><span style="color: #000000;"><strong> drop database test;</strong>
Query OK, </span><span style="color: #800080;">0</span> rows affected (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
mysql</span>><span style="color: #000000;"> show databases;
</span>+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test2              |
+--------------------+
<span style="color: #800080;">5</span> rows <span style="color: #0000ff;">in</span> <span style="color: #0000ff;">set</span> (<span style="color: #800080;">0.00</span> sec)

• 查询默认存储引擎：SHOW VARIABLES LIKE ‘storage_engine%‘;

mysql> show variables like <span style="color: #800000;">‘</span><span style="color: #800000;">storage_engine%</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
Empty </span><span style="color: #0000ff;">set</span> (<span style="color: #800080;">0.01</span> sec)

 

Mysql----基础操作

标签：with   sql   选择   format   mys   orm   for   reading   class