347
edits
Changes
no edit summary
|-
| style="padding: 10px" | CREATE TABLE
| style="padding: 10px" | CREATE TABLE `''table''` VALUES(<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE
| style="padding: 10px" | CREATE TEMPORARY TABLE `''table''`VALUES(<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a temporary table of the given name
|-
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br />VALUES (''value1,value2,value3,...'');<br /><br>INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
