diff options
| author | Francesco Borzì <borzifrancesco@gmail.com> | 2019-02-24 17:17:49 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-02-24 17:17:49 +0100 |
| commit | d8d1823802ded97300fa57405d80b16736603489 (patch) | |
| tree | 7d578aac66bf3ac9c798ee717ed98e5b95a966e0 /docs | |
| parent | 525033fe4f38dc3f784de7c4312e48f92860c477 (diff) | |
| download | wiki-d8d1823802ded97300fa57405d80b16736603489.tar.gz wiki-d8d1823802ded97300fa57405d80b16736603489.tar.bz2 wiki-d8d1823802ded97300fa57405d80b16736603489.zip | |
Update Dealing-with-SQL-files.md
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/Dealing-with-SQL-files.md | 12 |
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); ``` |
