Редактирование: MySQL (раздел)

== Types of queries ==

Their names describe what you want to do.

SELECT - Selects data from the database<br>
INSERT - Inserts data into a table<br>
UPDATE - Updates existing data in a table<br>
DELETE - Deletes existing data from a table

There are more, but this guide doesn't deal with them:<br>
CREATE - Creates databases, tables, views, procedures, triggers, etc. Whatever you define <br>
ALTER - Changes the properties of something you created (for example, which columns a table has)<br>
DROP - Deletes something you created (DELETE only deletes the data, DROP deletes the table itself.)