TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
Advertisement
Associates
Associates
techtuts Darkmindz
CSS Tutorials Tutorialsphere.com - Free Online Tutorials
Boston PHP SurfnLearn
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 10-27-2008, 03:28 PM   #1 (permalink)
The Contributor
 
Join Date: Apr 2008
Posts: 61
Thanks: 49
Dave is on a distinguished road
Default 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 is offline  
Reply With Quote
Old 10-27-2008, 03:41 PM   #2 (permalink)
The Contributor
 
Join Date: Apr 2008
Posts: 61
Thanks: 49
Dave is on a distinguished road
Default

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??
Dave is offline  
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 05:40 PM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0