That SELECT LAST_INSERT_ID() saved my day.
Thanks a lot for both answers.
Search found 4 matches
- 19.10.2008, 17:47
- Forum: MySQL
- Topic: Data from insert
- Replies: 5
- Views: 902
Data from insert
Hi. Is it possible get data during insert? +-------+------------------+-----+-----------------+ | Field | Type | Key | Extra | +-------+------------------+-----+-----------------+ | id | int(10) unsigned | PRI | auto_increment | | name | varchar(15) | | | +-------+------------------+-----+----------...
- 23.08.2008, 11:24
- Forum: MySQL
- Topic: unknown MySQL Datatype
- Replies: 10
- Views: 3247
I have same problem. When I try showmessage(ZConnection1.ClientVersionStr + '-'+ZConnection1.ServerVersionStr); I get access violation error. But I have MySQL 5.0 and zeos 6.3.3. This is what I have added to ZQuery.SQL.text: SELECT * FROM kissa; and here's table which I added on MySQL http://pp.kpne...
- 23.08.2008, 09:36
- Forum: MySQL
- Topic: Problem with connecting
- Replies: 2
- Views: 866
Problem with connecting
Hi. I'm having problem to get connected to database. I have MySQL 5.0 server and Zeos 6.6.3. I added ZConnection to form, added to properties username and password and selected protocol mysql-5. When I try to change connected property, i get following message: "Client does not support authentic...