Hi, I just tried this on a schema I had laying about and it worked fine:
mysql> SET @dude='pilgrim';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT namefield FROM mytable WHERE namefield LIKE
CONCAT('%',@dude,'%');
+---+
| name
This used to work fine in Mysql 4.3, but no longer works in 5.5.8:
set @txt='needle';
select * from table where field like CONCAT('%',@txt,'%');
--returns the null set. If I substitute like this:
select * from table where field like '%needle%';
it works perfectly (and as it did in 4.x).
How
Yeah, we have some of the SQL statements which are running more than 1
minutes. However, for small queries it's also throwing errors DBCP.
--
Regards,
Dhaval
On Fri, May 6, 2011 at 4:59 PM, Martin Gainty wrote:
> Id the execution delivers results in under a minute then adhere to Mr
> Woods a
interactive/wait_timeout = 120Seconds
max_connection = 1500
still we are getting errors.
--
Regards,
Dhaval
On Fri, May 6, 2011 at 4:05 PM, Nigel Wood wrote:
> On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote:
> > Caused by: java.net.SocketException: Socket closed
>
> I'd suggest you
Zmanda ZRM backup, although the fancy webinterface is only available in the
commercial version. Backups are stored on the host that runs the server, and of
course it serves multiple MySQL machines.
Webinterface is annoyingly slow, though :-)
- Original Message -
> From: "Michael Heaney