SQL in MySQL.

Anon

Using a book for SQL/92 standart I'am trying to learn MySQL basics, but
just after a few pages I find that the commands I type is not working.
Eks.
CREATE TABLE raadighed (nr NUMBER NOT NULL, dag CHAR(8) NOT NULL, PRIMARY KEY(nr, dag));

I swaped NUMBER with NUMERIC, but that did not help.
Can anyone tell me what is the problem?
The book I use should right in the syntax, but....
Nis.

Anon

well..it seems that u'r reading standard book for SQL and trying that SQL in mySQL...but the datatype support in mySQL is diff..(e.g u r using NUMBER but in mySQL u've INT) so,u better study mySQL daratypes first before starting upon ur table scripts and so...also SQL varies in mySQL

Anon

I thought that SQL was the base for MySQL, MSSQL, and so on.
I need the MqSQL for PHP3 so I dont want to pay a fortune for a book
I really dont need that much.

Is it only the syntax that diff. or is it the hole structure ?

Nis.

Anon

Actually, MySQL is excellently documented, including the SQL unique to it, at http://www.mysql.com

So no book purchase is really necessary.

Anon

Can I use sql DDL both in mysql and mssql as the same script?

What's the diffrent sql language between mssql and mysql

thanks!