summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFrancesco Borzì <borzifrancesco@gmail.com>2019-02-24 17:17:49 +0100
committerGitHub <noreply@github.com>2019-02-24 17:17:49 +0100
commitd8d1823802ded97300fa57405d80b16736603489 (patch)
tree7d578aac66bf3ac9c798ee717ed98e5b95a966e0
parent525033fe4f38dc3f784de7c4312e48f92860c477 (diff)
downloadwiki-d8d1823802ded97300fa57405d80b16736603489.tar.gz
wiki-d8d1823802ded97300fa57405d80b16736603489.tar.bz2
wiki-d8d1823802ded97300fa57405d80b16736603489.zip
Update Dealing-with-SQL-files.md
-rw-r--r--docs/Dealing-with-SQL-files.md12
1 files changed, 6 insertions, 6 deletions
diff --git a/docs/Dealing-with-SQL-files.md b/docs/Dealing-with-SQL-files.md
index c87a28b..bd08987 100644
--- a/docs/Dealing-with-SQL-files.md
+++ b/docs/Dealing-with-SQL-files.md
@@ -24,7 +24,7 @@ Compact code helps to keep the size of our SQL update files small, so installing
Bad:
-```SQL
+```sql
INSERT INTO `table_1` VALUES (1000, ...);
INSERT INTO `table_1` VALUES (2000, ...);
INSERT INTO `table_1` VALUES (3000, ...);
@@ -33,7 +33,7 @@ INSERT INTO `table_1` VALUES (3000, ...);
Good:
-```SQL
+```sql
INSERT INTO `table_1` VALUES
(1000, ...),
(2000, ...),
@@ -44,7 +44,7 @@ INSERT INTO `table_1` VALUES
Bad:
-```SQL
+```sql
UPDATE `table_1` SET `field_1` = 'someValue' WHERE `entry` = 1000;
UPDATE `table_1` SET `field_1` = 'someValue' WHERE `entry` = 2000;
UPDATE `table_1` SET `field_1` = 'someValue' WHERE `entry` = 3000;
@@ -52,7 +52,7 @@ UPDATE `table_1` SET `field_1` = 'someValue' WHERE `entry` = 3000;
Good:
-```SQL
+```sql
UPDATE `table_1` SET `field_1` = 'someValue' WHERE `entry` IN (1000, 2000, 3000);
```
@@ -60,7 +60,7 @@ UPDATE `table_1` SET `field_1` = 'someValue' WHERE `entry` IN (1000, 2000, 3000)
Bad:
-```SQL
+```sql
DELETE FROM `table_1` WHERE `entry` = 1000;
DELETE FROM `table_1` WHERE `entry` = 2000;
DELETE FROM `table_1` WHERE `entry` = 3000;
@@ -68,7 +68,7 @@ DELETE FROM `table_1` WHERE `entry` = 3000;
Good:
-```SQL
+```sql
DELETE FROM `table_1` WHERE `entry` IN (1000, 2000, 3000);
```