BDD Quêtes Express

employee_table_data.sql

INSERT INTO employee (lastname, firstname, email) VALUES
('Ramirez', 'Violet', '[email protected]'),
('Mannucci', 'Carlos', '[email protected]'),
('Ikeda', 'Susan', '[email protected]'),
('McGuire', 'Sean', '[email protected]'),
('Cavicchi', 'Jon', '[email protected]'),
('Verbeek', 'Peter', '[email protected]'),
('Wong', 'Todd', '[email protected]'),
('Watson', 'Alice', '[email protected]'),
('Ciabatti', 'Millie', '[email protected]'),
('Marino', 'Alejandro', '[email protected]'),
('Patterson', 'Maud', '[email protected]'),
('Diez', 'Andre', '[email protected]'),
('Dean', 'Jackson', '[email protected]'),
('Bernardi', 'Barbara', '[email protected]'),
('Valk', 'Cameron', '[email protected]'),
('van Oosten', 'Calvin', 'Calvin.van [email protected]'),
('Mazzei', 'Ollie', '[email protected]'),
('Blake', 'Jack', '[email protected]'),
('Tran', 'Edwin', '[email protected]'),
('Butler', 'Celia', '[email protected]'),
('Bouvier', 'Adele', '[email protected]'),
('Amato', 'Dylan', '[email protected]'),
('Black', 'Louisa', '[email protected]'),
('Ndiaye', 'Lloyd', '[email protected]'),
('Carrai', 'Mattie', '[email protected]'),
('van der Heijden', 'Stephen', 'Stephen.van der [email protected]'),
('Rodgers', 'Ollie', '[email protected]'),
('Cantini', 'Brent', '[email protected]'),
('Michel', 'Ricardo', '[email protected]'),
('Hunt', 'Gabriel', '[email protected]'),
('Sanz', 'Chris', '[email protected]'),
('Guerrero', 'Cora', '[email protected]');

employee_table_structure.sql

CREATE TABLE `employee` (
  `id` int(11) NOT NULL,
  `lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `employee` ADD PRIMARY KEY (`id`);
ALTER TABLE `employee` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;