There are loads of Quick Refernce Guides available on the WWW for MySQL, so I have create mine with a slight twist in that I have also included notes on where they have been used in course book/weekly study guides. That way hopefully it will help you see exactly how each command/function can be used.
COLUMN TYPE
[NATIONAL] CHAR (M) [BINARY]
county CHAR (75)
pg 80
[NATIONAL] VARCHAR (M) [BINARY]
pg 79
BIGINT [ (M) ] [UNSIGNED] [ZEROFILL]
not used as yet
BIT
not used as yet
BLOB
not used as yet
CHAR
not used as yet
DATE
not used as yet
DATETIME
not used as yet
DECIMAL [ (M [,D] ) ] [ZEROFILL]
not used as yet
DOUBLE PRECISION [ (M,D) ] [ZEROFILL]
not used as yet
DOUBLE [ (M,D) ] [ZEROFILL]
not used as yet
ENUM ('value1' , 'value2' , 'value3', and so on)
pg 80
FLOAT [ (M,D) ] [ZEROFILL]
not used as yet
INT [ (M) ] [UNSIGNED] [ZEROFILL]
not used as yet
INTEGER [ (M) ] [UNSIGNED] [ZEROFILL]
not used as yet
LONGBLOB
not used as yet
LONGTEXT
not used as yet
MEDIUMBLOB
not used as yet
MEDIUMINT [ (M) ] [UNSIGNED] [ZEROFILL]
not used as yet
MEDIUMTEXT
not used as yet
NUMERIC (M,D) [ZEROFILL]
not used as yet
REAL [ (M,D) ] [ZEROFILL]
not used as yet
SET ('value1', 'value2', 'value3' and so on)
not used as yet
SMALLINT [ (M) ] [UNSIGNED] [ZEROFILL]
pg 79
TEXT
pg 81
TIME
not used as yet
TIMESTAMP [ (M) ]
not used as yet
TINYBLOB
TINYINT [ (M) ] [UNSIGNED] [ZEROFILL]
not used as yet
TINYTEXT
not used as yet
YEAR [ (2|4) ]
not used as yet
COMPARISON OPERATOR
=
not used as yet
< >
not used as yet
!=
not used as yet
<= not used as yet
< not used as yet
>=
not used as yet
>
not used as yet
<=>
not used as yet
COALESCE (list)
not used as yet
expr BETWEEN min AND max
not used as yet
expr IN (value, and so on)
not used as yet
expr NOT IN (value, and so on)
not used as yet
INTERVAL (N,N1,N2,N3)
not used as yet
IS NOT NULL
not used as yet
IS NULL
not used as yet
ISNULL (expr)
not used as yet
LOGICAL OPERATORS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
CONTROL FLOW FUNCTIONS
COMMAND HERESTRING FUNCTIONS
not used as yet
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
STRING COMPARISON FUNCTIONS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
MATHEMATICAL FUNCTIONS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
ARITHMETIC OPERATORS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
DATE AND TIME FUNCTIONS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
CAST FUNCTIONS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
BIT FUNCTIONS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
MISCELLANEOUS FUNCTIONS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
FUNCTIONS FOR USE WITH GROUP BY CLAUSES
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
INSERT
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
SELECT
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
JOIN
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
HANDLER
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
UPDATE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
DELETE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
TRUNCATE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
REPLACE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
UNION
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
LOAD DATA INFILE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
CREATE DATABASE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
DROP DATABASE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
CREATE TABLE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
DROP TABLE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
ALTER TABLE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
RENAME TABLE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
CREATE INDEX
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
DROP INDEX
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
USE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
DESCRIBE
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
BEGIN/COMMIT/ROLLBACK
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
SET TRANSACTIONS
COMMAND HERE
not used as yet
COMMAND HERE
not used as yet
A
No comments:
Post a Comment