You don't select last_insert_id() from table.
This will return the last_insert_id() for each row of the table.
You just select last_insert_id().
Tea Yu wrote:
>Hi! I just tried
> Windows ME + MySQL Server - 4.0.9/4.0.11 +
> ConnectorJ - 3.0.4/3.0.6/3.1.0
>
>with an InnoDB table
> test (id bigint not null auto_increment, name varchar(255))
>also tried
> test (id int not null auto_increment, name varchar(255))
>
>and did an SQLQuery thru JDBC
> insert into TABLE (name) values ('test');
> select last_insert_id() from TABLE;
>
>but got the Exception
> java.sql.SQLException: Invalid value for getInt() - 'q'
>
>while successive running of program returns
> 'r', 's', 't'...
>
>Query from console returns the correct result, but it returns n rows in set
>if last_insert_id() is n
>e.g. if select last_insert_id() = 7, 7 rows are returned in set
>
>
>Is there a bug in ConnectorJ regarding this... seems nobody else is having
>such a problem...?
>
>Best regards
>Tea
>
>
>---------------------------------------------------------------------
>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
