Differences

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

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