Skip to content

Instantly share code, notes, and snippets.

@VikiAnn
VikiAnn / SQL Notes
Created November 3, 2014 17:35
SQL notes
What are database tables, column, and rows? What's the purpose of each?
Table is a collection of data organized into columns and rows.
Rows are usually one record. Usually horizontal.
Columns are usually vertical, and contain similar information about multiple records.
How's a database similar and different from a spreadsheet?