On 4 Jun 2009, at 7:39am, liubin liu wrote: > INSERT OR REPLACE INTO data (num, di, time1) VALUES (12, '1290', > '732e4a390000', 8323000, 8323255, 22); > > the sqlite3 report a error: > SQL error: 6 values for 3 columns > > Does It mean the method isn't the right way?
Here are 6 values: > VALUES (12, '1290', > '732e4a390000', 8323000, 8323255, 22); Here are 3 columns: > (num, di, time1) It does not know which column to put which value in. If you give it 6 values you must list 6 columns. Value 1 goes into column 1, value 2 goes into column 2, an so on. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
