Thanks. What about INSERT query behavior. Is their any specific reason of allowing inserting same data set which is already present in database ?
Cheers - On 8/30/13, Clemens Ladisch <[email protected]> wrote: > techi eth wrote: >> I have open the connection, created the table by using CREATE TABLE IF >> NOT >> EXISTS , doing some operation & closing the connection. >> >> If I again open the connection & try to do table creation again (With >> same >> table name & same database file) then what will be the behavior? >> >> I am expecting it should not create table & return me error, because >> their >> is already table with same name exists. > > RTFM <http://www.sqlite.org/lang_createtable.html>: > | It is usually an error to attempt to create a new table in a database > | that already contains a table of the same name. However, if the "IF > | NOT EXISTS" clause is specified as part of the CREATE TABLE statement > | and a table of the same name already exists, the CREATE TABLE command > | simply has no effect (and no error message is returned). > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
