> Could you provide us with the error messages you are getting?!?!
My apologies. The problem appears to have been the copying of unexpected
characters into the SQL. I generated the SQL for the tables and put it into
a file. Apparently when I copy and paste the SQL, some hidden characters are
being copied into the queries which are causing the problems.
Sorry for not figuring this out before posting.
> ----- 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
>
>
>
---------------------------------------------------------------------
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
