O'Reilly logo

Head First SQL by Lynn Beighley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required