====== Login ======

<code bash>
$ mysql -u root -p
</code>

====== List Users ======

<code sql>
mysql> SELECT User FROM mysql.user;
</code>

====== Databases ======

===== List Databases =====

<code sql>
mysql> show databases;
</code>

===== Change/Select Database =====

<code sql>
mysql> use <database>;
</code>

====== Tables ======

===== List Tables =====

<code sql>
mysql> show tables;
</code>

===== List Table Columns =====

<code sql>
mysql> SHOW COLUMNS FROM <table>;
</code>

====== VARCHAR ======

The max length of varchar in MySQL is 64KB

<code sql>
VARCHAR(65535)
</code>

Lower with a multi-byte character set

<code sql>
VARCHAR(21844) CHARACTER SET utf8
</code>

====== Execute SQL File ======

<code sql>
mysql> source '/<path>/<to>/<file>.sql';
</code>

====== Indexes ======

===== Add Index =====

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

===== Show Indexes =====

<code sql>
mysql> show index from <table>;
</code>

===== Drop Index =====

<code sql>
mysql> alter table <table> drop index <index>;
</code>

====== Insert ======

===== Insert or Update =====

<code sql>
mysql> INSERT INTO <table> (field1, field2, field3) VALUES ('value1', 'value2','value3') ON DUPLICATE KEY UPDATE field1='value1', field2='value2', field3='value3';
</code>