Search found 1 match
- 09.06.2007, 09:53
- Forum: SQLite Administrator
- Topic: DATA Field Problem
- Replies: 1
- Views: 2001
DATA Field Problem
I have to convert a db table from (small example): CREATE TABLE [dataold] ( [id] INTEGER NULL PRIMARY KEY, [data_txt] TEXT NULL ) to the table: CREATE TABLE systems (id INTEGER NOT NULL PRIMARY KEY,date DATE) I an insert for the migration: INSERT INTO 'systems' SELECT id, data_txt FROM 'dataold'; Th...