Thanks :)
I tried >>>INSERT INTO newtable select * from cedict, english on IDX_c =
IDX_cedict<<<
("newtable" doesn't exist yet)
But that, predictably, didn't work.
First I should create a table with the right characteristics? (10+4 columns,
columns with the right names and characteristics)
I tried that using the structure of the two separate tables, but not
successfully yet. I'm a noobie.
CREATE TABLE cedict (IDX_c INTEGER PRIMARY KEY AUTOINCREMENT,GB TEXT NOT
NULL,GBS TEXT NOT NULL default '',gbslength INTEGER unsigned NOT NULL
default '0',PinyinNr TEXT COLLATE NOCASE NOT NULL default '',PinyinAcc TEXT
COLLATE NOCASE NOT NULL default '',PinyinRed TEXT COLLATE NOCASE NOT NULL
default '',Frequency INTEGER default '0',Frequency2 INTEGER default
'0',Frequency3 INTEGER default '0')
CREATE TABLE english (IDX_e INTEGER PRIMARY KEY AUTOINCREMENT,englword TEXT
COLLATE NOCASE NOT NULL default '',inserted INTEGER default '0',IDX_cedict
INTEGER default '0')
--
View this message in context:
http://old.nabble.com/Noobie-question-about-importing-data-into-table-tp29126116p29148702.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
