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 2842 Nov 8, 2000, 4:47 AM
Thread Re: How to create more than 1 table
Bearwithme 2767 Nov 8, 2000, 7:31 AM
Post Re: How to create more than 1 table
santana 2759 Nov 8, 2000, 9:13 AM
Thread Database name
santana 2725 Nov 9, 2000, 8:39 PM
Thread Re: Database name
Bearwithme 2735 Nov 10, 2000, 8:16 AM
Post It works.
santana 2693 Nov 11, 2000, 5:04 AM