MySQL Crash Course

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]

data

     backing up 2nd

    grouping. [See GROUP BY]

     separating correctly

Database Management Systems. [See DBMSs]

database server

     client-server software interaction

databases

     backing up 2nd

     compared to Database Management Systems (DBMSs)

     compared to schema

     definition of

     maintenance, performing 2nd

    selecting

         with USE 2nd

datatype

     definition of

datatypes

     binary datatypes 2nd

     date and time datatypes 2nd

     numeric datatypes 2nd 3rd

     overview 2nd

     string datatypes 2nd 3rd

date and time manipulation functions

     overview 2nd 3rd 4th

date datatypes 2nd

DBMS performance, improving 2nd 3rd

DBMSs

     compared to databases

DECLARE statements

     organizing

     stored procedures

DEFAULT

     tables 2nd

DELAYED keywords

DELETE statements 2nd

     versus TRUNCATE TABLE

Delete statements 2nd

DELETE triggers 2nd

delimiters 2nd

derived columns. [See aliases]

DESC

     utilizing 2nd

DESCRIBE

     description of

DISTINCT

     retrieving distinct rows 2nd 3rd

DISTINCT arguments

     AVG() function 2nd

     COUNT() interaction

DISTINCT. [See also LIMIT]

downloading MySQL

DROP PROCEDURE

DROP TABLE statement 2nd

DROP USER