10-27-2008, 03:28 PM
|
#1 (permalink)
|
|
The Contributor
Join Date: Apr 2008
Posts: 61
Thanks: 49
|
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
|
|
|
|