Scribd
Upload
8 views11 pages

Bases de Donnees Create Table Add Change

Uploaded by

Elhadji sahinth Thiam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
8 views11 pages

Bases de Donnees Create Table Add Change

Uploaded by

Elhadji sahinth Thiam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 11

Microsoft Windows [version 10.0.19044.

1706]
(c) Microsoft Corporation. Tous droits réservés.

C:\Users\Easy Services 2.0>mysql -h localhost -u root -p


Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 32
Server version: 10.4.24-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;


+--------------------+
| Database |
+--------------------+
| albert bakhoum |
| bdd_uam2022 |
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
+--------------------+
7 rows in set (0.001 sec)

MariaDB [(none)]> create user UAM_ESTI identified by 'passer';


Query OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> grant all privileges on *.* to UAM_ESTI;


Query OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> exit


Bye

C:\Users\Easy Services 2.0>mysql -h localhost -u UAM_ESTI -p


Enter password: ******
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 33
Server version: 10.4.24-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show grants;


+----------------------------------------------------------------------------------
--------------------------------+
| Grants for UAM_ESTI@%
|
+----------------------------------------------------------------------------------
--------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `UAM_ESTI`@`%` IDENTIFIED BY PASSWORD
'*483EC567DF968A6AD5E279257828E7CC4A12F0C2' |
+----------------------------------------------------------------------------------
--------------------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> use uam_ESTI_L2;
Database changed
MariaDB [uam_ESTI_L2]> show grants;
+----------------------------------------------------------------------------------
--------------------------------+
| Grants for UAM_ESTI@%
|
+----------------------------------------------------------------------------------
--------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `UAM_ESTI`@`%` IDENTIFIED BY PASSWORD
'*483EC567DF968A6AD5E279257828E7CC4A12F0C2' |
+----------------------------------------------------------------------------------
--------------------------------+
1 row in set (0.000 sec)

MariaDB [uam_ESTI_L2]> create table etudiants(


-> NumEtud int not null primary key,
-> Prenom varchar(50),
-> Nom varchar(50),
-> Ville varchar(50),
-> NumCours int unique,
-> Numclasse int unique);
Query OK, 0 rows affected (0.028 sec)

MariaDB [(none)]> use bdd_uam2022;


Database changed
MariaDB [bdd_uam2022]> create table prof(
-> idprof int,
-> grade varchar(50),
-> specialite varchar(50),
-> typeContrat varchar(50));
Query OK, 0 rows affected (0.034 sec)

MariaDB [bdd_uam2022]> exit


Bye

C:\Users\Easy Services 2.0>mysql -u UAM2022_ESTI -p


Enter password: ******
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 67
Server version: 10.4.24-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show Databases;


+--------------------+
| Database |
+--------------------+
| albert bakhoum |
| bdd_uam2022 |
| esit_ii |
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
| uam_esti_l2 |
+--------------------+
9 rows in set (0.001 sec)

MariaDB [(none)]> use bdd_uam2022;


Database changed
MariaDB [bdd_uam2022]> show tables;
+-----------------------+
| Tables_in_bdd_uam2022 |
+-----------------------+
| personnes |
| prof |
+-----------------------+
2 rows in set (0.000 sec)

MariaDB [bdd_uam2022]> create table matiere (id_matiere varchar(50) primary key,


NomMatiere varchar(50), Date datetime, Heure datetime);
Query OK, 0 rows affected (0.026 sec)

MariaDB [bdd_uam2022]> create table Classe(id_classe varchar(20) primary key,


NomClasse varchar(20), Niveau varchar(20), NbreEtudiants int, check(NbreEtudiants <
100));
Query OK, 0 rows affected (0.027 sec)

MariaDB [bdd_uam2022]> create table filiere (id_Filiere varchar(50) primary key,


NomFiliere varchar(50));
Query OK, 0 rows affected (0.024 sec)

MariaDB [bdd_uam2022]> create table Ecole(id_Ecole varchar(50) primary key,


NomEcole varchar(50));
Query OK, 0 rows affected (0.027 sec)

