Hi,

Is there a way of after a select statement having a return value for a
determined field ?

For example, after this:
INSERT INTO wl_users(name, email, password) VALUES('Deckard',
'ml@wordlife.eu', 'blabla')

having the name returning without having to make a subsequent select.

Any help would be appreciated.

Best Regards,
Deckard

You could use a stored procedure to do the INSERT and then return the
value from SELECT statement. For example,

DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`spINSERTandSELECT`$$

CREATE PROCEDURE `test`.`spINSERTandSELECT` (IN strFirstName
VARCHAR(20),
IN strLastName VARCHAR(20))
BEGIN
INSERT INTO
usernames (FirstName, LastName)
VALUES
(strFirstName, strLastName);

SELECT CONCAT(strFirstName, " ", strLastName);
END$$

DELIMITER ;$$


Then call the stored procedure as follows:

mysql> use test;
Database changed
mysql> call spINSERTandSELECT("John", "Doe");
+----------------------------------------+
| CONCAT(strFirstName, " ", strLastName) |
+----------------------------------------+
| John Doe |
+----------------------------------------+
1 row in set (0.06 sec)

Query OK, 0 rows affected (0.06 sec)

mysql>

Hope this helps.

Randall Price

Microsoft Implementation Group
Secure Enterprise Computing Initiatives
Virginia Tech Information Technology
1700 Pratt Drive
Blacksburg, VA 24060

Email: Randall.Price@vt.edu
Phone: (540) 231-4396



-----Original Message-----
From: Deckard [mailto:ml@wordlife.eu]
Sent: Tuesday, October 03, 2006 11:40 AM
To: mysql@lists.mysql.com
Subject: Returning value after insert

Hi,

Is there a way of after a select statement having a return value for a
determined field ?

For example, after this:
INSERT INTO wl_users(name, email, password) VALUES('Deckard',
'ml@wordlife.eu', 'blabla')

having the name returning without having to make a subsequent select.

Any help would be appreciated.

Best Regards,
Deckard


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=Randall.Price@vt.edu