· 6 years ago · Sep 25, 2019, 08:56 PM
1use containerdb;
2
3CREATE TABLE IF NOT EXISTS tbl_people (
4 ID INT AUTO_INCREMENT,
5 FNAME VARCHAR(255) NULL,
6 LNAME VARCHAR(255) NULL,
7 EMAIL VARCHAR(255) NULL,
8 POST INTEGER NULL,
9 PRIMARY KEY(ID)
10) AUTO_INCREMENT = 1;
11
12INSERT INTO tbl_people(FNAME,LNAME,EMAIL,POST) VALUES('Aileen','Sullivan','nec.tempus.mauris@musProin.net',22),('Erica','Frank','consectetuer.adipiscing@purusaccumsan.net',44),('David','Clemons','Nulla@nec.net',21),('Raja','Travis','elit@vitaesodales.com',92),('Reese','Tucker','amet@rutrumlorem.net',36),('Branden','Bernard','a.auctor@convallis.ca',57),('Jermaine','Crosby','ac@Vivamusnibh.ca',80),('Breanna','Barker','aliquet.magna.a@eleifend.com',74),('Jenna','Taylor','ac.arcu.Nunc@Pellentesque.ca',74),('Aristotle','Gonzalez','molestie.dapibus.ligula@intempus.com',3);
13
14INSERT INTO tbl_people(FNAME,LNAME,EMAIL,POST) VALUES('Demetrius','Eaton','eu.nulla@semperNamtempor.com',18),('Hedda','Navarro','metus.In@blandit.com',29),('Marsden','Hunter','fringilla.porttitor.vulputate@vehiculaPellentesquetincidunt.edu',89),('Aladdin','Watkins','cubilia.Curae.Donec@acarcuNunc.net',95),('Nehru','Boyd','pede@Curabitur.com',96),('Dana','Schroeder','fermentum.risus.at@Nuncmauris.edu',67),('Kelly','Snow','odio.Etiam.ligula@libero.org',74),('Ian','Giles','consequat.purus.Maecenas@amet.edu',48),('Kelsie','Acevedo','arcu.Morbi.sit@fringillapurusmauris.org',17),('Blair','Guerra','velit.Aliquam.nisl@sem.edu',74);