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.
On 07/31/2012 09:07 AM, Incarus Derp wrote:
I need to replace ACRE_PRC119_ID_29 with ACRE_PRC119 and I cannot do this
externally. I have PREG_REPLACE but I'm not sure how I would apply this to
the database because it only SELECT's as far as I know.
You could CREATE a TABLE from the SELECT.
- Original Message -
From: Incarus Derp icarusd...@gmail.com
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.
Hi!
Fred == Fred G Fred 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 the
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
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
On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete halukkaram...@gmail.com 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
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)