Select
From
Where
Order by
|
Exemple 1
Select *
From ateliers_eleves
Where J1 like '%trpers%'
Order by A_eleve
|
Exemple 2
Select Nom, Prenom, L1, L2
From ateliers.eleves, ateliers_eleves
Where Classe='1L' and A_eleve=Utilis
Order by Nom |
Alter table
Action
Champ
Varchar
(nbcaract.)
After
|
Exemple 1
Alter table ateliers_eleves
Add Champ3 Varchar(10)
After Champ2
Alter table ateliers_eleves
Drop Champ3
Alter table ateliers_eleves
Change Champ3 Champs_3
|
Exemples de requêtes complètes
create table table1 (Code varchar(10),Nombre smallint)
create table table2 as select * from table1
alter table ateliers add primary key (Code)
describe ateliers
insert into ateliers (Code,Titre) values ('ap1','Essai')
update ateliers set Titre='Ess2',Titre2='Ess3' where Code='a1'
insert into salles_J1 as select * from salles.nbplaces where ..
(insere une ligne d'une autre table)
delete from table1 (efface les donnees)
delete from table1 where Code like 'ap%'
drop table table1 (efface la table)
|