Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Very Strange INNODB Problem (Please Read - May Affect YOU!!)
Please cast your eyes over this.... mysql> CREATE TABLE labour( -> labour_id INT AUTO_INCREMENT, -> workdate DATE, -> realstart TIME, -> starttime TIME, -> stoptime TIME, -> CONSTRAINT PRIMARY KEY (labour_id) ->... -
optional relationships
Is it possible to have optional relationships in mySQL? I have a table that stores jobs carried out by engineers and uses foreign keys to link to the different types of job that they may do. Here is the table: CREATE TABLE job( job_id INT AUTO_INCREMENT... -
constraints not registering
Hi all, I am trying to create a database table that will act like a linked list by using self referencing. I have used the following definitions: CREATE TABLE partslist( id INT AUTO_INCREMENT, PRIMARY KEY(id), partid INT NOT NULL, INDEX...
