Show command in MySql
April 13, 2018 | Spring boot complete tutorial with example | No Comments
we use show command to describe or see the content of database
You can use the below command to check the complete list of syntax of show command
help show
There are some command that describe show better
if you want to check the complete details of table like creation time and updation time then use the following command
show table status where name = “yourTableName”\G;
if you want to see the schema of your table then use below command
show create table yourTableName;
if you want to check details of every column of your table then use the following command
show columns from yourTableName;
or
describe yourTableName;
if you want to check how many connection are used in mysql or connection details then use the below command
show full processlist;