Perl Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Programming Languages > Perl Programming
Reload this Page

DBI & MYSQL (How to receive autoincrement a field after an insert)

Discuss DBI & MYSQL (How to receive autoincrement a field after an insert) in the Perl Programming forum on Dev Shed.
DBI & MYSQL (How to receive autoincrement a field after an insert) Perl Programming forum discussing coding in Perl, utilizing Perl modules, and other Perl-related topics. Perl, the Practical Extraction and Reporting Language, is the choice for many for parsing textual information.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old November 28th, 2000, 11:11 AM
dema501 dema501 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2000
Posts: 0 dema501 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
For example I insert row into base (MySQL). The first field id - an primary key generate also is inserted itself autoincrement.
As after an insert at once to receive this number for inserting in other table.
Reply With Quote
  #2  
Old December 6th, 2000, 08:13 AM
glen_scott glen_scott is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2000
Location: Norfolk, UK
Posts: 9 glen_scott User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by dema501:
For example I insert row into base (MySQL). The first field id - an primary key generate also is inserted itself autoincrement.
As after an insert at once to receive this number for inserting in other table.[/quote]

Use the LAST_INSERT_ID() function.

- Glen
Reply With Quote
  #3  
Old December 6th, 2000, 09:29 AM
dema501 dema501 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2000
Posts: 0 dema501 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Maybe it better URL
$dbh->{'mysql_insertid'};
Reply With Quote
Reply

Viewing: Dev Shed Forums > Programming Languages > Perl Programming > DBI & MYSQL (How to receive autoincrement a field after an insert)

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway.