When executing the CREATE TABLE SQL's in Chapter 11, page 303, MySQL fails with "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY (1, 1) NOT NULL,
Format char (10))' at line 2"

It does not appear to recognize "IDENTITY" as a key-word. Is there a different syntax for MySQL?

i think it is normally same.

try this

use dbname;
create tblname (
var char id ,
var char age,
id primar key);


Regards
Shyam
web programmer
http://www.ensure.co.in