Withdata software has announced db2tosqlite 1.0, a data conversion tool that convert DB2 data to SQLite database. Version 1.0 is the first release. DB2ToSqlite – Convert DB2 data to SQLite DB2ToSqlite is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress, ... Read more
Tag Archives: Sqlite
Withdata Software Released AccessToSqlite Version 1.0
Withdata software has announced accesstosqlite 1.0, a data conversion tool that convert Access data to SQLite database. Version 1.0 is the first release. AccessToSqlite – Convert Access data to SQLite AccessToSqlite is convenient: 1. Easy visually config, just click on the mouse. 2. ... Read more
How to View PDF stored in Sqlite BLOB field
Some time you need view pdf stored in SQLite blob field, how to do it? I suggest you try SqliteLobEditor, you can download it form here: http://www.withdata.com/down/SqliteLobEditor.exe . Run SqliteLobEditor, execute query, and click the “BLOB” grid that contains PDF data. then ... Read more
Withdata Software Released Withdata SqliteToExcel 1.0
Withdata software has announced withdata sqlitetoexcel 1.0, a data conversion tool that export SQLite data to excel. Withdata SqliteToExcel 1.0 is first release version. Withdata SqliteToExcel – Export SQLite data to Excel Withdata SqliteToExcel is convenient: 1. Easy visually config, just ... Read more
Withdata Software Released TxtToSqlite Version 1.0
Withdata software has announced txttosqlite 1.0, a data conversion tool that import csv(txt) data to SQLite database. TxtToSqlite 1.0 is the first release version. TxtToSqlite – A Better Way to import CSV(TXT) data to Sqlite TxtToSqlite is convenient: 1. Easy visually config, just click on ... 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