mysql
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
mysql [2013/04/17 01:36] – created javapimp | mysql [2023/08/18 18:15] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 5: | Line 5: | ||
</ | </ | ||
- | ====== List Databases ====== | + | ====== List Users ====== |
+ | |||
+ | <code sql> | ||
+ | mysql> SELECT User FROM mysql.user; | ||
+ | </ | ||
+ | |||
+ | ====== | ||
+ | |||
+ | ===== List Databases | ||
<code sql> | <code sql> | ||
Line 11: | Line 19: | ||
</ | </ | ||
- | ====== List Users ====== | + | ===== Change/ |
<code sql> | <code sql> | ||
- | mysql> | + | mysql> |
+ | </ | ||
+ | |||
+ | ====== Tables ====== | ||
+ | |||
+ | ===== List Tables ===== | ||
+ | |||
+ | <code sql> | ||
+ | mysql> show tables; | ||
+ | </ | ||
+ | |||
+ | ===== List Table Columns ===== | ||
+ | |||
+ | <code sql> | ||
+ | mysql> SHOW COLUMNS | ||
+ | </ | ||
+ | |||
+ | ====== VARCHAR ====== | ||
+ | |||
+ | The max length of varchar in MySQL is 64KB | ||
+ | |||
+ | <code sql> | ||
+ | VARCHAR(65535) | ||
+ | </ | ||
+ | |||
+ | Lower with a multi-byte character set | ||
+ | |||
+ | <code sql> | ||
+ | VARCHAR(21844) CHARACTER SET utf8 | ||
+ | </ | ||
+ | |||
+ | ====== Execute SQL File ====== | ||
+ | |||
+ | <code sql> | ||
+ | mysql> source '/< | ||
+ | </ | ||
+ | |||
+ | ====== Indexes ====== | ||
+ | |||
+ | ===== Add Index ===== | ||
+ | |||
+ | <code sql> | ||
+ | mysql> ALTER TABLE < | ||
+ | </ | ||
+ | |||
+ | ===== Show Indexes ===== | ||
+ | |||
+ | <code sql> | ||
+ | mysql> show index from < | ||
+ | </ | ||
+ | |||
+ | ===== Drop Index ===== | ||
+ | |||
+ | <code sql> | ||
+ | mysql> alter table < | ||
+ | </ | ||
+ | |||
+ | ====== Insert ====== | ||
+ | |||
+ | ===== Insert or Update ===== | ||
+ | |||
+ | <code sql> | ||
+ | mysql> INSERT INTO < | ||
</ | </ | ||
mysql.1366162618.txt.gz · Last modified: 2023/08/18 18:15 (external edit)