Withdata Software provide some ETL (Extract-Transform-Load) tools for SQLite: FileToDB Load TXT, CSV, TSV, XML, JSON, Excel, SQL, RDF, INI data to SQLite DBToFile Export SQLite data to TXT, CSV, TSV, XML, JSON, Excel, SQL files DBCopier Copy data between SQLite and other rational ... Read more
Category Archives: Sqlite
How to get index column names of a table from SQLite
select sql from sqlite_master where tbl_name='my_table_name' and type='index' you can find the index name and column names in ‘sql’ field. See also: How to get index column names of a table from DB2 How to get index column names of a table from SQL Server How to get index column names ... Read more
How to get primary key of a table from SQLite
Run PRAGMA table_info('my_table_name') find the record that column ‘pk’ is 1, it’s the primary key. See also: How to get primary key of a table from PostgreSQL How to get primary key of a table from MySQL How to get primary key of a table from SQL Server How to get primary key ... Read more
How to generate a CREATE TABLE statement for a given table in SQLite
select sql from sqlite_master where type='table' and tbl_name='country' See also: How to generate a CREATE TABLE statement for a given table in SQL Server How to generate a CREATE TABLE statement for a given table in Oracle How to generate a CREATE TABLE statement for a given table in ... Read more
How to get column names from SQLite table
PRAGMA table_info(table_name); see also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Oracle table How to get column names from Mysql table How to get column names from PostgreSQL table Some SQLite tools you can try: ... Read more
How to limit the number of rows returned by a Sqlite query
In MySQL, you can use “Limit <skip>,<count>”, like this: select * from sometable order by name limit 20,10 How to do in Sqlite? You can still use “Limit <skip>,<count>”: select * from sometable order by name limit 20,10 or use equivalent query ... Read more
Replace Update or Insert a row Into Sqlite Table
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in Sqlite? Use “INSERT OR REPLACE INTO” . For example: INSERT OR REPLACE INTO Employee ... Read more