From 5d4db1a2f9101b7d9e21bd40ee29c5d3d1070b99 Mon Sep 17 00:00:00 2001 From: Francesco Borzì Date: Sun, 17 Mar 2019 23:24:46 +0100 Subject: Update Dealing-with-SQL-files.md --- docs/Dealing-with-SQL-files.md | 2 ++ 1 file changed, 2 insertions(+) (limited to 'docs') 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 -- cgit