Differences

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

--- mysql [2013/04/17 01:55] – 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> show databases;
+mysql> SELECT User FROM mysql.user;
 </code>
-====== List Users ======
+====== Databases ======
+===== List Databases =====
 <code sql>
-mysql> SELECT User FROM mysql.user;
+mysql> show databases;
 </code>
-====== Change/Select Database ======
+===== Change/Select Database =====
 <code sql>
@@ Line 23: / Line 25: @@
 </code>
-====== List Tables ======
+====== Tables ======
+===== List Tables =====
 <code sql>
@@ Line 29: / Line 33: @@
 </code>
-List Table Columns
+===== List Table Columns =====
 <code sql>
@@ Line 55: / Line 59: @@
 </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>