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

Reply via email to