oracle SQL != MySQL??

[Der_Fisch]

hi everyone...

i'm trying to make my own guestbook, just to lern php and mysql better.
but when i'm using this SQL command, it returns a error! is there a difference between SQL used by Oracle and MySQL?

CREATE TABLE eintrag(
ein_id NUMBER NOT NULL,
ein_name VARCHAR2(20) DEFAULT 'Anonymus' NOT NULL,
ein_email VARCHAR2(50) DEFAULT '[e-mail]' NOT NULL,
ein_date DATE NULL,
ein_message VARCHAR2 NOT NULL);

this is the error msg:

You have an error in your SQL syntax near 'NUMBER NOT NULL,
ein_name VARCHAR(20) DEFAULT 'Anonymus' NOT NULL
)' at line 2

Thx so far....

[bernouli]

you are right
Oracle SQL != MySQL,
some function, which can be run in MysQL, can't be run in Oracle's, maybe NOT NULL is one from them

[mattr]

Oracle has different, non-standard, datatypes (in an effort to keep compatibility and portability to a minimum).

Change 'number' to 'int' and VARCHAR2 to VARCHAR

[[deleted]]

Also be aware that mysql expects a different syntax for many datatypes, like dates.

MySQL does not support any stored procedures or functions.

If youre oracle database is 'complex' and it uses triggers etc, you're better off porting to postgresql than mysql.

[Der_Fisch]

thx everyone!