In php & mysql I am used to being able to do multi row inserts into a table using;
INSERT INTO table (column1,column2) VALUES (val1,val2),(val3,val4)
Is there any Sqlite equivalent? I need to populate around 100 rows on first run of a mobile application.
If what _spoboyle recommends doesn't work in AIR and if you haven't already, look into the SQLConnection.begin() and commit(). It seems at least you can group your SQL transactions.
commit(). It seems at least you can group your SQL transactions.
Retrieving data ...