diff options
| -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 |