Thats not it is it, i'm searching the net but just getting more confused.
Please point me in the direction of a location where ANSI SQL is clearly explained with examples.

Or let me rephrase my question.
Got a MySQL database and i want to create ANSI SQL script files that function as update files. One script file per table seems appropriate. The reason for ANSI SQL is that i want the database to be available to non-MySQL users as well. Obviously providing the used database application can handle ANSI SQL script files. If not i provide basic .CSV file.

What is the syntax in ANSI SQL to delete then insert records ?