From: Kirk Haines <khaines@...>
Date: 2002-07-14T08:25:32+09:00
Subject: Re: DBI create table question

> /usr/local/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:222:in `do': You
> have an error in your SQL syntax near '; (DBI::DatabaseError) CREATE
> TABLE passport(id INT UNSIGNED NOT NULL AUTO_INCREMENT,
> email VARCHAR(6' at line 1
>        from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:568:in `do'
>        from dbi.rb:17
>        from dbi.rb:3:in `connect'
>        from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:322:in
>        `connect' from dbi.rb:3
>
>
> Is there some limitation with dbi or am I not correctly
> formatting the do argument?

Neither.  The semicolon at the end of your statement is the problem. 
Remove it.  You don't need to terminate a SQL statement with a semicolon
when using DBI or some other interface into the database.

Kirk Haines