On Fri, 11 Dec 2009, Florian Schricker wrote: > Schema of DB (simplified): > - Oper (string) > - Product (string) > - Category (string) > - Name (string) > - CreateTS (Timestamp) > - Value (Double)
Florian, The schema refers to the set of tables, and the attributes within each table. Is the above one table or a set of tables. > Primary keys are Oper, Product, Category, Name and CreateTS There is only one primary key per table. > Can I do that in SQL in one query? I urge you to learn about database design and SQL. You can find a lot of information on the Web and there are many good books on each topic. Only one of the above attributes is specified as 'Double', yet you write about dumping data as doubles into each one. Step back and do some learning before you dig a big hole and fall into it. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
