B14speedfreak
Technical User
- Mar 23, 2006
- 182
Hi all,
I am in the process of changing some Oracle sql scripts to work with mysql. Anyhow I have this script that creates tables, I think I have converted most of it to work. I get this problem when I run the <b>source</b> command to execute the sql script, when I try to do the following:
<b><i> CREATE TABLE customerorders(
ORDERID INT NOT NULL,
OrderDate DATE DEFAULT CURRENT_DATE NOT NULL,
.....
);</i></b>
Its the current date thats causing me the problems. Has anyone got any ideas how what I can use instead of <b>CURRENT_DATE</b> so that I get todays date as a default?
Thanks again,
B14... aka... Marky Mark... the frozen monkey in the server room...
I am in the process of changing some Oracle sql scripts to work with mysql. Anyhow I have this script that creates tables, I think I have converted most of it to work. I get this problem when I run the <b>source</b> command to execute the sql script, when I try to do the following:
<b><i> CREATE TABLE customerorders(
ORDERID INT NOT NULL,
OrderDate DATE DEFAULT CURRENT_DATE NOT NULL,
.....
);</i></b>
Its the current date thats causing me the problems. Has anyone got any ideas how what I can use instead of <b>CURRENT_DATE</b> so that I get todays date as a default?
Thanks again,
B14... aka... Marky Mark... the frozen monkey in the server room...