[phpMyAdmin Developers] MySQL and MariaDB syntax differences

[Isaac Bennetch]

On 11/17/15 3:28 PM, Marc Delisle wrote:
> Le 2015-11-17 11:29, Marc Delisle a écrit :
>> Le 2015-11-17 08:54, Isaac Bennetch a écrit :
>>> Hi team,
>>>
>>> As seen on Stackoverflow[1], there's a bit of a syntax problem when
>>> importing from MySQL to MariaDB in that MariaDB doesn't seem to accept \\''
>>>
>>> Just checking, this doesn't seem to me like anything we can control nor
>>> like anything we should check for, but what do you think?
>>>
>>> ~Isaac
>>>
>>> 1 -
>>> http://stackoverflow.com/questions/33742398/website-migration-phpmyadmin-export-import-syntax-error-1064
>>>
>>
>> Note that the problem is confirmed on MariaDB 5.5.44. I will try on a
>> more recent MariaDB server as soon as possible.
>>
> 
> On the demo server running MariaDB 10.0.21, this works:
> 
> INSERT INTO `t1`(`c1`) VALUES ('<a
> href=\\''http://domain.com/wp-login.php\\'' >Please login to download</a>');

Thanks, Marc.