Re: table generation with scripts

[Albert Wu]

Your sql statement works fine on mySQL server..
Well first make sure you have the InnoDB engine installed..
There are options to install both InnoDB and MyIASM or each separately.
you can change this via the install options for mysql (Instance Config Wizard)

in order to create the tables you would first need to create a database
like CREATE DATABASE somedatabase;

then select it by using USE somedatabase;

from there just have your
CREATE TABLES ended with semicolons so sql will goto add the next table.

hope that helps :]