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
Subject Author Views Date
Thread How to create more than 1 table santana 2896 Nov 8, 2000, 4:47 AM
Thread Re: How to create more than 1 table
Bearwithme 2821 Nov 8, 2000, 7:31 AM
Post Re: How to create more than 1 table
santana 2813 Nov 8, 2000, 9:13 AM
Thread Database name
santana 2779 Nov 9, 2000, 8:39 PM
Thread Re: Database name
Bearwithme 2789 Nov 10, 2000, 8:16 AM
Post It works.
santana 2747 Nov 11, 2000, 5:04 AM