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 3803 Nov 8, 2000, 4:47 AM
Thread Re: How to create more than 1 table
Bearwithme 3704 Nov 8, 2000, 7:31 AM
Post Re: How to create more than 1 table
santana 3698 Nov 8, 2000, 9:13 AM
Thread Database name
santana 3658 Nov 9, 2000, 8:39 PM
Thread Re: Database name
Bearwithme 3666 Nov 10, 2000, 8:16 AM
Post It works.
santana 3628 Nov 11, 2000, 5:04 AM