create database presidents;

use presidents;

create table presidentsData (
    Presidential_num int primary key auto_increment,
    Last_Name varchar(20),
    First_Name varchar(20),
    Party varchar(50),
    Nickname varchar(50),
    Year_of_Birth varchar(5),
    Year_of_Death varchar(5),
    Term varchar(5),
    Decade varchar(5),
    Other_Positions varchar(255),
    Major_Accomplishments varchar(255),
    Wars_During_Office varchar(80)
);

create index idx_Last_Name ON presidentsData(Last_Name);
create index idx_Party ON presidentsData(Party);

Describe presidentsData;

insert into presidentsData
(Last_Name, First_Name, Party, Nickname, Year_of_Birth, Year_of_Death, Term, Decade, Other_Positions, Major_Accomplishments, Wars_During_Office)
value
( 'Washington', 'George ', 'nonpartisan ', 'Father of His Country', '1732', '1799', '2', '1789', 'Military Leader', 'Establishing the cabinet', 'American Revolutionary'),
( 'Adams', 'John ', 'Federalist', 'His Rotundity', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Jefferson', 'Thomas  ', 'Republican Party', 'Long Tom', '1743', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Madison', 'James  ', 'Republican Party', 'Little Jemmy', '1751', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Monroe', 'James  ', 'Republican Party', ' Last Cocked Hat', '1758', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Adams', 'John Quincy  ', 'Republican Party', 'Old Man Eloquent', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Jackson', 'Andrew  ', 'Democratic Party', 'Jackass', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Buren', 'Martin ', 'Democratic Party', 'Blue Whiskey Van ', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Harrison', 'William  ', 'Whig Party', 'Old Granny', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Tyler', 'John ', 'Whig Party', 'His Accidency', '1735', '1826', '0', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Polk', 'James  ', 'Democratic Party', 'Young Hickory', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Taylor', 'Zachary ', 'Whig Party', 'Old Rough and Ready', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Fillmore', 'Millard ', 'Whig Party', 'Last of the Whigs', '1735', '1826', '0', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Pierce', 'Franklin  ', 'Democratic Party', 'Purse', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Buchanan', 'James  ', 'Democratic Party', 'Old Buck', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Lincoln', 'Abraham  ', 'Republican Party', 'Abe', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Johnson', 'Andrew  ', 'Democratic Party', 'Sir Veto', '1735', '1826', '0', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Grant', 'Ulysses  ', 'Republican Party', 'Butcher', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Hayes', 'Rutherford  ', 'Republican Party', 'Dark Horse President', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Garfield', 'James  ', 'Republican Party', 'Canal Boy', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Arthur', 'Chester  ', 'Republican Party', 'Chet', '1735', '1826', '0', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Cleveland', 'Grover  ', 'Democratic Party', 'Big Steve', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Harrison', 'Benjamin  ', 'Republican Party', 'Human Iceberg', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Cleveland', 'Grover ', 'Democratic Party', 'Big Steve', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'McKinley', 'William  ', 'Republican Party', 'Major', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Roosevelt', 'Theodore  ', 'Republican Party', 'Teddy', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Taft', 'William  ', 'Republican Party', 'Big Bill', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Wilson', 'Woodrow  ', 'Democratic Party', 'Phrasemaker', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Harding', 'Warren  ', 'Republican Party', 'Wobbly Warren', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Coolidge', 'Calvin  ', 'Republican Party', 'Cal', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Hoover', 'Herbert ', 'Republican Party', 'Chief', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Roosevelt', 'Franklin ', 'Democratic Party', 'FDR', '1735', '1826', '4', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Truman', 'Harry  ', 'Democratic Party', 'Haberdasher Harry', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Eisenhower', 'Dwight  ', 'Republican Party', 'Ike', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Kennedy', 'John  ', 'Democratic Party', 'American Erlander', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Johnson', 'Lyndon  ', 'Democratic Party', 'Bull Johnson', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Nixon', 'Richard  ', 'Republican Party', 'Tricky Dick', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Ford', 'Gerald  ', 'Republican Party', 'Jerry', '1735', '1826', '0', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Carter', 'Jimmy  ', 'Democratic Party', 'Jimmy', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Reagan', 'Ronald  ', 'Republican Party', 'Dutch', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Bush', 'George H.W ', 'Republican Party', 'Papa Bush', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Clinton', 'Bill  ', 'Democratic Party', 'Bubba', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Bush', 'George W ', 'Republican Party', 'Dubya', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Obama', 'Barack  ', 'Democratic Party', 'Barry O’Bomber', '1735', '1826', '2', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Trump', 'Donald  ', 'Republican Party', 'President Snowflake', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')
( 'Biden', 'Joe  ', 'Democratic Party', 'Sleepy Joe', '1735', '1826', '1', '1797', 'political philosopher', 'The Convention of Montefontaine', 'French Revolutionary')



;

select * from presidentsData;


drop database presidents;