Differences

This shows you the differences between two versions of the page.

--- mysql [2013/04/17 01:43] – javapimp
+++ mysql [2023/08/18 18:15] (current) – external edit 127.0.0.1
@@ Line 5: / Line 5: @@
 </code>
-====== List Databases ======
+====== List Users ======
+<code sql>
+mysql> SELECT User FROM mysql.user;
+</code>
+====== Databases ======
+===== List Databases =====
 <code sql>
@@ Line 11: / Line 19: @@
 </code>
-====== List Users ======
+===== Change/Select Database =====
 <code sql>
-mysql> SELECT User FROM mysql.user;
+mysql> use <database>;
 </code>
-====== List Tables ======
+====== Tables ======
+===== List Tables =====
 <code sql>
 mysql> show tables;
+</code>
+===== List Table Columns =====
+<code sql>
+mysql> SHOW COLUMNS FROM <table>;
 </code>
@@ Line 37: / Line 53: @@
 </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>