1) Install the Beautiful Soup python library. What commands did you use? 2) Install the Mariadb mysql server. What com
Posted: Wed Apr 27, 2022 3:06 pm
1) Install the Beautiful Soup python library. What
commands did you use?
2) Install the Mariadb mysql server. What commands did you
use?
3) Using your Mariadb mysql database, create a database and
table that you can query to display the number of babies born each
year that had your name. So you should be able to run
something like:
select * from babynames where name = "Mark" and sex = "M" order
by year;
and get results something like:
('MD', 'M', 1917, 'Mark', 7)
('MD', 'M', 1919, 'Mark', 9)
('MD', 'M', 1920, 'Mark', 10)
. . .
('MD', 'M', 2018, 'Mark', 34)
('MD', 'M', 2019, 'Mark', 22)
('MD', 'M', 2020, 'Mark', 21)
commands did you use?
2) Install the Mariadb mysql server. What commands did you
use?
3) Using your Mariadb mysql database, create a database and
table that you can query to display the number of babies born each
year that had your name. So you should be able to run
something like:
select * from babynames where name = "Mark" and sex = "M" order
by year;
and get results something like:
('MD', 'M', 1917, 'Mark', 7)
('MD', 'M', 1919, 'Mark', 9)
('MD', 'M', 1920, 'Mark', 10)
. . .
('MD', 'M', 2018, 'Mark', 34)
('MD', 'M', 2019, 'Mark', 22)
('MD', 'M', 2020, 'Mark', 21)