On Tue, Jan 7, 2014 at 12:33 PM, Michael Dykman wrote:
> I think you just have a misplaced parenthesis. try:
> SELECT IF(r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
Yes, thanks!
>
>
>
> On Tue, Jan 7, 2014 at 2:22 PM, Larry Martell wrote:
>
>> Can I use an regexp in a conditional?
On Tue, Jan 7, 2014 at 12:31 PM, Peter Brawley
wrote:
>
> On 2014-01-07 1:22 PM, Larry Martell wrote:
>>
>> Can I use an regexp in a conditional? I need to do something like this:
>>
>> SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
>>
>> I'm getting an error from that. Is there some
I think you just have a misplaced parenthesis. try:
SELECT IF(r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
On Tue, Jan 7, 2014 at 2:22 PM, Larry Martell wrote:
> Can I use an regexp in a conditional? I need to do something like this:
>
> SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes
On 2014-01-07 1:22 PM, Larry Martell wrote:
Can I use an regexp in a conditional? I need to do something like this:
SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
I'm getting an error from that. Is there some way to do this?
SELECT IF( r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no' )
F
Can I use an regexp in a conditional? I need to do something like this:
SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
I'm getting an error from that. Is there some way to do this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Ugh, that seems quite right. Now, why did they do that?
It was added for compatibility.
A separate specification is less convenient, and also less transparent.
Please click "affects me" on http://bugs.mysql.com/bug.php?id=47771
- Morgan
--
MySQL General Mailing List
For list archives: ht
2014/01/06 17:07 +0100, Reindl Harald
what about look in the servers logfiles
most likely "max_allowed_packet" laughable low
Is this then, too, likly when the server and the client are the same machine?
I left this out, that it only then happens when the client has been idle, a
2014/01/06 14:24 -0500, Morgan Tocker
You might be hitting:
"Important
The inline REFERENCES specifications where the references are defined as part
of the column specification are silently ignored. MySQL only accepts REFERENCES
clauses defined as part of a separate FOREIGN KEY specifi
day trial version on www.upscene.com
Pricing information available on:
http://www.upscene.com/go/?go=purchase
More information available here:
http://www.upscene.com/go/?go=news&id=20140107
With regards,
Martijn Tonies
Upscene Productions - Database Tools for Developers
http://www.upscene.com
Hi,
Can you try passing the dump file through hexdump or some binary editor to
see if the data is there. Most text editors will treat 0x00 as end of string
and this most likely this is causing the problem.
Additionally you can try running the import with --default-character-set=utf8
in case t
Am 07.01.2014 13:48, schrieb Lukas Lehner:
> Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only
> interested in developer changes (not admin)
> Can I use development books for MySQL 5.0.0 [2003] and use the code an
> recent MariaDB and MySQL releases?
clearly yes
the *other dire
Hi
Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only
interested in developer changes (not admin)
Can I use development books for MySQL 5.0.0 [2003] and use the code an
recent MariaDB and MySQL releases?
12 matches
Mail list logo
