Re: better table structure: 30 records in 2 column table or one record in 30 columns table

2006-12-02 Thread Philip Mather
[EMAIL PROTECTED], hi, i'm created a 'configuration' table: create cofiguration ( config_key VARCHAR(25) NOT NULL PRIMARY KEY, config_value VARCHAR(255) NOT NULL ) ENGINE=MyISAM; I have about 30 records (store_name, store_owner, template_name, website_width, owner_address, prodcuts_per_page,..

Re: Stored procedure parameters problem

2006-12-02 Thread Paul DuBois
At 11:34 AM -0800 12/1/06, Chris White wrote: On Friday 01 December 2006 11:22, Ed Reed wrote: I have a problem/question I'd like to find someone else to verify/answer for me. I'm using MySQL 5.1.09 running on Netware. I've created a stored procedure that has one parameter, Create Procedu

better table structure: 30 records in 2 column table or one record in 30 columns table

2006-12-02 Thread afan
hi, i'm created a 'configuration' table: create cofiguration ( config_key VARCHAR(25) NOT NULL PRIMARY KEY, config_value VARCHAR(255) NOT NULL ) ENGINE=MyISAM; I have about 30 records (store_name, store_owner, template_name, website_width, owner_address, prodcuts_per_page,..). now i wonder is m