Differences

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

Link to this comparison view

Next revision 		Previous revision
development:database:mysql [2020/10/23 11:58]
kalenpw created 		development:database:mysql [2021/06/29 19:38] (current)
kalenpw [update]
Line 31: Line 31:
 ---- ----
 ===== Basic syntax ===== ===== Basic syntax =====
-==== update ====+**update**\\
 <code mysql> <code mysql>
 UPDATE employees SET email = 'user@domain.com' WHERE id = 123; UPDATE employees SET email = 'user@domain.com' WHERE id = 123;
Line 58: Line 58:
   c.id = 28;   c.id = 28;
 </code> </code>
 +
 +----
 +===== Util =====
 +<code mysql>
 +-- list number of rows in each table
 +SELECT table_name, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'TABLE_NAME' ORDER BY TABLE_ROWS DESC;
 +</code>
 +----