-- HikaShop version -- : 4.7.2
Bonjour
j'essaye une action de masse SQL mais j ai une erreur
1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UPDATE #__hikashop_file SET `file_ordering`= 1 WHERE `file_path` LIKE "%-1-%"...' at line 2
UPDATE #__hikashop_file SET `file_ordering`= 0 WHERE `file_path` LIKE "%-0-%";
UPDATE #__hikashop_file SET `file_ordering`= 1 WHERE `file_path` LIKE "%-1-%";
UPDATE #__hikashop_file SET `file_ordering`= 2 WHERE `file_path` LIKE "%-2-%";
UPDATE #__hikashop_file SET `file_ordering`= 3 WHERE `file_path` LIKE "%-3-%";
merci pour helping