When I try to run the following command:
CREATE TABLE Salespersons
(empid INTEGER NOT NULL PRIMARY KEY,
ename CHAR(15) NOT NULL,
rank INTEGER NOT NULL DEFAULT 1 CHECK (rank IN (1,2,3)),
salary DECIMAL(7, 2) NOT NULL DEFAULT 1000.00 CHECK (salary >=1000.00));
gives me the following error:
You have an error in your SQL syntax near 'CHECK (rank IN (1,2,3)),
salary...'
I've looked through the MySQL manual and cannot find anything that would
help explain why I cannot run any of the CHECK constraints - it does not
work when I delete that first CHECK constraint, because the second one is
there - if I delete both CHECK constraints, the command to create the table
works. I've tried it with creating different tables and it still doesn't
work - and I can't figure out why.
I'm pretty new to SQL. Other than using it in a number of databases I've
designed using MS Access, I don't have much experience. I'm working (if any
other newbies might have noticed) straight from a book by Wrox called
"Instant SQL Programming" to try and cut my teeth on this...
Any ideas why this is happening???
Thanks,
SF
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
