hello,
`323030382d30322d3032' is hexadecimal expression of `2008-02-02'.
but i don't know why your MySQL returns a result in hexadecimal.
don't you have any idea about hexadecimal in your program?
yoku ts.
2012/8/1 Willy Mularto :
> Hi,
> I just tried this query "SELECT ADDDATE('2008-01-02',
Hi,
I just tried this query "SELECT ADDDATE('2008-01-02', 31);" and MySQL returns
"323030382d30322d3032", while it should be "2008-02-02" Is there something
wrong?
Willy Mularto
F300HD+MR18DE (NLC1725)
On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete wrote:
> I've got a text field called source_recid. It stores half string half
> number like strings in it.
>
> Example
>
> shop.orders.32442
>
> the syntax is DATABASENAME.TABLENAME.RECID
>
> My goal is to scan this col and find out the biggest RECI
Thanks Shawn. Very informative and useful. David.
The information contained in this e-mail and any attached
documents may be privileged, confidential and protected from
disclosure. If you are not the intended recipient you may not
read, copy, distribute or use this information. If you have
rece
I've got a text field called source_recid. It stores half string half
number like strings in it.
Example
shop.orders.32442
the syntax is DATABASENAME.TABLENAME.RECID
My goal is to scan this col and find out the biggest RECID ( the
integer) in it.
So, in a case like this
shop.orders.32442
shop
Hi!
> "Fred" == Fred G writes:
Fred> Thanks Dhaval. Putting the join condition before INTO outfile doesn't
seem
Fred> to work, either.
Fred> When I try to use the same outfile name 'test123.csv' I get Error Code:
Fred> 1086 File 'test123.csv' already exists. But then when I try to find
- Original Message -
> From: "Incarus Derp"
>
> I have a complex field named Inventory in a table named Table1 that
> can be different every time and is not guaranteed to contain what I need to
> replace.
>
> [["Thing1","Thing4","thing8","thing1","thing942","ACRE_PRC119_ID_29"],[["thin
