mySQL commands

http://jerimee.com/node/31

show databases;
use [databasename];
show tables;
LOAD DATA LOCAL INFILE or LOAD DATA INFILE - http://dev.mysql.com/doc/refman/5.0/en/load-data.html
LOAD DATA LOCAL INFILE 'C:\\xampp\\tmp\\php20A.tmp' INTO TABLE `abm06` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '!'

show warnings;
SELECT count(*) FROM mytable;

mySQL datatypes

SELECT sID, vIDold, vIDnew,
CASE WHEN vIDold =0
THEN vIDnew
ELSE vIDold
END AS id_union
FROM vidvsvid
WHERE vIDold IS NOT NULL ;

SELECT *
FROM `d20081016`
LIMIT 0 , 30

SELECT * FROM d20081016 LIMIT 0 , 30;

INSERT INTO jjrdb.results (salsa, van, sfn, vfn, sln, vln)
SELECT d20081016.SalsaID, _thevoterdata.VANID, d20081016.Fname, _thevoterdata.FirstName, d20081016.Lname, _thevoterdata.LastName FROM d20081016, _thevoterdata WHERE d20081016.Fname = _thevoterdata.FirstName AND d20081016.Lname = _thevoterdata.LastName AND d20081016.Zip = _thevoterdata.Zip5;

INSERT INTO jjr.results (first, last, email)
SELECT jjinvite.first, jjinvite.last, oh8.Email FROM oh8, jjinvite
WHERE
jjinvite.first = oh8.FirstName
AND
jjinvite.last = oh8.LastName
AND
jjinvite.city = oh8.City;

INSERT INTO jjr.results (first, last, email)
SELECT oh8.FirstName, oh8.LastName, cstt.Email FROM oh8, cstt
WHERE
cstt.Email = oh8.Email