MariaDB [bdd_uam2022]> create table Etudiant(id_Etudiant varchar(50) primary key,


codePermanent varchar(50) unique, sexe char(5), LyceeOrigine varchar(50),
DateNaissance datetime);
Query OK, 0 rows affected (0.028 sec)

MariaDB [bdd_uam2022]> show tables;


+-----------------------+
| Tables_in_bdd_uam2022 |
+-----------------------+
| classe |
| ecole |
| etudiant |
| filiere |
| matiere |
| personnes |
| prof |
+-----------------------+
7 rows in set (0.001 sec)

MariaDB [bdd_uam2022]> exit


Bye

C:\Users\Easy Services 2.0>mysql -u UAM2022_ESTI -p


Enter password: ******
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 76
Server version: 10.4.24-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;


+--------------------+
| Database |
+--------------------+
| albert bakhoum |
| bdd_uam2022 |
| esit_ii |
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| restauration |
| test |
| uam_esti_l2 |
+--------------------+
10 rows in set (0.001 sec)

MariaDB [(none)]> use bdd_uam2022;


Database changed
MariaDB [bdd_uam2022]> show tables;
+-----------------------+
| Tables_in_bdd_uam2022 |
+-----------------------+
| classe |
| ecole |
| etudiant |
| filiere |
| matiere |
| personnes |
| prof |
+-----------------------+
7 rows in set (0.001 sec)

MariaDB [bdd_uam2022]> desc etudiant;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_Etudiant | varchar(50) | NO | PRI | NULL | |
| codePermanent | varchar(50) | YES | UNI | NULL | |
| sexe | char(5) | YES | | NULL | |
| LyceeOrigine | varchar(50) | YES | | NULL | |
| DateNaissance | datetime | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.012 sec)

MariaDB [bdd_uam2022]> desc prof;


+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| idprof | int(11) | YES | | NULL | |
| grade | varchar(50) | YES | | NULL | |
| specialite | varchar(50) | YES | | NULL | |
| typeContrat | varchar(50) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
4 rows in set (0.010 sec)

MariaDB [bdd_uam2022]> desc ecole;


+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| id_Ecole | varchar(50) | NO | PRI | NULL | |
| NomEcole | varchar(50) | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
2 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> desc personnes;


+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| id_personne | varchar(50) | NO | PRI | NULL | |
| prenom | varchar(50) | YES | | NULL | |
| num_tel | varchar(50) | YES | UNI | NULL | |
| email | varchar(50) | YES | UNI | NULL | |
| age | int(11) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
5 rows in set (0.011 sec)

MariaDB [bdd_uam2022]> desc Classe;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_classe | varchar(20) | NO | PRI | NULL | |
| NomClasse | varchar(20) | YES | | NULL | |
| Niveau | varchar(20) | YES | | NULL | |
| NbreEtudiants | int(11) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
4 rows in set (0.010 sec)

MariaDB [bdd_uam2022]> drop table personnes;


Query OK, 0 rows affected (0.011 sec)

MariaDB [bdd_uam2022]> show tables;


+-----------------------+
| Tables_in_bdd_uam2022 |
+-----------------------+
| classe |
| ecole |
| etudiant |
| filiere |
| matiere |
| prof |
+-----------------------+
6 rows in set (0.001 sec)

MariaDB [bdd_uam2022]> desc matiere;


+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_matiere | varchar(50) | NO | PRI | NULL | |
| NomMatiere | varchar(50) | YES | | NULL | |
| Date | datetime | YES | | NULL | |
| Heure | datetime | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.011 sec)

MariaDB [bdd_uam2022]> alter table matiere add nbrecredit varchar(20) after Date;
Query OK, 0 rows affected (0.012 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc matiere;


+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_matiere | varchar(50) | NO | PRI | NULL | |
| NomMatiere | varchar(50) | YES | | NULL | |
| Date | datetime | YES | | NULL | |
| nbrecredit | varchar(20) | YES | | NULL | |
| Heure | datetime | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.010 sec)

MariaDB [bdd_uam2022]> alter table matiere change Date Date_Debut_Matiere datetime;


