MYSQL Indexing

by Garth | Feb 15, 2022 | MYSQL

DB Designer – Quick DBD

by Garth | Nov 18, 2021 | MYSQL

https://app.quickdatabasediagrams.com/#/d/05057d

Visual Representation of SQL Joins

by Garth | Jun 17, 2021 | MYSQL

https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

Insert into the Database

by Garth | Jul 2, 2018 | MYSQL

INSERT INTO `flowerhhsa_wpbf4c`.`wp_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES (”, ”, ‘xxxdate20180601’, 1000); Just match the fields. eg: (‘meta_id’,`post_id`) values (‘meta_id’,`post_id`) In this...

Delete rows from the Database Where meta_key equals ‘meta_key_name’

by Garth | Jul 2, 2018 | MYSQL

DELETE FROM `flowerhhsa_wpbf4c`.`wp_postmeta` WHERE `meta_key`=’xxxdate20180601′;

Overwrite meta_key with New meta_key

by Garth | Jul 2, 2018 | MYSQL

UPDATE `flowerhhsa_wpbf4c`.`wp_postmeta` SET `meta_key`=’key_name’ WHERE `meta_key`=’other_key_name’;