-- Tristan Sabol 
-- Due Date 10/18/24
-- My Databse 
-- This program creates a datbase of what the Infotamtion of a person is 
-- This creates the database and what name it is 
Create Database InTro;
--  This swicthes use into my database to put data in 
use InTro;
-- This  Creates a table and then i put the field into the table 
Create table pinfo (
id int primary key auto_increment,
First_Name varchar (20),
Last_Name varchar (20),
Address_ varchar (20),
City varchar (20),
State_ varchar (2),
Zip_code varchar (5)
);
-- This give the info to make sure that i did the table correctly 
Describe pinfo;
-- this insert the values into the table and saves it there
insert into pinfo
(First_Name, Last_Name, Address_, City, State_, Zip_code)
-- This is the vaules that get inseted into the table 
value
("Stephen","Angelella","2788 Marion Stree","Bellmore","NY","11710"),
("Allen","Attaway","PO Box 643","Piscataway","NJ","08855"),
("Baron","Ballester","186 Lexington Avenue","Westwood","NJ","07675"),
("George","Bartels","77 Allen Road","Rockville Centre","NY","11570"),
("Michael","Bartolome","228 South 17th Avenue","Manville","NJ","08835"),
("Hugh","Bentley","7 Holly Treee Lane","East Islip","NY","11730"),
("Robert","Bielsky","931 Peninsula Blvd","Woodmere","NY","11598"),
("George","Botsch","511 Rockaway Street","West Islip","NY","11795"),
("Duane","Burrell","22 Van Buskirk Rd","Teaneck","NJ","07666"),
("Michael","Caldarella","108 Kemah-Mecca Lake Road","Newton","NJ","07860")
;
-- This displays the text in a sql table by pull the data togather in a graph 
select * from pinfo;
-- This is to Drop or delete the database from the Server 
drop database InTro;