diff options
| author | Francesco Borzì <borzifrancesco@gmail.com> | 2019-03-17 23:24:46 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-03-17 23:24:46 +0100 |
| commit | 5d4db1a2f9101b7d9e21bd40ee29c5d3d1070b99 (patch) | |
| tree | 9fde0897539a33bf90dcd77351b425c0fb8df5b4 /docs/Dealing-with-SQL-files.md | |
| parent | 47e5b69b9d4cd2bcec50ef3e3c6393f642ce2c43 (diff) | |
| download | wiki-5d4db1a2f9101b7d9e21bd40ee29c5d3d1070b99.tar.gz wiki-5d4db1a2f9101b7d9e21bd40ee29c5d3d1070b99.tar.bz2 wiki-5d4db1a2f9101b7d9e21bd40ee29c5d3d1070b99.zip | |
Update Dealing-with-SQL-files.md
Diffstat (limited to 'docs/Dealing-with-SQL-files.md')
| -rw-r--r-- | docs/Dealing-with-SQL-files.md | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/docs/Dealing-with-SQL-files.md b/docs/Dealing-with-SQL-files.md index bd08987..f68e9e3 100644 --- a/docs/Dealing-with-SQL-files.md +++ b/docs/Dealing-with-SQL-files.md @@ -10,6 +10,8 @@ Also remember to: - use [INSERT](http://www.w3schools.com/sql/sql_insert.asp) in order to insert **new rows only**, but be sure to avoid import errors using [DELETE](http://www.w3schools.com/sql/sql_delete.asp) before INSERT +- whenever possible, try to make your query **re-executable** (the same query can run twice without error) e.g. deleting before inserting + - surround any table or field name with `backticks`, and string values with `single quotes`, example: ```sql |