home | articles | links | fun | about Up to: Quick math and science observations

CREATE DATABASE name
CREATE TABLE name
USE name

SHOW TABLES;
SHOW DATABASES;
DESCRIBE tablename

LOAD DATA LOCAL INFILE "c:/pet.txt" INTO TABLE pet;

SELECT what_to_select
FROM which_table
WHERE conditions_to_satisfy

SELECT MAX(article) AS article FROM shop

Kalid at kazad@princeton.edu