On Thu, Jan 21, 2010 at 07:55:14AM -0800, newlog scratched on the wall:
> Keyword-01 Foo 12.007 Bar 24.9682 > Keyword-02 64738 65535 12.12 3.1415 2.71 0.007 > Keyword-03 SingleString > ... > > So my question is : how to create a table in which rows (keywords) > could contain variable type SQLite supports different types out of the box. > and number of data ? You don't. That's not what databases are about. If you have variable attributes that match to single keyword, you want to setup a one-to-many relation between two tables. Find a good intro to database normalization; that should point you to a good example of this fairly quickly. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
