Skip to content

Latest commit

 

History

History
27 lines (20 loc) · 748 Bytes

README.md

File metadata and controls

27 lines (20 loc) · 748 Bytes

SGBD-ETU2078-Toavina

--CREATE DATABASE --SHOW DATABASES --USE ______(database's name)

--CREATE TABLE____(table's name) col1,col2,col3 --INSERT INTO ____ VALUES val1,val2,val3 --DELETE FROM ____ WHERE col=val --DESC __(table's name) --DROP TABLE(table's name) --SHOW TABLES

--SELECT * FROM ____ | --SELECT col1,col2,... FROM ______| WHERE col=value |

--SELECT ___ FROM ___ ORDER BY col WHERE col=val

--SELECT___FROM tab1 |JOIN tab2 ON col1=col2
|UNION |INTERSECT |DIFFERENT |DIVISE |PRODUIT