การติดตั้ง MySQL

MANY COMMAND MqSOL

COMMAND	DESCRIPTION	EXAMPLE
CREATE	CREATE database and table	CREATE DATABASES; CREATE TABLES nametable (fied1 VARCHAR(25), fied2 VARCHAR(25), fied3 INT, fied1 VARCHAR(25), ID INT NOT AUTO_INCREMENT, PRIMARY KEY (ID));
SHOW	DISPLY database and table	SHOW DATABASES; SHOW TABLES; SHOW COLUMNS FROM tables; DESC tablename;
USE		USE database;
SELECT		SELECT * FROM (table); SELECT * FROM (table) where (fied=data) or (fied2=data2); SELECT * FROM (table) where (fied=data) and (fied2=data2);
UPDATE	EDIT database	UPDATE table SET fied='datanew' WHERE fied='dataold';
DELETE	DELETE record	DELETE FROM table WHERE (fied=data);
ALTER	RENAME table	ALTER TABLE tableold RENAME tablenew; ALTER TABLE table ADD fiednew DATATYPE;
INSERT	INSERT record	INSERT INTO table VALUES ('fied1','fied2','fied3')
DROP	DROP database DROP table	DROP DATABASE datatest; DROP TABLE tablename;
ORDER BY	SORT data	SELECT fieldname FROM tablename ORDER BY fieldname;