YES!!! THAT WORKS !!!
Thank you to all the repliers :)
--
View this message in context:
http://old.nabble.com/Noobie-question-about-importing-data-into-table-tp29126116p29148819.html
Sent from the SQLite mailing list archive at Nabble.com.
___
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)
Can somebody point me in the right direction?
I have joined the two tables by doing: select * from ChineseTable,
EnglishTable on IDX_c = IDX_cedict
Now I would like to save this as a new table, so I can manipulate this table
in sqlite and other programs.
Thank you for any replies :)
--
View
Eric Smith-29 wrote:
>
> It could be that you want to create a real table that can be read from
> and written to. I would then ask why you think you need to do that.
Thank you very much for your help! Now I've joined the tables using the
"join" query.
I think I need to create the new table
Thanks for your reply. Before I try to understand your post, because you are
here now and maybe not later:
I will take the result (of 50.000 + lines), and further filter it to 5.000 +
lines, and then split that into 13 tables of 400+ lines, which I'll be
manipulating in excel, and print out to
>What do you mean, "save"?
So that when you're done, you have 3 tables "Chinese," "English," "Merged"
or the original 2, but with data from the one into the other.
I don't know the terms or the procedure, but I'd like to have a new table
that has the Chinese and English mixed, which I then can
Okay, so now I've gotten a bit further, but:
-- One table is more than 30.000 lines, the other is more than 50.000 lines.
I've understood from the video tutorial that the program (I'm using
http://www.sqlite.org/sqlite-3_6_23_1.zip) will first compile the entire
list 30.000 x 50.000 = 1.5
Thanks for your reply!
I'm now trying to get it to work, with the help of your post and this nice
http://www.youtube.com/watch?v=NcrZoHselPk video tutorial about joining
--
View this message in context:
Another method would be to add a column to the English table, and in that
insert the Chinese character that corresponds with the number in "Chinese
Char. No."
--
View this message in context:
http://old.nabble.com/Noobie-question-about-importing-data-into-table-tp29126116p29126166.html
Sent
Hi,
I'm a noobie. I would have liked to first search this forum, but I don't
even know the search terms I should use ...
I'm using the firefox plugin "Sqlite Manager" to manipulate the data.
Question:
I have two tables:
TABLE 1:
Chinese Char. No. Chinese Char.
1
10 matches
Mail list logo