Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
development:database:mysql [2020/12/29 13:50]
kalenpw 		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 65: Line 65:
 SELECT table_name, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'TABLE_NAME' ORDER BY TABLE_ROWS DESC; SELECT table_name, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'TABLE_NAME' ORDER BY TABLE_ROWS DESC;
 </code> </code>
 +----