This is an old revision of the document!

List Databases

mysql> SHOW DATABASES;

List Users

mysql> SELECT USER FROM mysql.user;

mysql> USE <database>;

mysql> SHOW TABLES;

mysql> SHOW COLUMNS FROM <table>;

The max length of varchar in MySQL is 64KB

VARCHAR(65535)

Lower with a multi-byte character set

VARCHAR(21844) CHARACTER SET utf8

mysql> SOURCE '/<path>/<to>/<file>.sql';

mysql> ALTER TABLE <table> ADD INDEX <index> (<column>);