This article is to help me remember the basic syntax of MySQL statements. It is as simple as that.

Select

SELECT *
FROM dbprefix_menu
WHERE menutype = 'main'
AND alias = 'com-projectfork'
LIMIT 0 , 30

SELECT * FROM dbprefix_menu WHERE menutype = 'main' AND alias = 'com-projectfork' LIMIT 0 , 30


SELECT * FROM `zims_categories` WHERE `extension` = 5 
SELECT * FROM `zims_categories` WHERE `extension` = "com_hwdmediashare" 
SELECT * FROM `zims_categories` WHERE `extension` = 'com_hwdmediashare'
SELECT * FROM `zims_categories` WHERE extension = 'com_hwdmediashare' 

Update

UPDATE `fcenb_k2_items`
        SET `created_by`=784
        WHERE `created_by`=43

UPDATE `fcenb_k2_items` SET `created_by`=784 WHERE `created_by`=43


UPDATE `fcenb_hwdms_media` SET `created_user_id`=784 WHERE `created_user_id`=43;
UPDATE `fcenb_hwdms_media` SET `modified_user_id`=784 WHERE `modified_user_id`=43;

Update wp_post_notification_emails SET gets_mail = '1' WHERE gets_mail = '0'
UPDATE zims_k2_categories SET access = '3';

Other

ALTER TABLE zims_pf_access_flags_tmp ENGINE=Innodb;
ALTER TABLE zims_pf_access_levels_tmp ENGINE=Innodb;
ALTER TABLE zims_pf_comments ENGINE=Innodb;

 Notes

• MySQL processes each row in order from the beginning of the database for each statement.
• All statements are row dependant.
• i dont think that UPDATE/SELECT/ALTER etc.. have to be in capitals but it seems the convention