COMMANDES STRUCTURE DONNÉES
CRÉER CREATE INSERT
MODIFIER ALTER UPDATE
DETRUIRE DROP DELETE
AFFICHER DESC SELECT

CREATE

CREATE SEQUENCE <uneseq> INCREMENT BY 1

ALTER

DROP

DESC

INSERT

INSERT INTO <table> [VALUES | SELECT...]
INSERT INTO nomTable ("champ1[, ...]") VALUES ('valeur1'[, '...'])

UPDATE

UPDATE <table> SET <col>  = <exp> WHERE <condition>, 
	<col2> = <exp2> 
	WHERE EXISTS <condition>

DELETE

DELETE [FROM] <table>
	 [ WHERE <condition> |
		 CURRENT OF <nomcurseur> ]

DELETE FROM nomTable WHERE condition;
	condition  : champTable=valeur;
	champTable : champ de la table nomTable;
	valeur     : valeur quelconque.

SELECT

SELECT * FROM tabs
SELECT champ FROM nomTable [ WHERE condition];
	 champ : liste de champ sélectionner
	 * représente tous les champs

FETCH?

FETCH cur1 INTO .....
DELETE ... WHERE CURRENT OF cur1

Lire les commentaires | Laisser un commentaire