Mysql syntax

2001-07-20 Thread temu-jin
I have been trying to figure out how to do this, and I am sure that I am just overlooking somthing small. Suppose I create two tables as follows: CREATE TABLE system ( sysid INT NOT NULL UNSIGNED AUTO_INCREMENT PRIMARY KEY, sysname VARCHAR(12), os VARCHAR(10), cpumhz INT ); CRE

Multiple Tables

2001-07-19 Thread temu-jin
I have been looking through the documentation and searching through the list for answers to this question, but have not yet figured out how to do so. Basically, I want to have multiple tables linked together. I have seen a lot of talk about foreign keys and that MySQL does not support them. I