[Jud202]

This is a great tutorial but I have one issue, see the output below:

mysql> select*from products;
+-----------+------------+-------------+-----------+
| ProductID | SupplierID | ProductName | UnitPrice |
+-----------+------------+-------------+-----------+
|     00001 |      00001 | Chocolates  |     10.50 |
+-----------+------------+-------------+-----------+
1 row in set (0.15 sec)

mysql> insert into products (supplierID, productname, unitprice) value ('2','Beads', '5');
Query OK, 1 row affected (0.00 sec)

mysql> select*from products;+-----------+------------+-------------+-----------+
| ProductID | SupplierID | ProductName | UnitPrice |
+-----------+------------+-------------+-----------+
|     00001 |      00001 | Chocolates  |     10.50 |
|     00002 |      00002 | Beads       |      5.00 |
+-----------+------------+-------------+-----------+
2 rows in set (0.03 sec)

mysql> insert into products (supplierID, productname, unitprice) value ('10','Beads', '5');
Query OK, 1 row affected (0.00 sec)

mysql> select*from products;+-----------+------------+-------------+-----------+
| ProductID | SupplierID | ProductName | UnitPrice |
+-----------+------------+-------------+-----------+
|     00001 |      00001 | Chocolates  |     10.50 |
|     00002 |      00002 | Beads       |      5.00 |
|     00003 |      00010 | Beads       |      5.00 |
+-----------+------------+-------------+-----------+
3 rows in set (0.00 sec)

mysql> select*from suppliers;
+------------+--------------+-------------+------------------+
| SupplierID | SupplierName | Phone       | Email            |
+------------+--------------+-------------+------------------+
|      00001 | ABCSupplier  | 14036801234 | abc@dicforum.com |
+------------+--------------+-------------+------------------+
1 row in set (0.00 sec)

and as you can see I did not get an error and I actually have 3 products existing with only 3 different supplier IDs but only 1 actual supplier.

Any reason why this might happen?

I also tried remaking a new database incase I had a typo and I got the same thing.

[JackOfAllTrades]

Are you SURE you added the FOREIGN KEY, as shown here:

ALTER TABLE Products
ADD FOREIGN KEY (SupplierID) REFERENCES Suppliers (SupplierID);

?

[canxoniam]

hey thanks

[hmmcode]

rapheal2k8, on 27 April 2009 - 07:12 AM, said:

Hi!..After typing
INSERT INTO suppliers (SupplierName, Phone, Email) VALUE (‘ABCSupplier’,’1122334455’,’abc@dicforum.com’);

i got this '> and nothing i type seems to do anything. pls help me out.

Hi!..After typing
INSERT INTO suppliers (SupplierName, Phone, Email) VALUE (‘ABCSupplier’,’1122334455’,’abc@dicforum.com’);

i got this '> and nothing i type seems to do anything. pls help me out.

I have the same problem after typing in that line of code. Did anyone realsie why that happened? Many thanks!

I have the same problem as rapheal2k8 - I get new lines with'> instead of -> and the program doesnt return anything else. Does anyone know why this may have happened? Thanks in advance

[James_Smith]

Nice and informative MySQL guide for beginners with all necessary detailed information to learn and understand. Great work, keep it up. Thumps up for your effort.