You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
14 lines
480 B
14 lines
480 B
CREATE TABLE nodeapi.users
|
|
(
|
|
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
|
|
nom VARCHAR(100),
|
|
prenom VARCHAR(100),
|
|
email VARCHAR(255)
|
|
);
|
|
|
|
INSERT INTO `users` (`id`, `nom`, `prenom`, `email`) VALUES
|
|
(1, 'Brault', 'Benjamin', 'braultr.benjamin@outlook.fr'),
|
|
(2, 'Dupont', 'Jean', 'dupont.jean@gmail.com'),
|
|
(3, 'Delaporte', 'Camille', 'delaporte.camille@gmail.com'),
|
|
(4, 'Dupre', 'Pascal', 'dupre.pascal@gmail.com'),
|
|
(5, 'Bourgeon', 'Lucie', 'bourgeon.lucie@gmail.com'); |