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??
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;i think
[edit]
can't quite understand what u want to happen![]()
Last edited by jr_yeo; 07-18-2006 at 03:39 PM.
Please don't mind me. I am just posting a lot of nonsense.
Bookmarks