On Fri, Mar 29, 2013 at 2:23 AM, wrote:
> I think we can use it in 'if else' statement. something pseudocode like: if
> there is data in TBL2 for date_sub(curdate(), interval 1 day), remove the
> database data and insert new data. else insert new data into database.
>
> How can I do it?
Can y
I have 2 tables TBL1 and TBL2.
TBL1 has 2 columns id, nSql.
TBL2 has 3 columns date, custId, userId.
I have 17 rows in TBL1 with id 1 to 17. Each nSql has a SQL query in it.
For example nSql for
id == 1 is: "select date, pId as custId, tId as userId from TBL3"
id == 2 is: "select date, qId as cu
