TalkPHP - View Single Post - MySQL User-Def. Var.

Dave · 10-27-2008, 02:28 PM

Hi --

After defining a UDF, how can I select the UDF "into" a table, like this:

Code:

SET @datadate = "20081020" ;

INSERT INTO newtable
SELECT name, phone, @datadate AS extraction_date
FROM oldtable ;

Thanks for any help!
Dave

10-27-2008, 02:28 PM	#1 (permalink)
Dave The Acquainted Join Date: Apr 2008 Posts: 110 Thanks: 97	MySQL User-Def. Var. Hi -- After defining a UDF, how can I select the UDF "into" a table, like this: Code: SET @datadate = "20081020" ; INSERT INTO newtable SELECT name, phone, @datadate AS extraction_date FROM oldtable ; Thanks for any help! Dave