Differences

This shows you the differences between two versions of the page.

--- unraid:dockers:tomcat [2023/08/20 20:13] – [Add football season] dirk
+++ unraid:dockers:tomcat [2023/08/20 20:14] (current) – [Add football season] dirk
@@ Line 40: / Line 40: @@
 ==== Add football season ====
 <code>docker cp /mnt/user/backup/webpage/mysql/2023o.csv mysql:/var/lib/mysql-files/</code>
-<code>mysql --local-infile=1 -uUSERNAME -p</code>
+<code>mysql --local-infile=1 -uUSERNAME -p
-<code>use DB;
+use DB;
-<code>LOAD DATA LOCAL INFILE "2023o.csv" INTO TABLE games_nfl COLUMNS TERMINATED BY ',';
+LOAD DATA LOCAL INFILE "2023o.csv" INTO TABLE games_nfl COLUMNS TERMINATED BY ',';
 UPDATE games_nfl SET vscore = NULL where year = 2023;
 UPDATE games_nfl SET hscore = NULL where year = 2023;</code>

brimble.com