Editing MySQL basics (section)

== Inserting data into a table ==

<code>INSERT</code> : used to set column values

Two formats:

<pre>
INSERT INTO table_name SET

-> columnName1 = value1,

-> columnName2 = value2,

-> etc...

->;

OR

INSERT INTO table_name
-> (columnName1, columnName2, etc...)
-> VALUES (value1, value2, etc...);
</pre>

Table Commands
<pre>
mysql>CREATE TABLE table_name ( column1_name column1_type column1_details,
    -> column2_name  column2_type column2_details, ... );


mysql>SHOW TABLES;
mysql>DESCRIBE table_name;
mysql>DROP table_name;


mysql>UPDATE table_name SET

    -> column_name = new_value, ...

    -> WHERE conditions;


mysql>DELETE FROM table_name WHERE conditions;
</pre>