CREATE TABLE

2004-01-23 Thread Jeremiah Jacks
Help! I am totally stumped. Why won't this execute successfully? CREATE TABLE user_shipping_info ( user_id INT UNSIGNED NOT NULL, as_acct VARCHAR(8) NOT NULL, email_address VARCHAR(40), company VARCHAR(50), phone_number VARCHAR(15), fax_number VARCHA

RE: Basic Database Design Question

2003-07-29 Thread Jeremiah Jacks
You could do it many different ways. Here's one that I would consider: Create a table to store the business sections (buss_section) and a table to relate the apps with the business sections (app_buss_section). The design would abstract the app info from its usage and create a manageable table of bu

Error with foreign key constraint when updating

2003-07-28 Thread Jeremiah Jacks
I just upgraded to MySQL 4.0.14-standard for RedHat Linux and am using the pre-compiled binaries. I have a database with INNODB tables. When I insert a row into one of the child tables, I get the following MySQL error: INSERT INTO product_access_level (product_id,access_level_id) VALUES ('10201'