Skip to content

Instantly share code, notes, and snippets.

@ScarletPonytail
Last active June 8, 2017 14:12
Show Gist options
  • Save ScarletPonytail/54e435f45f6fad1645ec3d73268cc496 to your computer and use it in GitHub Desktop.
Save ScarletPonytail/54e435f45f6fad1645ec3d73268cc496 to your computer and use it in GitHub Desktop.
phpMyAdmin - Adding a new table row
// Single row
INSERT INTO core_config_data (`scope`, `scope_id`, `path`, `value`) VALUES ('default', 0, 'admin/url/use_custom_path', 0);
// Multiple rows
INSERT INTO PUT_YOUR_TABLE_NAME_HERE ('scope', 'scope_id', 'path', 'value') VALUES
("Default", 0, "admin/url/custom", NULL),
("Default", 0, "admin/url/use_custom", 0),
("Default", 0, "admin/url/use_custom_path", 0);
DELETE FROM PUT_YOUR_TABLE_NAME_HERE
WHERE 'scope' = "Stores" AND 'path' = "web/secure/base_url";
DELETE FROM PUT_YOUR_TABLE_NAME_HERE
WHERE 'scope' = "Stores" AND 'path' = "web/unsecure/base_url";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment