Exercise 7-1 If you do notIn this project, you will create a database to contain tables of batting ave database statistics for major league baseball teams. You will then create a table creation prenamed teamstats in the baseba11 stats database and add records eges, skip t to the new table from a file ?armed team-stats txt in your Projects through 3. f you do not directory for Chapter 7 have the FILE prvlege Log in to MySOL skip this exercise Monitor with your root account or with the user name and password supplied by your ISP or instructor Enter the following command to create a database named mysql> CREATE DATABASE baseba11 stats: [ENTER command to select the basebal1 stats database mysql> USE baseball stats: CENTER 2. 3. After you see the "Query OK message, enter the following 4. After you see the "Database changed message, type the following command to ensure that you selected the basebal1 stats database mysqla SELECT DATABASEO:CENTER 5. Enter the following command to create the teamstats table. 439 The Team field uses the VARCHAR data type. Eleven of the col- umns use INT data types, and the remaining two fields use FLOAT data types. Each of the statistical field names uses com- mon baseball abbreviations, such as G for bats, R for runs, and HR for home runs games, AB for at- rysqla CREATE TABLE teamstats CTeam VAROHARCSO) FirstYear INT, [ENTER -> R INT- AB INT, H INT?HR INT. ANG FLAT-CENTER+] RA INT, ERA FLOAT): [ENTER 6. After you see the "Query OK message, enter the following command to display the structure of the new table ysqla DESCRIBE teanstats: CENTER Enter a LOAD DATA statement that inserts records from the team stats.txt file in your Projects directory for Chapter into the teamstats table. Replace path to PHP_ folders with the full path for your PHP_Projects directory for Chapter7 mysql> LOAD DATA INFILE "path to PNP folders/ Chapter.07/Projects/team stats.txt'CENTER 7. MySOL serv ers direc INTO TABLE teanstats;CENTER URL path 8. After you see the "Query OK message, enter the following command to view all the records in the teamstats table mysql> SELECT FROM teamstats:[ENTER