Re: [sqlite] Noobie question about importing data into table

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. ___

Re: [sqlite] Noobie question about importing data into table

On Tue, 13 Jul 2010, Calimeron wrote: > > 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

Re: [sqlite] Noobie question about importing data into table

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)

Re: [sqlite] Noobie question about importing data into table

On 13 July 2010 10:22, Calimeron wrote: > > 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

Re: [sqlite] Noobie question about importing data into table

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

Re: [sqlite] Noobie question about importing data into table

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

Re: [sqlite] Noobie question about importing data into table

On 10 Jul 2010, at 5:39pm, Calimeron wrote: > -- 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

Re: [sqlite] Noobie question about importing data into 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

Re: [sqlite] Noobie question about importing data into table

Calimeron wrote: > >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

Re: [sqlite] Noobie question about importing data into table

>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

Re: [sqlite] Noobie question about importing data into table

Calimeron wrote: > I've understood 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 BILLION lines, after which it filters > it. One of SQLite's primary goals in life is to fit into a tiny memory footprint.

Re: [sqlite] Noobie question about importing data into table

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

Re: [sqlite] Noobie question about importing data into table

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:

Re: [sqlite] Noobie question about importing data into table

Calimeron wrote: > Chinese Char. No. Chinese Char. English Def. No.English Def. > 1 Char1 1 Def1 > 2 Char2 2 Def2 > 2 Char2 3 Def3

Re: [sqlite] Noobie question about importing data into table

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

[sqlite] Noobie question about importing data into table

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