Gossamer Forum
Home : Products : DBMan SQL : Discussion :

How to create more than 1 table

Quote Reply
How to create more than 1 table
 
Hello,

I have a question regarding creating more than 1 table, is it possible? (Iam newbie to mySQL thing) please help:

Right now I have, let say, 3 flat texts database that I use.
Code:
First flat text database contains 17 fields:
'ID'
'Date'
'HScode'
'Name'
'Email'
'Company'
'Address'
'City'
'State'
'Zip'
'Country'
'Phone'
'Fax'
'Homepage'
'Subject'
'Details'
'RemoveAd'

Second flat text database contains 20 fields:
'ID'
'Company'
'Category'
'Description'
'Group'
'Address'
'City'
'Zip'
'Country'
'Phone'
'Fax'
'Name'
'Email'
'Homepage'
'Product1'
'Product2'
'Product3'
'Product4'
'Continent'
'Turnover'

Third database contains 26 fields
'ID'
'Date'
'CategoryInq'
'ProductName'
'Quantity'
'Specs'
'DeadDay'
'DeadMonth'
'DeadYear'
'PaymentTerms'
'UsanceDay'
'SaleTerms'
'SalePort'
'Transferable'
'BuyersLocation'
'SeekProductFrom'
'BuyerIs'
'BuyingFrequency'
'Details'
'Name'
'Email'
'Company'
'City'
'Country'
'Phone'
'Fax'
Now, can I make them in one table mysql?
I assume that when I do the setup for fields, I have to include all the name fields above on the cfg files, am I correct?

__________________________
SantanaBlank
Quote Reply
Re: How to create more than 1 table In reply to
In Reply To:
I have a question regarding creating more than 1 table, is it possible? (Iam newbie to mySQL thing) please help:
Yes it is possible, in fact it is preferable, certainly in your example.

In Reply To:
Right now I have, let say, 3 flat texts database that I use.
You would create a table for each of your "flat-text" files.

In Reply To:
Now, can I make them in one table mysql?
You can, but I would heartily recommend against it.

In Reply To:
I assume that when I do the setup for fields, I have to include all the name fields above on the cfg files, am I correct?
Yes...although database schema and design is beyond the scope of this reply at the moment (I'm running late for an appointment)...If no one has jumped in to assist further I can elaborate when I return - sorry :(

The simplest way for you to get started and get your feet wet so to speak is use the nph-setup.cgi file and your 3 different cfg files (make sure you check the format of the included cfg file with dbSQL - there is an added field for "Is field indexed"). Run nph-setup.cgi 3 times - before each time editing within nph-setup.cgi the hard-coded cfg file name to match each of your cfg file names. Look on line 55 of nph-setup.cgi.

2 most important things to do for now to get you started :

1. Make sure your cfg files match the format of the included db.cfg noting the extra field definition as mentioned above.
2. Edit nph-setup.cgi before each time you run it to reflect the cfg file name you are going to create a table for.

Hope that gets you started.

easy does it
Quote Reply
Re: How to create more than 1 table In reply to
Ok, I see.

Clear enough for now. Let me try to get my mysql setup at addr.com, it's been too long for them to setup one for me. :(

I will let you know after I try it. But please advise me anything for Dos and Don'ts for setting up/converting databases.

Thanks so much.

__________________________
SantanaBlank
Quote Reply
Database name In reply to
Hello,

I am still stuck waiting for addr.com asnwer my questions.

Here is my case:
Code:
1. I don't know the database name and password
2. when I type mysql, then the promt gives me
Welcome to mySQL monitor. Commands end with ; or \g
Your mySQL conenction id is 312 to server version
3.21.33b

Type 'help' for help.

mysql>
- How can I create database name without login into root. Is it possible?
- How can I see what my database name is. In case they already set one for me.



best regards
Santana



__________________________
SantanaBlank
Quote Reply
Re: Database name In reply to
In Reply To:
1. I don't know the database name and password
You are going to need these before you can go any further...mysql shell is not going to help you until you get this info from your host provider.



easy does it
Quote Reply
It works. In reply to
Thank you so much for you help. it works.

I'll invite you to our website when it is done. :)