Could you provide us with the error messages you are getting?!?!
----- Original Message -----
From: "Michael Lépine" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 11:57
Subject: Executing multiple SQL commands.
> I'm trying to execute multiple create table commands and am getting SQL
> errors. I'm using the MySqlManager.exe that comes with the Win32 version
of
> MySQL and the syntax is similar to the following:
>
> /*==============================================================*/
> /* Database name: physical data model 1 */
> /* DBMS name: MySQL 3.23 */
> /* Created on: 2/18/01 10:43:37 PM */
> /*==============================================================*/
>
>
> drop table if exists tbl_nm_sfxs;
>
> drop table if exists tbl_cntct_typs;
>
> /*==============================================================*/
> /* Table : tbl_cntct_typs */
> /*==============================================================*/
> create table if not exists tbl_cntct_typs
> (
> cntct_typ_id int unsigned not null,
> primary key (cntct_typ_id)
> )
> type = bdb;
>
> /*==============================================================*/
> /* Table : tbl_nm_sfxs */
> /*==============================================================*/
> create table if not exists tbl_nm_sfxs
> (
> nm_sfx_id tinyint unsigned auto_increment not null,
> primary key (nm_sfx_id)
> )
> type = bdb;
>
> _________________________
>
> I looked through the archives, but couldn't find something to help me (not
> really sure what keywords to use to find help with this). The error seems
to
> be occurring when the second SQL command in a sequence attempts to
execute.
> If I isolate any of the above commands, they will run independently, but
> together (as above) they fail.
>
> Anyway, if anyone could help me figure out why I'm getting an error, it
> would be appreciated.
>
> - Mike
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
