Commons
#Database
| - | - |
|---|---|
CREATE DATABASE db ; | Create database |
SHOW DATABASES; | List databases |
USE db; | Switch to db |
CONNECT db ; | Switch to db |
DROP DATABASE db; | Delete db |
#Table
| - | - |
|---|---|
SHOW TABLES; | List tables for current db |
SHOW FIELDS FROM t; | List fields for a table |
DESC t; | Show table structure |
SHOW CREATE TABLE t; | Show create table sql |
TRUNCATE TABLE t; | Remove all data in a table |
DROP TABLE t; | Delete table |
#Proccess
| - | - |
|---|---|
show processlist; | List processes |
kill pid; | kill process |
#Other
| - | - |
|---|---|
exit or \q | Exit MySQL session |
Comments