jkullick/mysql-basic-operations.md

Last active July 29, 2016 12:02

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jkullick/73c1c6ce90b298b311a05c444c2ef215.js"></script>
Save jkullick/73c1c6ce90b298b311a05c444c2ef215 to your computer and use it in GitHub Desktop.

MySQL Basic Operations (Insert, Update, Delete)

Raw

INSERT INTO `$TABLE` (`$FIELD_X`, `$FIELD_Y`, `$FIELD_Z`) VALUES ('$VALUE_X', '$VALUE_Y', '$VALUE_Z');

UPDATE `$TABLE` SET `$FIELD_X`='$VALUE_X', `$FIELD_Y`='$VALUE_Y', `$FIELD_Z`='$VALUE_Z' WHERE `$FIELD_ID`=$X;

DELETE FROM `$TABLE` WHERE `$FIELD_ID`=$X;

Select an option