> -Original Message-
> From: Larry Martell [mailto:larry.mart...@gmail.com]
> Sent: Wednesday, July 03, 2013 11:29 AM
> To: shawn green
> Cc: mysql@lists.mysql.com
> Subject: Re: 1 file
>
> On Wed, Jul 3, 2013 at 9:51 AM, shawn green
> wrote:
> > Hello Larry,
> >
> >
> > On 7/3/2013 11:
You probably want
where cast(transaction_date as date) BETWEEN '2013-04-16' AND
'2013-04-16'
That works on my test case
You could also change the where clause to be >= date and < date+1
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Thursday, May 23, 2
To adjust a table name within a SQL statement, you need to create a
string with the updated values and use PREPARE/EXECUTE
See below, I am replacing your CONCAT with the complete insert statement
The example below is also assuming the value in the WHERE clause should
be adjusted to the number, inst
