Head First SQL

Appendix D.  

Symbols

= >< > < >= <=

You’ve got a whole bunch of equality and inequality operators at your disposal.

Chapter 2

A

ALTER with CHANGE

Lets you change both the name and data type of an existing column.

Chapter 5

ALTER with MODIFY

Lets you change just the data type of an existing column.

Chapter 5

ALTER with ADD

Lets you add a column to your table in the order you choose.

Chapter 5

ALTER with DROP

Lets you drop a column from your table.

Chapter 5

ALTER TABLE

Lets you change the name of your table and its entire structure while retaining the data inside of it.

Chapter 5

AND and OR

With AND and OR, you can combine your conditional statements in your WHERE clauses for more precision.

Chapter 2

ATOMIC DATA

Data in your columns is atomic if it’s been broken down into the smallest pieces that you need.

Chapter 4

ATOMIC DATA RULE 1

Atomic data can’t have several bits of the same type of data in the same column.

Chapter 4

ATOMIC DATA RULE 2

Atomic data can’t have multiple columns with the same type of data.

Chapter 4

AUTO_INCREMENT

When used in your column declaration, that column will automatically be given a unique integer value each time an INSERT command is performed.

Chapter 4

AVG

Returns the average value in a numeric column.

Chapter 6

B

BETWEEN

Lets you select ranges of values.

Chapter 2

C

CHECK CONSTRAINTS

Use these to only allow specific values to be inserted or updated in a table.

Chapter 11

CHECK OPTION

Use this when creating an updatable view to force all inserts and updates to satisfy a WHERE clause in the view. ...