zimzion
9/6/2002 12:49:00 PM
i had connected MySQL using ODBC.NET.
Everything is ok except not executing a query which generates multiple
tables.
For example,
CREATE TABLE Accounts_Users(UserID int NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE Accounts_Users2(UserID int NOT NULL AUTO_INCREMENT PRIMARY
KEY);
When i executed above query, it showed a SQL Syntax error.
Of course, A query that creates one table is executed well.
Is it impossible to execute a query which generates multiple tables?