: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] DB table creation question
I think I may have gone over my head. I am fairly new to mysql and php.
My host only allows access to mysql via phpmysql. I am used to using
mysqlcc to connect to the db's and make changes. By default all tables
created
In addition to making sure both tables are type InnoDB, also make sure you have
indexed both the foreign key and its corresponding reference first (this will fix the
obtuse errno(150) message).
One suggestion I have is to take a bootcamp style class, even online, to solidify the
grasp of
,
last_modified_date datetime NULL,
);
-Original Message-
From: Matthew McNicol [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 18, 2004 5:46 PM
To: Vincent Jordan
Cc: [EMAIL PROTECTED]
Subject: [SPAM] Re: [PHP-DB] DB table creation question
use the mysql 'auto increment' on a 'int
: [PHP-DB] DB table creation
question
at the moment if a value is say inserted into the 'warranty_info' table
you are just checking that the 'product_id' or 'cust_id' already exists
in 'product_info' and 'customer_info'. you still have to populate them
first, otherwise the referential integrity
I am creating a database to keep track of our warranty returns.
Currently we do not have anything to track warranty info besides a big
excel file. I would like to keep customer data, product info and RMA
data in separate tables but still keep them related.
If I had table customers:
custid
use the mysql 'auto increment' on a 'int' 'customer_id' field to
generate a unique customer id.
the RMA number is associated with a 'customer_id' since the
'customer_id' field is in both the customers table and the RMA table.
Note that currently you have 'custid' and 'Customerid' respectively
Jordan
Cc: [EMAIL PROTECTED]
Subject: [SPAM] Re: [PHP-DB] DB table creation question
use the mysql 'auto increment' on a 'int' 'customer_id' field to
generate a unique customer id.
the RMA number is associated with a 'customer_id' since the
'customer_id' field is in both the customers table