Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] tables aliasing 2nd AUTO INCREMENT 2nd 3rd 4th calculated fields concatenating fields 2nd 3rd 4th 5th mathematical calculations 2nd 3rd overview 2nd 3rd Cartesian products overview 2nd character sets, specifiying 2nd creating 2nd 3rd 4th 5th 6th customers table 2nd default values, specifying 2nd DELETE statements deleting 2nd joins. [See joins] multiple tables, joining 2nd NULL values 2nd orderitems table 2nd orders table 2nd overview 2nd overwriting primary keys 2nd productnotes table 2nd products table 2nd relational tables overview 2nd renaming 2nd updating 2nd 3rd vendors table 2nd views. [See views] tables. [See also CREATE TABLE] text-manipulation functions overview 2nd text. [See also non-numeric data] time datatypes 2nd trailing spaces dangers of in wildcards transactions controlling commits 2nd 3rd 4th overview rollbacks 2nd 3rd savepoints 2nd 3rd 4th engine support overview 2nd 3rd triggers BEFORE versus AFTER creating 2nd DELETE triggers 2nd dropping 2nd failure of guidelines 2nd INSERT triggers 2nd multi statement triggers overview 2nd UPDATE triggers 2nd TRIM() function trimming padded spaces 2nd TRUNCATE TABLE versus DELETE |