[MySQL] MySQL Moniter

MySQL Server 접속

mysql -uroot -p 입력후 자신의 password 입력

 

 

Create database(schema)

 

mysql> CREATE DATABASE database_name;

 

Delete database

mysql> DROP DATABASE database_name;

 

Show database list in mysql

mysql> SHOW DATABASES;

 

Select database 

mysql> USE database_name;

 

Show tables

mysql> SHOW TABLES;

 

Show structure of table

mysql> DESC table_name;

 

Show all of data from table

mysql> SELECT * FROM table_name;