...but doesn't.
I am attempting to create a table using the following...
CREATE TABLE INVOICE (
INV_NUMBER INT PRIMARY KEY,
CUS_CODE INT NOT NULL REFERENCES CUSTOMER(CUS_CODE),
INV_DATE DATETIME DEFAULT NOW() NOT NULL,
);
I receive an error message stating that there is an error with 'NOW()'
Which doesn't make sense to me. I understand both Oracle and MS-SQL Server use a similar format for putting the date and time into a field when a new row is created. At least that is my goal.
Is there a very different method of doing this under MySQL 4.0.21?
Thanks for any assistance you may offer.
-Rob
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
