Ravi Malghan wrote:
Hi: I have a statement such as follows
SELECT EVENT_DATA.dstport WHERE
FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
Instead of using a value of 1 for interval, I want to
pass parameters so it will ask for the value when the
sql statement is run.
You can put it in a prepared statement
(http://dev.mysql.com/doc/refman/5.1/en/sqlps.html), eg
set @sql = "SELECT EVENT_DATA.dstport
WHEREFROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -INTERVAL ? DAY) ORDER
BY EVENT_DATA.utime";
PREPARE stmt FROM @sql;
set @x = 7;
EXECUTE stmt USING @x;
DROP PREPARE stmt;
and you can put all that in a stored procedure, passing in the number of
days as a param.
PB
----
I have tried searching in google
and www.mysql.org and have not had any luck. Does
mysql use different definitions? or can someone
provide some pointers on the web which explains how to
pass parameters with SQL statement.
Thanks
Ravi
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.0/306 - Release Date: 4/9/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
