Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
-none-

-none-

2007-09-03       - By Martin Dommermuth

 Back
Hi,

I suppose this is somewhere in the docs, but I can't find a sane way
to search for it. So please s.o. hit me with a cluestick:

I have this code:
readoutTemplate = "insert into readout values ";
readoutTemplate.append("(%0, %1q, %2, %3, ");
readoutTemplate.append("%4, %5, %6, %7, %8, %9, %10, %11, %12q)");

ubisenseTemplate = "insert into ubisense values ";
ubisenseTemplate.append("(%0, %1, %2, %3, %4, %5q, %6q)");

Column one of readout is AUTO_INCREMENT and ubisense has a
FOREIGN KEY (idreadout) REFERENCES readout(id).
How can I get the ID the new row will have? Should I use SSQLS instead?

Thanks,

Martin



--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    http://lists.mysql.com/plusplus?unsub=mysql@(protected)