On 22 Oct 2012, at 2:00am, Guillaume Saumure <gsaumur...@videotron.ca> wrote:
> For the moment I use "DELETE FROM table_name" as a workaround but what's > wrong with Truncate instruction ? It's not standard original SQL, it was introduced by one particular manufacturer who wanted things done a particular way and has been adopted as a standard since (2008, only three years ago). It is handled differently by different manufacturers so it helps to be an expert on one particular version of SQL if you want to know exactly what it does. SQLite correctly handles the standard SQL form "DELETE FROM table_name" to do exactly what you want in an efficient way. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
