RE: [PHP-DB] newid()

It does not seem to work for ordinary SQL statements without using stored procedures. Is there a way to get around with it? -----Original Message----- From: scampbel [mailto:scampbel]On Behalf Of Steven Campbell Sent: Friday, August 11, 2000 10:44 AM To: chengcsw@netvigator.com Cc: Mike Hanney; php-db@lists.php.net Subject: Re: [PHP-DB] newid() SELECT @@IDENTITY executed after the INSERT statement will return the last inserted identity on SQL Server. Steven Campbell Christopher Cheng wrote: > > By the way, I am using MS SQL Server 7.0. Do you know an equilvalent > function in MS SQL Server? > > Thank you very much. > > -----Original Message----- > From: Mike Hanney [mailto:mike@tradebasics.com] > Sent: Friday, August 11, 2000 9:47 AM > To: chengcsw@netvigator.com; php-db@lists.php.net > Subject: Re: [PHP-DB] newid() > > Hi, > > You need to use something like LAST_INSERT_ID(), depending on what database > you're using (presumably MySQL). > > INSERT INTO foo (auto,text) VALUES(NULL,'text') > INSERT INTO foo2 (id,text) VALUES(LAST_INSERT_ID(),'text') > > I think the LAST_INSERT_ID() function will give you the most recent > auto_increment key on a per connection basis not per thread. If anyone > knows for sure please say. > > Mike. > > At 00:18 12/08/00 -0700, Christopher Cheng wrote: > >My intention is to update the product table and the safety certificate > table > >associated with it. As I execute the SQL statement: > >update products values (newid(), .....) > >can I have the primary key generated by the newid() returned to my php > >script? > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >For additional commands, e-mail: php-db-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net