MySQL Data common commands

1. Display the table code:

Syntax: Show create TABLE table name; The table name T1 is tested below.

> Show CREATE TABLE t1;

You can see that the encoding for this table is UTF8MB4

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/88/1E/wKiom1fp70-j4lY9AABk3kcHQDY718.jpg-wh_500x0-wm_3 -wmp_4-s_2420094118.jpg "title=" qq20160927120041.jpg "alt=" Wkiom1fp70-j4ly9aabk3kchqdy718.jpg-wh_50 "/>

2. List all tables in the current database.

> Show tables;

3. List the current database.

> show databases;

Reference:

Http://www.splaybow.com/post/mysql-view-table-charset.html

This article is from the "Enlightened Grocery store" blog, please be sure to keep this source http://wutou.blog.51cto.com/615096/1856917

MySQL Data common commands