PHPMyAdmin: SQL Operations Misc Notes

Miva Knowledge Base
Want to start an online store? We work with you from start to finish, from commerce platform to design to SEO.
Experience counts, and we have a lot.
Important Notice: This information is for internal reference only. Use at your own risk.

PHPMyAdmin: SQL Operations Misc Notes

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

mvkb_phpmyadmin