TalkPHP - MySQL User-Def. Var.

TalkPHP (http://www.talkphp.com/forums.php)

- MySQL & Databases (http://www.talkphp.com/mysql-databases/)

- - MySQL User-Def. Var. (http://www.talkphp.com/mysql-databases/3538-mysql-user-def-var.html)

Dave	10-27-2008 02:28 PM

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

Dave	10-27-2008 02:41 PM

NEVER MIND....

That seems to work just fine...Don't know why I thought it was not working :-/. Could it be that I'm clueless??

All times are GMT. The time now is 06:14 AM.