PHPMyAdmin: SQL Operations Misc Notes

Important Notice: This information is for internal reference only. Use at your own risk.

Does Google actually understand your Miva Merchant store? Our JSON-LD schema generator makes sure it does. Contact us to get started. (more info)

Scot Ranney • November 10, 2024

1. Using SQL Operations in PHPMyAdmin requires "back ticks" ` for column names but double quotes " for values.

Example:

update `s08_openreviews_REVIEWS` set `type_code` = replace(`type_code`, "50pmc2s-review", "p4");

You will know there is something wrong if an "unknown column" error comes up.

https://www.scotsscripts.com/mvblog/phpmyadmin-sql-operations-misc-notes.html