Differences

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

--- development:database [2020/02/27 23:06]
kalenpw [Basic syntax]
+++ — (current)
@@ Line 1: / Line 1: @@
-====== Database ======
-----
-===== Grant permissions =====
-replace ''*.*'' with ''schema.table'' if needed
-<code mysql>
-GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
-</code>
-===== Basic syntax =====
-==== update ====
-<code mysql>
-UPDATE employees SET email = 'user@domain.com' WHERE id = 123;
-</code>
-----
-===== Many to Many Relationship Joins =====
-<code mysql>
-SELECT
-  a.*
-FROM
-  map_ads_categories m
-  JOIN ads a ON (m.ad_id = a.id)
-WHERE
-  m.category_id = 28;
-</code>
-<code mysql>
-SELECT
-  *
-FROM
-  map_ads_categories m
-  JOIN ads a ON (m.ad_id = a.id)
-  JOIN categories c ON (m.category_id = c.id)
-WHERE
-  c.id = 28;
-</code>