[phpMyAdmin Developers] MySQL and MariaDB syntax differences

[Marc Delisle]

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>');


-- 
Marc Delisle | phpMyAdmin