DB Designer – Quick DBD
Visual Representation of SQL Joins
https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Insert into the Database
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 case the meta_id and post_id are left blank as they get auto set in the database
Delete rows from the Database Where meta_key equals ‘meta_key_name’
DELETE FROM `flowerhhsa_wpbf4c`.`wp_postmeta` WHERE `meta_key`='xxxdate20180601';
Overwrite meta_key with New meta_key
UPDATE `flowerhhsa_wpbf4c`.`wp_postmeta` SET `meta_key`='key_name' WHERE `meta_key`='other_key_name';
MYSQL Select wordpress post by ID
SELECT * FROM flowerhhsa_wpbf4c.wp_postmeta where post_id = 413;