Changes

Jump to: navigation, search

This Is Your Brain On Informatics: MariaDB

1 byte added, 01:58, 25 October 2013
no edit summary
|-
| `[table]` || || Syntax for indicating a table
|-
| USE [database] || || Selects database for manipulation and analysis
|-
| SELECT || || Selects columns from a database for analysis
|-
| FROM || || Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| INTO || SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';|| Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| SELECT || || Selects columns from a database for analysis
|-
| UPDATE || UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;'' || Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| USE [database] || || Selects database for manipulation and analysis
|-
|}
347
edits

Navigation menu