January 5th, 2003, 01:30 PM
mysql> create database dbname;
Query OK, 1 row affected (0.00 sec)
mysql> use dbname;
mysql> create table feedback(
-> fe_id int auto_increment,
-> fe_country text,
-> fe_product text,
-> fe_model varchar(10),
-> primary key (fe_id));
Query OK, 0 rows affected (0.47 sec)
you would then have separate tables for your products and models - each with their own PK's, but models would join to products with a mo_prid field.
This is me: http://chris.uk.com
Last edited by christo : January 6th, 2003 at 05:18 AM.