Search found 1 match

by maben
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...