Hello everyone,
I would like to suppress all row inside an existing table before
inserting new element. To to this I would like to use "TRUNCATE TABLE
table_name" as suggested here http://www.w3schools.com/sql/sql_drop.asp.
And this is the error I get when I try to do this :
near "TRUNCATE": syntax error
For the moment I use "DELETE FROM table_name" as a workaround but what's
wrong with Truncate instruction ?
Thanks beforehand.
Guillaume
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users