Frequently used mysql statements

29秒

SHARE

summary
Start: mysql -u root;.
Database display: show databases;.
Table display: show tables;.
Database switching: use XXX; (database name)
Table column display: desc XXX; (table name)
Display table data: select * from XXX; (table name)
Table column drop: alter table XXX drop XXX; (table name, column name)
Delete data from table: delete from XXX where num=XXX; (table name, row number)
Delete the entire database: drop database XXX; (database name) *delete seems to work too.

 

前の記事

Attention to databases

次の記事

jquery