Plastic in The Ocean

Create Table SQL

     CREATE TABLE tblAnimals(
        pmkAnimalsId INT AUTO_INCREMENT PRIMARY KEY,
        fldAnimal varchar(30),
        fldAffect varchar(200),
        fldEndangered varchar(10)
     );   
 

Populate table with data

     INSERT INTO tblAnimals
     (fldAnimal, fldEffect, fldEndangered)
     VALUES

     ('Turtles', 'Over 1000 die every year', 'Yes'),

     ('Whale Sharks', 'Plastic piles up in the stomach and prevents nutrient intake', 'Yes'),

     ('Seagulls', 'Plastic may puncture organs', 'No');
     

Select Data for Display

     SELECT fldAnimal, fldEffect, fldEndangered FROM tblAnimals