Carlo S. Marcelo <[EMAIL PROTECTED]> wrote: > Below is the syntax and error I received. > > [EMAIL PROTECTED] root]# sqlite > /var/local/database/dblist "insert into > list ('0,0,newblacklistentry1,com') values > ('0,0,newblacklistentry1.com')" > SQL error: table list has no column named > 0,0,newblacklistentry1,com
This statement makes no sense. In the first pair of parens, you are supposed to provide a list of column names. In the second, a list of values. A new row is inserted, in which specified columns are set to specified values (and columns that were not mentioned, if any, take on their default values). Something like this: insert into list(column1, column2, column3) values (0, 0, 'newblacklistentry1.com'); > What I am trying to do here is create a script that > will populate the database with a hundred thousand > entries (no duplicates). Perhaps you can use .import directive supported by sqlite command line shell. You need a file in CSV format, one row per record. Then just do .import filename tablename Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users