PDA

View Full Version : Catch an auto-increment ID



pavmoxo
07-18-2006, 02:39 PM
Hello!!

How can I catch an auto-increment ID in a table with a SQL querie?

For example:

...ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

and I wan´t select the 20. How can I do this??

jr_yeo
07-18-2006, 03:33 PM
SELECT id FROM tablename WHERE ID = 20; :p i think :D

[edit]

can't quite understand what u want to happen :p