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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jjjamie
-
Is there an Advanced MySQL Manual?
That hardly sounds like an advanced book! -
Getting/copying a remote database...
Can you explain how you did it? I can't seem to find the tool you refer to. -
Storing Credit Card #'s
I was just reading this interesting thread... Did you ever work out a solution? -
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
I have just upgraded to 4.0.4-beta-max and it now works fine :) Thanks for your help -
optional relationships
I see your point. I will probably use -1 as 'NOT APPLICABLE' (being more appropriate than NULL). I still find it strange that I can't use NULL values though... -
tutoriel about vc++ and mysql
Why not use Visual Basic and connect to MySQL using MyODBC? I know you can probably do this in Visual C++ but in VB it's as easy as pie! [2thumbsup] -
optional relationships
I have just checked my installation and I have 4.0.1-alpha. Here's the version string provided by MySql... mysql Ver 11.19 Distrib 4.0.1-alpha, for Win95/Win98 (i32) This version should be okay shouldn't it? I have just tried creating some test tables to test what you said, but it still... -
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...
