$14$ rows in set $(0\mathrm{.}070sec)$

MariaDB $[$baseball$\_$stats$]>$ LOAD DATA INFILE 'path$\_$to$\_$php$-$practice$/$Chapter $\mathrm{.}07/$Projects$/$tean$\_$stats.txt$\text{'}$

$$ INTO TABLE teamstats;

ERROR $29($HYOOO$)$: File $\text{'}$C: $|$xampplmysql$|$datalpath$\_$to$\_$php$-$practice$|$Chapter $.$ O$7$ NProjectslteam$\_$stats.txt$\text{'}$ not found $($Errcode: $2"$No such file or dire ctory"$)$

MariaDB $[$baseball$\_$stats$]>$ LOAD DATA INFILE 'path$\_$to$\_$PHP$\_$folders$/$Chapter$.07/$Projects$/$team$\_$stats.txt$\text{'}$

$$ INTO TABLE teamstats;

ERROR $29($HYOO$0)$: File $\text{'}$C: $|$xampp$|$mysql$|$datalpath$\_$to$\_$PHP$\_$folders$|$Chapter$.$ o$7$ Projects$/$tean$\_$stats, txt$\text{'}$ not found $($Errcode: $2"$No such file or direc tory"$)$

MariaDB $[$baseball$\_$stats$]>$ LOAD DATA INFILE $\text{'}$E:$/$xampp$/$mysql$/$data$/$Chapter$.07/$Projects$/$tean$\_$stats, txt$\text{'}$

$$ INTO TABLE teamstats;

ERROR $29($HYOOO$)$: File $\text{'}$E: $|$xampp$|$mysql$|$datalChapter$.07$ NProjects $|$tean$\_$sta ts$.$txt$\text{'}$ not found $($Exrcode: $2"$Wo such file or directory"$)$

MariaDB $[$baseball$\_$stats$]>$ LOAD DATA INFILE $\text{'}$E:$/$xampp$/$mysql$/$data$//$Chapter$.$

$07/$Projects$/$tean$\_$stats, txt$\text{'}$

$7.$ Enter a LOAD DATA statement that inserts records from the team$\_$stats.txt file in your Projects directory for Chapter $7$ into the teamstats table. Replace path$\_$to$\_$PHP$\_$folders with the full path for your PHP$\_$Projects directory for Chapter $7.$

mysql$>$ LOAD DATA INFILE 'path$\_$to$\_$PHP$\_$folders$/$ Chapter$\mathrm{.}07/$Projects$/$team$\_$stats.txt$\text{'}[$ENTER $$ INT$0$ TABLE teamstats; $[$ENTER harr $]$

$8.$ After you see the "Query OK$"$ message, enter the following command to view all the records in the teams tats table:

mysq $7>$ SELECT $*$ FROM teamstats; $[$ENTER darr

Exercise $7-2$

In this project, you will write SQL statements that return team names, games played, and number of at$-$bats from the teamstats table in the baseba$17\_$stats database. You will also write SQL statemonte that roturn tho tonme that have tho lanct and most all time