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