Linked Questions

In MySQL I'd use INSERT INTO `mytable` (`col1`, `col2`) VALUES (1, 'aaa'), (2, 'bbb'); but this causes an error in SQLite. What is the correct syntax for SQLite?

I am using sqlite3 and trying to put data into my database. INSERT INTO Structure VALUES ('521D5E7ABC165','1','DECODE','T','4','Y','Y'), ('521D5E7ABC165','2','DEDESC','T','40','N','Y'), ('...

I searched the hinted posts, when posting this question but I foud none similar, so I apologize if I missed any. Here's my problem. I created a table and it's fields, in SQLite Administrator, then I ...

I'm trying to insert values into table public class DatabaseHandler extends SQLiteOpenHelper { private final static String INSERT_INTO_COUNTRIES = "INSERT INTO " + TABLE_COUNTRIES ...

I'm getting this RuntimeException when executing an AsyncTask: Caused by: android.database.sqlite.SQLiteException: near ",": syntax error: , while compiling: INSERT INTO 'infrastructure' (lift,name,...

I am new to android. I haven't worked with SQLite DBs before. I think this is a very basic question, but I am unable to find the solution. The code is here (assume declarations) public void onCreate(...

I am developing a application for Android using PhoneGap. I am trying to insert multiple records to table in a single query using Javascript. I am getting a error like syntax error near ",". My Code :...

Hi I have the following Mysql code (Which i export from Mysql DB before I delete my tables from it). Now I have a MySQLlite DB, and I have the corresponding tables in this database. But when I run the ...

I am facing problem from long time. I am dynamically generating insert query in android SQLite database it throws following error. android.database.sqlite.SQLiteException: near "(": syntax ...

An error occurs when I try to add mulitple rows to the sqlite database. With a single row theres no problem. Additionally the app crashes due to this on a samsung galaxy s2, but not on a nexus. ...

i have a Sqlite problem in my tablet Android 4.0.3v; Error: 07-28 14:28:18.495 6995-7125/com.titan.tablet E/AndroidRuntime﹕ FATAL EXCEPTION: Thread-544 android.database.sqlite.SQLiteException: ...

I use sql query to insert data into database, everything work fine if i insert just one record into table,here is my code 1. setData("insert into table(name,age) values ('john','23')"); code for ...

So I created this DB. private static final String NOME_DB = "bancomuseu.db"; public static final String TABELA = "tbl_itens"; public static final String ID = "id"; public static ...

I'm trying to insert multiple rows at once using the new syntax introduced in SQLite 3.7.11 I have 3.8.10.2 so this should work fine, but it doesn't. INSERT OR IGNORE INTO leaderheadsplayers (name, ...

A java application I am working on uses local SQLite databases for certain data, using https://bitbucket.org/xerial/sqlite-jdbc version 3.8.10.2. I parse data from an excel spreadsheet and then ...