Query OK, 0 rows affected (0.012 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> alter table matiere change Heure Date_Fin_Matiere datetime;


Query OK, 0 rows affected (0.009 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc prof;


+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| idprof | int(11) | YES | | NULL | |
| grade | varchar(50) | YES | | NULL | |
| specialite | varchar(50) | YES | | NULL | |
| typeContrat | varchar(50) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
4 rows in set (0.010 sec)

MariaDB [bdd_uam2022]> alter table prof add Dernier_Diplome varchar(50) not null
after specialite;
Query OK, 0 rows affected (0.009 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc prof;


+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| idprof | int(11) | YES | | NULL | |
| grade | varchar(50) | YES | | NULL | |
| specialite | varchar(50) | YES | | NULL | |
| Dernier_Diplome | varchar(50) | NO | | NULL | |
| typeContrat | varchar(50) | YES | | NULL | |
+-----------------+-------------+------+-----+---------+-------+
5 rows in set (0.010 sec)

MariaDB [bdd_uam2022]> desc etudiant;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_Etudiant | varchar(50) | NO | PRI | NULL | |
| codePermanent | varchar(50) | YES | UNI | NULL | |
| sexe | char(5) | YES | | NULL | |
| LyceeOrigine | varchar(50) | YES | | NULL | |
| DateNaissance | datetime | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> show tables;


+-----------------------+
| Tables_in_bdd_uam2022 |
+-----------------------+
| classe |
| ecole |
| etudiant |
| filiere |
| matiere |
| prof |
+-----------------------+
6 rows in set (0.001 sec)

MariaDB [bdd_uam2022]> desc classe;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_classe | varchar(20) | NO | PRI | NULL | |
| NomClasse | varchar(20) | YES | | NULL | |
| Niveau | varchar(20) | YES | | NULL | |
| NbreEtudiants | int(11) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
4 rows in set (0.008 sec)

MariaDB [bdd_uam2022]> alter table classe add constraint check(0 < NbreEtudiants <
100);
Query OK, 0 rows affected (0.051 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc classe;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_classe | varchar(20) | NO | PRI | NULL | |
| NomClasse | varchar(20) | YES | | NULL | |
| Niveau | varchar(20) | YES | | NULL | |
| NbreEtudiants | int(11) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
4 rows in set (0.013 sec)

MariaDB [bdd_uam2022]> alter table classe add constraint nomclasse


unique(NomClasse);
Query OK, 0 rows affected (0.014 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc classe;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_classe | varchar(20) | NO | PRI | NULL | |
| NomClasse | varchar(20) | YES | UNI | NULL | |
| Niveau | varchar(20) | YES | | NULL | |
| NbreEtudiants | int(11) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
4 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> alter table prof add Promotion varchar(50) not null;
Query OK, 0 rows affected (0.011 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc classe;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_classe | varchar(20) | NO | PRI | NULL | |
| NomClasse | varchar(20) | YES | UNI | NULL | |
| Niveau | varchar(20) | YES | | NULL | |
| NbreEtudiants | int(11) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
4 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> alter table classe add Promotion varchar(50) not null;
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc classe;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_classe | varchar(20) | NO | PRI | NULL | |
| NomClasse | varchar(20) | YES | UNI | NULL | |
| Niveau | varchar(20) | YES | | NULL | |
| NbreEtudiants | int(11) | YES | | NULL | |
| Promotion | varchar(50) | NO | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.008 sec)

MariaDB [bdd_uam2022]> alter table prof drop Promotion;


Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc prof;


+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| idprof | int(11) | YES | | NULL | |
| grade | varchar(50) | YES | | NULL | |
| specialite | varchar(50) | YES | | NULL | |
| Dernier_Diplome | varchar(50) | NO | | NULL | |
| typeContrat | varchar(50) | YES | | NULL | |
+-----------------+-------------+------+-----+---------+-------+
5 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> alter table prof add id_personne varchar(50) not null;
Query OK, 0 rows affected (0.013 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [bdd_uam2022]> desc etudiant;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_Etudiant | varchar(50) | NO | PRI | NULL | |
| codePermanent | varchar(50) | YES | UNI | NULL | |
| sexe | char(5) | YES | | NULL | |
| LyceeOrigine | varchar(50) | YES | | NULL | |
| DateNaissance | datetime | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> alter table etudiant add id_personne varchar(50) not null;
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc etudiant;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_Etudiant | varchar(50) | NO | PRI | NULL | |
| codePermanent | varchar(50) | YES | UNI | NULL | |
| sexe | char(5) | YES | | NULL | |
| LyceeOrigine | varchar(50) | YES | | NULL | |
| DateNaissance | datetime | YES | | NULL | |
| id_personne | varchar(50) | NO | | NULL | |
+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> desc prof;


+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| idprof | int(11) | YES | | NULL | |
| grade | varchar(50) | YES | | NULL | |
| specialite | varchar(50) | YES | | NULL | |
| Dernier_Diplome | varchar(50) | NO | | NULL | |
| typeContrat | varchar(50) | YES | | NULL | |
| id_personne | varchar(50) | NO | | NULL | |
+-----------------+-------------+------+-----+---------+-------+
6 rows in set (0.008 sec)

MariaDB [bdd_uam2022]> alter table matiere add idprof varchar(50) not null;
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> alter table matiere add id_classe varchar(50) not null;
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> alter table etudiant add id_classe varchar(50) not null;
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc prof;


+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| idprof | int(11) | YES | | NULL | |
| grade | varchar(50) | YES | | NULL | |
| specialite | varchar(50) | YES | | NULL | |
| Dernier_Diplome | varchar(50) | NO | | NULL | |
| typeContrat | varchar(50) | YES | | NULL | |
| id_personne | varchar(50) | NO | | NULL | |
+-----------------+-------------+------+-----+---------+-------+
6 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> desc classe;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_classe | varchar(20) | NO | PRI | NULL | |
| NomClasse | varchar(20) | YES | UNI | NULL | |
| Niveau | varchar(20) | YES | | NULL | |
| NbreEtudiants | int(11) | YES | | NULL | |
| Promotion | varchar(50) | NO | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.010 sec)

MariaDB [bdd_uam2022]> desc matiere;


+--------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------+------+-----+---------+-------+
| id_matiere | varchar(50) | NO | PRI | NULL | |
| NomMatiere | varchar(50) | YES | | NULL | |
| Date_Debut_Matiere | datetime | YES | | NULL | |
| nbrecredit | varchar(20) | YES | | NULL | |
| Date_Fin_Matiere | datetime | YES | | NULL | |
| idprof | varchar(50) | NO | | NULL | |
| id_classe | varchar(50) | NO | | NULL | |
+--------------------+-------------+------+-----+---------+-------+
7 rows in set (0.009 sec)

MariaDB [bdd_uam2022]> desc filiere;


+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_Filiere | varchar(50) | NO | PRI | NULL | |
| NomFiliere | varchar(50) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
2 rows in set (0.011 sec)

MariaDB [bdd_uam2022]> alter table classe add id_filiere varchar(50) not null;
Query OK, 0 rows affected (0.011 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> alter table filiere add id_ecole varchar(50) not null;
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [bdd_uam2022]> desc filiere;


+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_Filiere | varchar(50) | NO | PRI | NULL | |
| NomFiliere | varchar(50) | YES | | NULL | |
| id_ecole | varchar(50) | NO | | NULL | |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.011 sec)

MariaDB [bdd_uam2022]> create table personnes(id_personne varchar(50) primary key,


prenom varchar(50), nom varchar(50), num_telephone varchar(50) unique, email
varchar(50), age int, check(email like "%@%"));
Query OK, 0 rows affected (0.027 sec)

MariaDB [bdd_uam2022]> desc personnes;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_personne | varchar(50) | NO | PRI | NULL | |
| prenom | varchar(50) | YES | | NULL | |
| nom | varchar(50) | YES | | NULL | |
| num_telephone | varchar(50) | YES | UNI | NULL | |
| email | varchar(50) | YES | | NULL | |
| age | int(11) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.009 sec)

MariaDB [bdd_uam2022]>

You might also like