· 6 years ago · Sep 25, 2019, 09:02 PM
1CREATE TABLE IF NOT EXISTS tbl_people (
2 ID INT AUTO_INCREMENT,
3 FNAME VARCHAR(255) NULL,
4 LNAME VARCHAR(255) NULL,
5 EMAIL VARCHAR(255) NULL,
6 POST INTEGER NULL,
7 PRIMARY KEY(ID)
8) AUTO_INCREMENT = 1;
9
10INSERT 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);
11
12INSERT 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);