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; |