Helpful Information
 
 
Category: MySQL and other databases
Catch an auto-increment ID

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??

SELECT id FROM tablename WHERE ID = 20; :p i think :D

[edit]

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










privacy (GDPR)