Differences

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

--- unraid:dockers:tomcat [2023/08/20 16:13] – [App Settings] dirk
+++ unraid:dockers:tomcat [2023/08/20 20:14] (current) – [Add football season] dirk
@@ Line 37: / Line 37: @@
     * Note2: MUST CHANGE import javax.servlet.* to import jakarta.servlet.* in all the .java files under the WEB-INF folder before compiling with above.
     * Restart
+==== 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
+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