6 messages in com.mysql.lists.plusplusRe: New Bie query:| From | Sent On | Attachments |
|---|---|---|
| Dr. BVLS Prasad | 22 May 2007 10:40 | |
| Warren Young | 22 May 2007 15:03 | |
| Dr. BVLS Prasad | 22 May 2007 16:00 | |
| Drew M. | 22 May 2007 18:46 | |
| Warren Young | 22 May 2007 19:38 | |
| Dr. BVLS Prasad | 22 May 2007 23:53 |
| Subject: | Re: New Bie query: |
|---|---|
| From: | Warren Young (mysq...@etr-usa.com) |
| Date: | 05/22/2007 07:38:35 PM |
| List: | com.mysql.lists.plusplus |
Dr. BVLS Prasad wrote:
a) I have to create the database , table using the methods available and the query object
You don't have to use MySQL++ to create the database. It's one way, but MySQL++ doesn't limit you. It's completely up to you how you create the database and the tables within it.
b) insert the data and /or execute the queries using query object. b) then use ssqls to access the data from the table in / out of order keeping the parameters same/similar.
You can do all of this with SSQLS. See examples/custom*.cpp.
wouldnt it be nice to create an object which will automatically create the table schema and also table "named" structure.?
Yes, it would. If you are volunteering to write that code, read the HACKERS file before submitting your patch.
(especially it will be most comfortable to the work running into millions of schemas and trillions of data in the form of rows as is the case with biological sequences and structures.)
If you have trillions of rows, it seems to me that the process of creating the database schema is the least of your problems. But if you feel you must expend effort to solve it more elegantly, I won't stand in your way.