Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2022-11-23 17:15:53 2022-11-23 22:15:53+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.28-1debian10 started.
- 2022-11-23 17:15:53 2022-11-23 22:15:53+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
- 2022-11-23 17:15:53 2022-11-23 22:15:53+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.28-1debian10 started.
- 2022-11-23 17:15:53 2022-11-23 22:15:53+00:00 [Note] [Entrypoint]: Initializing database files
- 2022-11-23 17:15:58 2022-11-23 22:15:58+00:00 [Note] [Entrypoint]: Database files initialized
- 2022-11-23 17:15:58 2022-11-23 22:15:58+00:00 [Note] [Entrypoint]: Starting temporary server
- 2022-11-23 17:15:59 2022-11-23 22:15:59+00:00 [Note] [Entrypoint]: Temporary server started.
- 2022-11-23 17:16:01
- 2022-11-23 17:16:01 2022-11-23 22:16:01+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/A_unzip_csvs.sh
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/allstar_full.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/appearances.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/awards_managers.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/awards_players.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/awards_share_managers.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/awards_share_players.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/batting.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/batting_post.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/college_playing.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/fielding.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/fielding_of.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/fielding_of_split.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/fielding_post.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/hall_of_fame.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/home_games.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/managers.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/managers_half.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/parks.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/people.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/pitching.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/pitching_post.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/salaries.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/schools.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/series_post.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/teams.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/teams_franchises.csv.zst...
- 2022-11-23 17:15:53 2022-11-23T22:15:53.754206Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.28) initializing of server in progress as process 43
- 2022-11-23 17:15:53 2022-11-23T22:15:53.763969Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
- 2022-11-23 17:15:54 2022-11-23T22:15:54.331767Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
- 2022-11-23 17:15:55 2022-11-23T22:15:55.631962Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
- 2022-11-23 17:15:59 2022-11-23T22:15:59.021048Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
- 2022-11-23 17:15:59 2022-11-23T22:15:59.021126Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28) starting as process 92
- 2022-11-23 17:15:59 2022-11-23T22:15:59.034907Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
- 2022-11-23 17:15:59 2022-11-23T22:15:59.173213Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
- 2022-11-23 17:15:59 2022-11-23T22:15:59.402679Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2022-11-23 17:15:59 2022-11-23T22:15:59.402736Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
- 2022-11-23 17:15:59 2022-11-23T22:15:59.404703Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
- 2022-11-23 17:15:59 2022-11-23T22:15:59.420533Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
- 2022-11-23 17:15:59 2022-11-23T22:15:59.420916Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.28' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
- 2022-11-23 17:16:00 Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
- 2022-11-23 17:16:00 Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
- 2022-11-23 17:16:01 Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
- 2022-11-23 17:16:01 Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
- /data/baseballdatabank/allstar_full.csv.zst: 218623 bytes
- /data/baseballdatabank/appearances.csv.zst: 6670476 bytes
- /data/baseballdatabank/awards_managers.csv.zst: 7980 bytes
- /data/baseballdatabank/awards_players.csv.zst: 256970 bytes
- /data/baseballdatabank/awards_share_managers.csv.zst: 22404 bytes
- /data/baseballdatabank/awards_share_players.csv.zst: 225669 bytes
- /data/baseballdatabank/batting.csv.zst: 6802963 bytes
- /data/baseballdatabank/batting_post.csv.zst: 966842 bytes
- /data/baseballdatabank/college_playing.csv.zst: 404449 bytes
- /data/baseballdatabank/fielding.csv.zst: 7250400 bytes
- /data/baseballdatabank/fielding_of.csv.zst: 286409 bytes
- /data/baseballdatabank/fielding_of_split.csv.zst: 1709211 bytes
- /data/baseballdatabank/fielding_post.csv.zst: 744910 bytes
- /data/baseballdatabank/hall_of_fame.csv.zst: 175244 bytes
- /data/baseballdatabank/home_games.csv.zst: 168203 bytes
- /data/baseballdatabank/managers.csv.zst: 137981 bytes
- /data/baseballdatabank/managers_half.csv.zst: 3421 bytes
- /data/baseballdatabank/parks.csv.zst: 11602 bytes
- /data/baseballdatabank/people.csv.zst: 2682264 bytes
- /data/baseballdatabank/pitching.csv.zst: 4366826 bytes
- /data/baseballdatabank/pitching_post.csv.zst: 536721 bytes
- /data/baseballdatabank/salaries.csv.zst: 774179 bytes
- /data/baseballdatabank/schools.csv.zst: 61208 bytes
- /data/baseballdatabank/series_post.csv.zst: 10881 bytes
- /data/baseballdatabank/teams.csv.zst: 591096 bytes
- /data/baseballdatabank/teams_franchises.csv.zst: 3203 bytes
- /data/baseballdatabank/teams_half.csv.zst: 1508 bytes
- /data/retrosheet/code_event.csv.zst: 386 bytes
- /data/retrosheet/code_field_park.csv.zst: 38 bytes
- /data/retrosheet/code_method_record.csv.zst: 30 bytes
- /data/retrosheet/code_pitches_record.csv.zst: 34 bytes
- /data/retrosheet/code_precip_park.csv.zst: 50 bytes
- /data/retrosheet/code_sky_park.csv.zst: 52 bytes
- /data/retrosheet/code_wind_direction_park.csv.zst: 129 bytes
- /data/retrosheet/comment.csv.zst: 15065398 bytes
- /data/retrosheet/daily.csv.zst: 2227573695 bytes
- /data/retrosheet/deduced_game.csv.zst: 48477 bytes
- 2022-11-23 17:16:01 Decompressing /data/baseballdatabank/teams_half.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/code_event.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/code_field_park.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/code_method_record.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/code_pitches_record.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/code_precip_park.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/code_sky_park.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/code_wind_direction_park.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/comment.csv.zst...
- 2022-11-23 17:16:01 Decompressing /data/retrosheet/daily.csv.zst...
- 2022-11-23 17:16:06 Decompressing /data/retrosheet/deduced_game.csv.zst...
- 2022-11-23 17:16:06 Decompressing /data/retrosheet/event.csv.zst...
- 2022-11-23 17:16:46 Decompressing /data/retrosheet/game.csv.zst...
- 2022-11-23 17:16:48 Decompressing /data/retrosheet/gamelog.csv.zst...
- 2022-11-23 17:16:50 Decompressing /data/retrosheet/park.csv.zst...
- 2022-11-23 17:16:50 Decompressing /data/retrosheet/roster.csv.zst...
- 2022-11-23 17:16:50 Decompressing /data/retrosheet/schedule.csv.zst...
- 2022-11-23 17:16:51 Decompressing /data/retrosheet/sub.csv.zst...
- 2022-11-23 17:16:51 CREATE SCHEMA baseballdatabank;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.allstar_full (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT,
- 2022-11-23 17:16:51 game_num SMALLINT,
- 2022-11-23 17:16:51 game_id VARCHAR(12),
- /data/retrosheet/event.csv.zst: 9020303844 bytes
- /data/retrosheet/game.csv.zst: 184203643 bytes
- /data/retrosheet/gamelog.csv.zst: 225296634 bytes
- /data/retrosheet/park.csv.zst: 20410 bytes
- /data/retrosheet/roster.csv.zst: 4135864 bytes
- /data/retrosheet/schedule.csv.zst: 13815077 bytes
- /data/retrosheet/sub.csv.zst: 85489205 bytes
- 2022-11-23 17:16:51 team_id VARCHAR(3),
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 gp SMALLINT,
- 2022-11-23 17:16:51 starting_pos SMALLINT,
- 2022-11-23 17:16:51 dummy_id INTEGER NOT NULL AUTO_INCREMENT,
- 2022-11-23 17:16:51 PRIMARY KEY (dummy_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.appearances (
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3) NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 g_all SMALLINT,
- 2022-11-23 17:16:51 gs SMALLINT,
- 2022-11-23 17:16:51 g_batting SMALLINT,
- 2022-11-23 17:16:51 g_defense SMALLINT,
- 2022-11-23 17:16:51 g_p SMALLINT,
- 2022-11-23 17:16:51 g_c SMALLINT,
- 2022-11-23 17:16:51 g_1b SMALLINT,
- 2022-11-23 17:16:51 g_2b SMALLINT,
- 2022-11-23 17:16:51 g_3b SMALLINT,
- 2022-11-23 17:16:51 g_ss SMALLINT,
- 2022-11-23 17:16:51 g_lf SMALLINT,
- 2022-11-23 17:16:51 g_cf SMALLINT,
- 2022-11-23 17:16:51 g_rf SMALLINT,
- 2022-11-23 17:16:51 g_of SMALLINT,
- 2022-11-23 17:16:51 g_dh SMALLINT,
- 2022-11-23 17:16:51 g_ph SMALLINT,
- 2022-11-23 17:16:51 g_pr SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (year_id, team_id, player_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.awards_managers (
- 2022-11-23 17:16:51 player_id VARCHAR(10) NOT NULL,
- 2022-11-23 17:16:51 award_id VARCHAR(75) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 tie VARCHAR(1),
- 2022-11-23 17:16:51 notes VARCHAR(100),
- 2022-11-23 17:16:51 dummy_id INTEGER NOT NULL AUTO_INCREMENT,
- 2022-11-23 17:16:51 PRIMARY KEY (dummy_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.awards_players (
- 2022-11-23 17:16:51 player_id VARCHAR(9),
- 2022-11-23 17:16:51 award_id VARCHAR(255),
- 2022-11-23 17:16:51 year_id SMALLINT,
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 tie VARCHAR(1),
- 2022-11-23 17:16:51 notes VARCHAR(100),
- 2022-11-23 17:16:51 dummy_id INTEGER NOT NULL AUTO_INCREMENT,
- 2022-11-23 17:16:51 PRIMARY KEY (dummy_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.awards_share_managers (
- 2022-11-23 17:16:51 award_id VARCHAR(25) NOT NULL,
- 2022-11-23 17:16:51 year_id INTEGER NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 player_id VARCHAR(10) NOT NULL,
- 2022-11-23 17:16:51 points_won INTEGER,
- 2022-11-23 17:16:51 points_max INTEGER,
- 2022-11-23 17:16:51 votes_first INTEGER,
- 2022-11-23 17:16:51 PRIMARY KEY (award_id, year_id, player_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.awards_share_players (
- 2022-11-23 17:16:51 award_id VARCHAR(25) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 points_won FLOAT(53),
- 2022-11-23 17:16:51 points_max INTEGER,
- 2022-11-23 17:16:51 votes_first FLOAT(53),
- 2022-11-23 17:16:51 PRIMARY KEY (award_id, year_id, player_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.batting (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 stint SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3),
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 ab SMALLINT,
- 2022-11-23 17:16:51 r SMALLINT,
- 2022-11-23 17:16:51 h SMALLINT,
- 2022-11-23 17:16:51 _2b SMALLINT,
- 2022-11-23 17:16:51 _3b SMALLINT,
- 2022-11-23 17:16:51 hr SMALLINT,
- 2022-11-23 17:16:51 rbi SMALLINT,
- 2022-11-23 17:16:51 sb SMALLINT,
- 2022-11-23 17:16:51 cs SMALLINT,
- 2022-11-23 17:16:51 bb SMALLINT,
- 2022-11-23 17:16:51 so SMALLINT,
- 2022-11-23 17:16:51 ibb SMALLINT,
- 2022-11-23 17:16:51 hbp SMALLINT,
- 2022-11-23 17:16:51 sh SMALLINT,
- 2022-11-23 17:16:51 sf SMALLINT,
- 2022-11-23 17:16:51 gidp SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, stint)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.batting_post (
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 round VARCHAR(10) NOT NULL,
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3),
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 ab SMALLINT,
- 2022-11-23 17:16:51 r SMALLINT,
- 2022-11-23 17:16:51 h SMALLINT,
- 2022-11-23 17:16:51 _2b SMALLINT,
- 2022-11-23 17:16:51 _3b SMALLINT,
- 2022-11-23 17:16:51 hr SMALLINT,
- 2022-11-23 17:16:51 rbi SMALLINT,
- 2022-11-23 17:16:51 sb SMALLINT,
- 2022-11-23 17:16:51 cs SMALLINT,
- 2022-11-23 17:16:51 bb SMALLINT,
- 2022-11-23 17:16:51 so SMALLINT,
- 2022-11-23 17:16:51 ibb SMALLINT,
- 2022-11-23 17:16:51 hbp SMALLINT,
- 2022-11-23 17:16:51 sh SMALLINT,
- 2022-11-23 17:16:51 sf SMALLINT,
- 2022-11-23 17:16:51 gidp SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (year_id, round, player_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.college_playing (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 school_id VARCHAR(15) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, school_id, year_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.fielding (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 stint SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3),
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 pos VARCHAR(2) NOT NULL,
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 gs SMALLINT,
- 2022-11-23 17:16:51 inn_outs SMALLINT,
- 2022-11-23 17:16:51 po SMALLINT,
- 2022-11-23 17:16:51 a SMALLINT,
- 2022-11-23 17:16:51 e SMALLINT,
- 2022-11-23 17:16:51 dp SMALLINT,
- 2022-11-23 17:16:51 pb SMALLINT,
- 2022-11-23 17:16:51 wp SMALLINT,
- 2022-11-23 17:16:51 sb SMALLINT,
- 2022-11-23 17:16:51 cs SMALLINT,
- 2022-11-23 17:16:51 zr FLOAT(53),
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, stint, pos)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.fielding_of (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 stint SMALLINT NOT NULL,
- 2022-11-23 17:16:51 g_lf SMALLINT,
- 2022-11-23 17:16:51 g_cf SMALLINT,
- 2022-11-23 17:16:51 g_rf SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, stint)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.fielding_of_split (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 stint SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3),
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 pos VARCHAR(2) NOT NULL,
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 gs SMALLINT,
- 2022-11-23 17:16:51 inn_outs SMALLINT,
- 2022-11-23 17:16:51 po SMALLINT,
- 2022-11-23 17:16:51 a SMALLINT,
- 2022-11-23 17:16:51 e SMALLINT,
- 2022-11-23 17:16:51 dp SMALLINT,
- 2022-11-23 17:16:51 pb SMALLINT,
- 2022-11-23 17:16:51 wp SMALLINT,
- 2022-11-23 17:16:51 sb SMALLINT,
- 2022-11-23 17:16:51 cs SMALLINT,
- 2022-11-23 17:16:51 zr FLOAT(53),
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, stint, pos)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.fielding_post (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3),
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 round VARCHAR(10) NOT NULL,
- 2022-11-23 17:16:51 pos VARCHAR(2) NOT NULL,
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 gs SMALLINT,
- 2022-11-23 17:16:51 inn_outs SMALLINT,
- 2022-11-23 17:16:51 po SMALLINT,
- 2022-11-23 17:16:51 a SMALLINT,
- 2022-11-23 17:16:51 e SMALLINT,
- 2022-11-23 17:16:51 dp SMALLINT,
- 2022-11-23 17:16:51 tp SMALLINT,
- 2022-11-23 17:16:51 pb SMALLINT,
- 2022-11-23 17:16:51 sb SMALLINT,
- 2022-11-23 17:16:51 cs SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, round, pos)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.hall_of_fame (
- 2022-11-23 17:16:51 player_id VARCHAR(10) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 voted_by VARCHAR(64) NOT NULL,
- 2022-11-23 17:16:51 ballots SMALLINT,
- 2022-11-23 17:16:51 needed SMALLINT,
- 2022-11-23 17:16:51 votes SMALLINT,
- 2022-11-23 17:16:51 inducted VARCHAR(1),
- 2022-11-23 17:16:51 category VARCHAR(20),
- 2022-11-23 17:16:51 needed_note VARCHAR(25),
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, voted_by)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.home_games (
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2) NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3) NOT NULL,
- 2022-11-23 17:16:51 park_id VARCHAR(5) NOT NULL,
- 2022-11-23 17:16:51 first_game DATE,
- 2022-11-23 17:16:51 last_game DATE,
- 2022-11-23 17:16:51 games SMALLINT,
- 2022-11-23 17:16:51 openings SMALLINT,
- 2022-11-23 17:16:51 attendance INTEGER,
- 2022-11-23 17:16:51 PRIMARY KEY (year_id, lg_id, team_id, park_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.managers (
- 2022-11-23 17:16:51 player_id VARCHAR(10),
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3) NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 inseason SMALLINT NOT NULL,
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 w SMALLINT,
- 2022-11-23 17:16:51 l SMALLINT,
- 2022-11-23 17:16:51 `rank` SMALLINT,
- 2022-11-23 17:16:51 plyr_mgr VARCHAR(1),
- 2022-11-23 17:16:51 PRIMARY KEY (year_id, team_id, inseason)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.managers_half (
- 2022-11-23 17:16:51 player_id VARCHAR(10) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3) NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 inseason SMALLINT,
- 2022-11-23 17:16:51 half SMALLINT NOT NULL,
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 w SMALLINT,
- 2022-11-23 17:16:51 l SMALLINT,
- 2022-11-23 17:16:51 `rank` SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, team_id, half)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.parks (
- 2022-11-23 17:16:51 park_id VARCHAR(5) NOT NULL,
- 2022-11-23 17:16:51 park_name VARCHAR(40),
- 2022-11-23 17:16:51 park_alias VARCHAR(55),
- 2022-11-23 17:16:51 city VARCHAR(25),
- 2022-11-23 17:16:51 state VARCHAR(16),
- 2022-11-23 17:16:51 country VARCHAR(2),
- 2022-11-23 17:16:51 PRIMARY KEY (park_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.people (
- 2022-11-23 17:16:51 player_id VARCHAR(10) NOT NULL,
- 2022-11-23 17:16:51 birth_year SMALLINT,
- 2022-11-23 17:16:51 birth_month SMALLINT,
- 2022-11-23 17:16:51 birth_day SMALLINT,
- 2022-11-23 17:16:51 birth_country VARCHAR(50),
- 2022-11-23 17:16:51 birth_state VARCHAR(50),
- 2022-11-23 17:16:51 birth_city VARCHAR(50),
- 2022-11-23 17:16:51 death_year SMALLINT,
- 2022-11-23 17:16:51 death_month SMALLINT,
- 2022-11-23 17:16:51 death_day SMALLINT,
- 2022-11-23 17:16:51 death_country VARCHAR(50),
- 2022-11-23 17:16:51 death_state VARCHAR(50),
- 2022-11-23 17:16:51 death_city VARCHAR(50),
- 2022-11-23 17:16:51 name_first VARCHAR(50),
- 2022-11-23 17:16:51 name_last VARCHAR(50),
- 2022-11-23 17:16:51 name_given VARCHAR(255),
- 2022-11-23 17:16:51 weight SMALLINT,
- 2022-11-23 17:16:51 height FLOAT(53),
- 2022-11-23 17:16:51 bats VARCHAR(1),
- 2022-11-23 17:16:51 throws VARCHAR(1),
- 2022-11-23 17:16:51 debut DATE,
- 2022-11-23 17:16:51 final_game DATE,
- 2022-11-23 17:16:51 retro_id VARCHAR(9),
- 2022-11-23 17:16:51 bbref_id VARCHAR(9),
- 2022-11-23 17:16:51 PRIMARY KEY (player_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.pitching (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 stint SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3),
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 w SMALLINT,
- 2022-11-23 17:16:51 l SMALLINT,
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 gs SMALLINT,
- 2022-11-23 17:16:51 cg SMALLINT,
- 2022-11-23 17:16:51 sho SMALLINT,
- 2022-11-23 17:16:51 sv SMALLINT,
- 2022-11-23 17:16:51 ip_outs SMALLINT,
- 2022-11-23 17:16:51 h SMALLINT,
- 2022-11-23 17:16:51 er SMALLINT,
- 2022-11-23 17:16:51 hr SMALLINT,
- 2022-11-23 17:16:51 bb SMALLINT,
- 2022-11-23 17:16:51 so SMALLINT,
- 2022-11-23 17:16:51 ba_opp FLOAT(53),
- 2022-11-23 17:16:51 era FLOAT(53),
- 2022-11-23 17:16:51 ibb SMALLINT,
- 2022-11-23 17:16:51 wp SMALLINT,
- 2022-11-23 17:16:51 hbp SMALLINT,
- 2022-11-23 17:16:51 bk SMALLINT,
- 2022-11-23 17:16:51 bfp SMALLINT,
- 2022-11-23 17:16:51 gf SMALLINT,
- 2022-11-23 17:16:51 r SMALLINT,
- 2022-11-23 17:16:51 sh SMALLINT,
- 2022-11-23 17:16:51 sf SMALLINT,
- 2022-11-23 17:16:51 gidp SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, stint)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.pitching_post (
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 round VARCHAR(10) NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3),
- 2022-11-23 17:16:51 lg_id VARCHAR(2),
- 2022-11-23 17:16:51 w SMALLINT,
- 2022-11-23 17:16:51 l SMALLINT,
- 2022-11-23 17:16:51 g SMALLINT,
- 2022-11-23 17:16:51 gs SMALLINT,
- 2022-11-23 17:16:51 cg SMALLINT,
- 2022-11-23 17:16:51 sho SMALLINT,
- 2022-11-23 17:16:51 sv SMALLINT,
- 2022-11-23 17:16:51 ip_outs SMALLINT,
- 2022-11-23 17:16:51 h SMALLINT,
- 2022-11-23 17:16:51 er SMALLINT,
- 2022-11-23 17:16:51 hr SMALLINT,
- 2022-11-23 17:16:51 bb SMALLINT,
- 2022-11-23 17:16:51 so SMALLINT,
- 2022-11-23 17:16:51 ba_opp FLOAT(53),
- 2022-11-23 17:16:51 era FLOAT(53),
- 2022-11-23 17:16:51 ibb SMALLINT,
- 2022-11-23 17:16:51 wp SMALLINT,
- 2022-11-23 17:16:51 hbp SMALLINT,
- 2022-11-23 17:16:51 bk SMALLINT,
- 2022-11-23 17:16:51 bfp SMALLINT,
- 2022-11-23 17:16:51 gf SMALLINT,
- 2022-11-23 17:16:51 r SMALLINT,
- 2022-11-23 17:16:51 sh SMALLINT,
- 2022-11-23 17:16:51 sf SMALLINT,
- 2022-11-23 17:16:51 gidp SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (player_id, year_id, round)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.salaries (
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3) NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2) NOT NULL,
- 2022-11-23 17:16:51 player_id VARCHAR(9) NOT NULL,
- 2022-11-23 17:16:51 salary FLOAT(53),
- 2022-11-23 17:16:51 PRIMARY KEY (year_id, team_id, lg_id, player_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.schools (
- 2022-11-23 17:16:51 school_id VARCHAR(15) NOT NULL,
- 2022-11-23 17:16:51 name_full VARCHAR(255),
- 2022-11-23 17:16:51 city VARCHAR(55),
- 2022-11-23 17:16:51 state VARCHAR(55),
- 2022-11-23 17:16:51 country VARCHAR(55),
- 2022-11-23 17:16:51 PRIMARY KEY (school_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.series_post (
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 round VARCHAR(5) NOT NULL,
- 2022-11-23 17:16:51 team_id_winner VARCHAR(3),
- 2022-11-23 17:16:51 lg_id_winner VARCHAR(2),
- 2022-11-23 17:16:51 team_id_loser VARCHAR(3),
- 2022-11-23 17:16:51 lg_id_loser VARCHAR(2),
- 2022-11-23 17:16:51 wins SMALLINT,
- 2022-11-23 17:16:51 losses SMALLINT,
- 2022-11-23 17:16:51 ties SMALLINT,
- 2022-11-23 17:16:51 PRIMARY KEY (year_id, round)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.teams (
- 2022-11-23 17:16:51 year_id SMALLINT NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2) NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3) NOT NULL,
- 2022-11-23 17:16:51 franch_id VARCHAR(3),
- 2022-11-23 17:16:51 div_id VARCHAR(1),
- 2022-11-23 17:16:51 `rank` INTEGER,
- 2022-11-23 17:16:51 g INTEGER,
- 2022-11-23 17:16:51 g_home INTEGER,
- 2022-11-23 17:16:51 w INTEGER,
- 2022-11-23 17:16:51 l INTEGER,
- 2022-11-23 17:16:51 div_win VARCHAR(1),
- 2022-11-23 17:16:51 wc_win VARCHAR(1),
- 2022-11-23 17:16:51 lg_win VARCHAR(1),
- 2022-11-23 17:16:51 ws_win VARCHAR(1),
- 2022-11-23 17:16:51 r INTEGER,
- 2022-11-23 17:16:51 ab INTEGER,
- 2022-11-23 17:16:51 h INTEGER,
- 2022-11-23 17:16:51 _2b INTEGER,
- 2022-11-23 17:16:51 _3b INTEGER,
- 2022-11-23 17:16:51 hr INTEGER,
- 2022-11-23 17:16:51 bb INTEGER,
- 2022-11-23 17:16:51 so INTEGER,
- 2022-11-23 17:16:51 sb INTEGER,
- 2022-11-23 17:16:51 cs INTEGER,
- 2022-11-23 17:16:51 hbp INTEGER,
- 2022-11-23 17:16:51 sf INTEGER,
- 2022-11-23 17:16:51 ra INTEGER,
- 2022-11-23 17:16:51 er INTEGER,
- 2022-11-23 17:16:51 era FLOAT(53),
- 2022-11-23 17:16:51 cg INTEGER,
- 2022-11-23 17:16:51 sho INTEGER,
- 2022-11-23 17:16:51 sv INTEGER,
- 2022-11-23 17:16:51 ip_outs INTEGER,
- 2022-11-23 17:16:51 h_a INTEGER,
- 2022-11-23 17:16:51 hr_a INTEGER,
- 2022-11-23 17:16:51 bb_a INTEGER,
- 2022-11-23 17:16:51 so_a INTEGER,
- 2022-11-23 17:16:51 e INTEGER,
- 2022-11-23 17:16:51 dp INTEGER,
- 2022-11-23 17:16:51 fp FLOAT(53),
- 2022-11-23 17:16:51 name VARCHAR(50),
- 2022-11-23 17:16:51 park VARCHAR(255),
- 2022-11-23 17:16:51 attendance INTEGER,
- 2022-11-23 17:16:51 bpf INTEGER,
- 2022-11-23 17:16:51 ppf INTEGER,
- 2022-11-23 17:16:51 team_id_br VARCHAR(3),
- 2022-11-23 17:16:51 team_id_lahman45 VARCHAR(3),
- 2022-11-23 17:16:51 team_id_retro VARCHAR(3),
- 2022-11-23 17:16:51 PRIMARY KEY (year_id, lg_id, team_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.teams_franchises (
- 2022-11-23 17:16:51 franch_id VARCHAR(3) NOT NULL,
- 2022-11-23 17:16:51 franch_name VARCHAR(50),
- 2022-11-23 17:16:51 active VARCHAR(2),
- 2022-11-23 17:16:51 na_assoc VARCHAR(3),
- 2022-11-23 17:16:51 PRIMARY KEY (franch_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE baseballdatabank.teams_half (
- 2022-11-23 17:16:51 year_id INTEGER NOT NULL,
- 2022-11-23 17:16:51 lg_id VARCHAR(2) NOT NULL,
- 2022-11-23 17:16:51 team_id VARCHAR(3) NOT NULL,
- 2022-11-23 17:16:51 half VARCHAR(1) NOT NULL,
- 2022-11-23 17:16:51 div_id VARCHAR(1),
- 2022-11-23 17:16:51 div_win VARCHAR(1),
- 2022-11-23 17:16:51 `rank` INTEGER,
- 2022-11-23 17:16:51 g INTEGER,
- 2022-11-23 17:16:51 w INTEGER,
- 2022-11-23 17:16:51 l INTEGER,
- 2022-11-23 17:16:51 PRIMARY KEY (year_id, lg_id, team_id, half)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/allstar_full.csv' INTO TABLE baseballdatabank.allstar_full
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @game_num, @game_id, @team_id, @lg_id, @gp, @starting_pos, @dummy_id)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `game_num` = IF(@game_num = '', NULL, @game_num),
- 2022-11-23 17:16:51 `game_id` = IF(@game_id = '', NULL, @game_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `gp` = IF(@gp = '', NULL, @gp),
- 2022-11-23 17:16:51 `starting_pos` = IF(@starting_pos = '', NULL, @starting_pos),
- 2022-11-23 17:16:51 `dummy_id` = IF(@dummy_id = '', NULL, @dummy_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/appearances.csv' INTO TABLE baseballdatabank.appearances
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@year_id, @team_id, @lg_id, @player_id, @g_all, @gs, @g_batting, @g_defense, @g_p, @g_c, @g_1b, @g_2b, @g_3b, @g_ss, @g_lf, @g_cf, @g_rf, @g_of, @g_dh, @g_ph, @g_pr)
- 2022-11-23 17:16:51 SET `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `g_all` = IF(@g_all = '', NULL, @g_all),
- 2022-11-23 17:16:51 `gs` = IF(@gs = '', NULL, @gs),
- 2022-11-23 17:16:51 `g_batting` = IF(@g_batting = '', NULL, @g_batting),
- 2022-11-23 17:16:51 `g_defense` = IF(@g_defense = '', NULL, @g_defense),
- 2022-11-23 17:16:51 `g_p` = IF(@g_p = '', NULL, @g_p),
- 2022-11-23 17:16:51 `g_c` = IF(@g_c = '', NULL, @g_c),
- 2022-11-23 17:16:51 `g_1b` = IF(@g_1b = '', NULL, @g_1b),
- 2022-11-23 17:16:51 `g_2b` = IF(@g_2b = '', NULL, @g_2b),
- 2022-11-23 17:16:51 `g_3b` = IF(@g_3b = '', NULL, @g_3b),
- 2022-11-23 17:16:51 `g_ss` = IF(@g_ss = '', NULL, @g_ss),
- 2022-11-23 17:16:51 `g_lf` = IF(@g_lf = '', NULL, @g_lf),
- 2022-11-23 17:16:51 `g_cf` = IF(@g_cf = '', NULL, @g_cf),
- 2022-11-23 17:16:51 `g_rf` = IF(@g_rf = '', NULL, @g_rf),
- 2022-11-23 17:16:51 `g_of` = IF(@g_of = '', NULL, @g_of),
- 2022-11-23 17:16:51 `g_dh` = IF(@g_dh = '', NULL, @g_dh),
- 2022-11-23 17:16:51 `g_ph` = IF(@g_ph = '', NULL, @g_ph),
- 2022-11-23 17:16:51 `g_pr` = IF(@g_pr = '', NULL, @g_pr);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/awards_managers.csv' INTO TABLE baseballdatabank.awards_managers
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @award_id, @year_id, @lg_id, @tie, @notes, @dummy_id)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `award_id` = IF(@award_id = '', NULL, @award_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `tie` = IF(@tie = '', NULL, @tie),
- 2022-11-23 17:16:51 `notes` = IF(@notes = '', NULL, @notes),
- 2022-11-23 17:16:51 `dummy_id` = IF(@dummy_id = '', NULL, @dummy_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/awards_players.csv' INTO TABLE baseballdatabank.awards_players
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @award_id, @year_id, @lg_id, @tie, @notes, @dummy_id)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `award_id` = IF(@award_id = '', NULL, @award_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `tie` = IF(@tie = '', NULL, @tie),
- 2022-11-23 17:16:51 `notes` = IF(@notes = '', NULL, @notes),
- 2022-11-23 17:16:51 `dummy_id` = IF(@dummy_id = '', NULL, @dummy_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/awards_share_managers.csv' INTO TABLE baseballdatabank.awards_share_managers
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@award_id, @year_id, @lg_id, @player_id, @points_won, @points_max, @votes_first)
- 2022-11-23 17:16:51 SET `award_id` = IF(@award_id = '', NULL, @award_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `points_won` = IF(@points_won = '', NULL, @points_won),
- 2022-11-23 17:16:51 `points_max` = IF(@points_max = '', NULL, @points_max),
- 2022-11-23 17:16:51 `votes_first` = IF(@votes_first = '', NULL, @votes_first);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/awards_share_players.csv' INTO TABLE baseballdatabank.awards_share_players
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@award_id, @year_id, @lg_id, @player_id, @points_won, @points_max, @votes_first)
- 2022-11-23 17:16:51 SET `points_won` = IF(@points_won IN ('', 'inf'), NULL, @points_won),
- 2022-11-23 17:16:51 `votes_first` = IF(@votes_first IN ('', 'inf'), NULL, @votes_first),
- 2022-11-23 17:16:51 `award_id` = IF(@award_id = '', NULL, @award_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `points_max` = IF(@points_max = '', NULL, @points_max);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/batting.csv' INTO TABLE baseballdatabank.batting
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @stint, @team_id, @lg_id, @g, @ab, @r, @h, @_2b, @_3b, @hr, @rbi, @sb, @cs, @bb, @so, @ibb, @hbp, @sh, @sf, @gidp)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `stint` = IF(@stint = '', NULL, @stint),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `ab` = IF(@ab = '', NULL, @ab),
- 2022-11-23 17:16:51 `r` = IF(@r = '', NULL, @r),
- 2022-11-23 17:16:51 `h` = IF(@h = '', NULL, @h),
- 2022-11-23 17:16:51 `_2b` = IF(@_2b = '', NULL, @_2b),
- 2022-11-23 17:16:51 `_3b` = IF(@_3b = '', NULL, @_3b),
- 2022-11-23 17:16:51 `hr` = IF(@hr = '', NULL, @hr),
- 2022-11-23 17:16:51 `rbi` = IF(@rbi = '', NULL, @rbi),
- 2022-11-23 17:16:51 `sb` = IF(@sb = '', NULL, @sb),
- 2022-11-23 17:16:51 `cs` = IF(@cs = '', NULL, @cs),
- 2022-11-23 17:16:51 `bb` = IF(@bb = '', NULL, @bb),
- 2022-11-23 17:16:51 `so` = IF(@so = '', NULL, @so),
- 2022-11-23 17:16:51 `ibb` = IF(@ibb = '', NULL, @ibb),
- 2022-11-23 17:16:51 `hbp` = IF(@hbp = '', NULL, @hbp),
- 2022-11-23 17:16:51 `sh` = IF(@sh = '', NULL, @sh),
- 2022-11-23 17:16:51 `sf` = IF(@sf = '', NULL, @sf),
- 2022-11-23 17:16:51 `gidp` = IF(@gidp = '', NULL, @gidp);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/batting_post.csv' INTO TABLE baseballdatabank.batting_post
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@year_id, @round, @player_id, @team_id, @lg_id, @g, @ab, @r, @h, @_2b, @_3b, @hr, @rbi, @sb, @cs, @bb, @so, @ibb, @hbp, @sh, @sf, @gidp)
- 2022-11-23 17:16:51 SET `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `round` = IF(@round = '', NULL, @round),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `ab` = IF(@ab = '', NULL, @ab),
- 2022-11-23 17:16:51 `r` = IF(@r = '', NULL, @r),
- 2022-11-23 17:16:51 `h` = IF(@h = '', NULL, @h),
- 2022-11-23 17:16:51 `_2b` = IF(@_2b = '', NULL, @_2b),
- 2022-11-23 17:16:51 `_3b` = IF(@_3b = '', NULL, @_3b),
- 2022-11-23 17:16:51 `hr` = IF(@hr = '', NULL, @hr),
- 2022-11-23 17:16:51 `rbi` = IF(@rbi = '', NULL, @rbi),
- 2022-11-23 17:16:51 `sb` = IF(@sb = '', NULL, @sb),
- 2022-11-23 17:16:51 `cs` = IF(@cs = '', NULL, @cs),
- 2022-11-23 17:16:51 `bb` = IF(@bb = '', NULL, @bb),
- 2022-11-23 17:16:51 `so` = IF(@so = '', NULL, @so),
- 2022-11-23 17:16:51 `ibb` = IF(@ibb = '', NULL, @ibb),
- 2022-11-23 17:16:51 `hbp` = IF(@hbp = '', NULL, @hbp),
- 2022-11-23 17:16:51 `sh` = IF(@sh = '', NULL, @sh),
- 2022-11-23 17:16:51 `sf` = IF(@sf = '', NULL, @sf),
- 2022-11-23 17:16:51 `gidp` = IF(@gidp = '', NULL, @gidp);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/college_playing.csv' INTO TABLE baseballdatabank.college_playing
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @school_id, @year_id)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `school_id` = IF(@school_id = '', NULL, @school_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/fielding.csv' INTO TABLE baseballdatabank.fielding
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @stint, @team_id, @lg_id, @pos, @g, @gs, @inn_outs, @po, @a, @e, @dp, @pb, @wp, @sb, @cs, @zr)
- 2022-11-23 17:16:51 SET `zr` = IF(@zr IN ('', 'inf'), NULL, @zr),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `stint` = IF(@stint = '', NULL, @stint),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `pos` = IF(@pos = '', NULL, @pos),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `gs` = IF(@gs = '', NULL, @gs),
- 2022-11-23 17:16:51 `inn_outs` = IF(@inn_outs = '', NULL, @inn_outs),
- 2022-11-23 17:16:51 `po` = IF(@po = '', NULL, @po),
- 2022-11-23 17:16:51 `a` = IF(@a = '', NULL, @a),
- 2022-11-23 17:16:51 `e` = IF(@e = '', NULL, @e),
- 2022-11-23 17:16:51 `dp` = IF(@dp = '', NULL, @dp),
- 2022-11-23 17:16:51 `pb` = IF(@pb = '', NULL, @pb),
- 2022-11-23 17:16:51 `wp` = IF(@wp = '', NULL, @wp),
- 2022-11-23 17:16:51 `sb` = IF(@sb = '', NULL, @sb),
- 2022-11-23 17:16:51 `cs` = IF(@cs = '', NULL, @cs);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/fielding_of.csv' INTO TABLE baseballdatabank.fielding_of
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @stint, @g_lf, @g_cf, @g_rf)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `stint` = IF(@stint = '', NULL, @stint),
- 2022-11-23 17:16:51 `g_lf` = IF(@g_lf = '', NULL, @g_lf),
- 2022-11-23 17:16:51 `g_cf` = IF(@g_cf = '', NULL, @g_cf),
- 2022-11-23 17:16:51 `g_rf` = IF(@g_rf = '', NULL, @g_rf);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/fielding_of_split.csv' INTO TABLE baseballdatabank.fielding_of_split
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @stint, @team_id, @lg_id, @pos, @g, @gs, @inn_outs, @po, @a, @e, @dp, @pb, @wp, @sb, @cs, @zr)
- 2022-11-23 17:16:51 SET `zr` = IF(@zr IN ('', 'inf'), NULL, @zr),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `stint` = IF(@stint = '', NULL, @stint),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `pos` = IF(@pos = '', NULL, @pos),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `gs` = IF(@gs = '', NULL, @gs),
- 2022-11-23 17:16:51 `inn_outs` = IF(@inn_outs = '', NULL, @inn_outs),
- 2022-11-23 17:16:51 `po` = IF(@po = '', NULL, @po),
- 2022-11-23 17:16:51 `a` = IF(@a = '', NULL, @a),
- 2022-11-23 17:16:51 `e` = IF(@e = '', NULL, @e),
- 2022-11-23 17:16:51 `dp` = IF(@dp = '', NULL, @dp),
- 2022-11-23 17:16:51 `pb` = IF(@pb = '', NULL, @pb),
- 2022-11-23 17:16:51 `wp` = IF(@wp = '', NULL, @wp),
- 2022-11-23 17:16:51 `sb` = IF(@sb = '', NULL, @sb),
- 2022-11-23 17:16:51 `cs` = IF(@cs = '', NULL, @cs);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/fielding_post.csv' INTO TABLE baseballdatabank.fielding_post
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @team_id, @lg_id, @round, @pos, @g, @gs, @inn_outs, @po, @a, @e, @dp, @tp, @pb, @sb, @cs)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `round` = IF(@round = '', NULL, @round),
- 2022-11-23 17:16:51 `pos` = IF(@pos = '', NULL, @pos),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `gs` = IF(@gs = '', NULL, @gs),
- 2022-11-23 17:16:51 `inn_outs` = IF(@inn_outs = '', NULL, @inn_outs),
- 2022-11-23 17:16:51 `po` = IF(@po = '', NULL, @po),
- 2022-11-23 17:16:51 `a` = IF(@a = '', NULL, @a),
- 2022-11-23 17:16:51 `e` = IF(@e = '', NULL, @e),
- 2022-11-23 17:16:51 `dp` = IF(@dp = '', NULL, @dp),
- 2022-11-23 17:16:51 `tp` = IF(@tp = '', NULL, @tp),
- 2022-11-23 17:16:51 `pb` = IF(@pb = '', NULL, @pb),
- 2022-11-23 17:16:51 `sb` = IF(@sb = '', NULL, @sb),
- 2022-11-23 17:16:51 `cs` = IF(@cs = '', NULL, @cs);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/hall_of_fame.csv' INTO TABLE baseballdatabank.hall_of_fame
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @voted_by, @ballots, @needed, @votes, @inducted, @category, @needed_note)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `voted_by` = IF(@voted_by = '', NULL, @voted_by),
- 2022-11-23 17:16:51 `ballots` = IF(@ballots = '', NULL, @ballots),
- 2022-11-23 17:16:51 `needed` = IF(@needed = '', NULL, @needed),
- 2022-11-23 17:16:51 `votes` = IF(@votes = '', NULL, @votes),
- 2022-11-23 17:16:51 `inducted` = IF(@inducted = '', NULL, @inducted),
- 2022-11-23 17:16:51 `category` = IF(@category = '', NULL, @category),
- 2022-11-23 17:16:51 `needed_note` = IF(@needed_note = '', NULL, @needed_note);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/home_games.csv' INTO TABLE baseballdatabank.home_games
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@year_id, @lg_id, @team_id, @park_id, @first_game, @last_game, @games, @openings, @attendance)
- 2022-11-23 17:16:51 SET `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `park_id` = IF(@park_id = '', NULL, @park_id),
- 2022-11-23 17:16:51 `first_game` = IF(@first_game = '', NULL, @first_game),
- 2022-11-23 17:16:51 `last_game` = IF(@last_game = '', NULL, @last_game),
- 2022-11-23 17:16:51 `games` = IF(@games = '', NULL, @games),
- 2022-11-23 17:16:51 `openings` = IF(@openings = '', NULL, @openings),
- 2022-11-23 17:16:51 `attendance` = IF(@attendance = '', NULL, @attendance);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/managers.csv' INTO TABLE baseballdatabank.managers
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @team_id, @lg_id, @inseason, @g, @w, @l, @rank, @plyr_mgr)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `inseason` = IF(@inseason = '', NULL, @inseason),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `w` = IF(@w = '', NULL, @w),
- 2022-11-23 17:16:51 `l` = IF(@l = '', NULL, @l),
- 2022-11-23 17:16:51 `rank` = IF(@rank = '', NULL, @rank),
- 2022-11-23 17:16:51 `plyr_mgr` = IF(@plyr_mgr = '', NULL, @plyr_mgr);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/managers_half.csv' INTO TABLE baseballdatabank.managers_half
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @team_id, @lg_id, @inseason, @half, @g, @w, @l, @rank)
- 2022-11-23 17:16:51 SET `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `inseason` = IF(@inseason = '', NULL, @inseason),
- 2022-11-23 17:16:51 `half` = IF(@half = '', NULL, @half),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `w` = IF(@w = '', NULL, @w),
- 2022-11-23 17:16:51 `l` = IF(@l = '', NULL, @l),
- 2022-11-23 17:16:51 `rank` = IF(@rank = '', NULL, @rank);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/parks.csv' INTO TABLE baseballdatabank.parks
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@park_id, @park_name, @park_alias, @city, @state, @country)
- 2022-11-23 17:16:51 SET `park_id` = IF(@park_id = '', NULL, @park_id),
- 2022-11-23 17:16:51 `park_name` = IF(@park_name = '', NULL, @park_name),
- 2022-11-23 17:16:51 `park_alias` = IF(@park_alias = '', NULL, @park_alias),
- 2022-11-23 17:16:51 `city` = IF(@city = '', NULL, @city),
- 2022-11-23 17:16:51 `state` = IF(@state = '', NULL, @state),
- 2022-11-23 17:16:51 `country` = IF(@country = '', NULL, @country);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/people.csv' INTO TABLE baseballdatabank.people
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @birth_year, @birth_month, @birth_day, @birth_country, @birth_state, @birth_city, @death_year, @death_month, @death_day, @death_country, @death_state, @death_city, @name_first, @name_last, @name_given, @weight, @height, @bats, @throws, @debut, @final_game, @retro_id, @bbref_id)
- 2022-11-23 17:16:51 SET `height` = IF(@height IN ('', 'inf'), NULL, @height),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `birth_year` = IF(@birth_year = '', NULL, @birth_year),
- 2022-11-23 17:16:51 `birth_month` = IF(@birth_month = '', NULL, @birth_month),
- 2022-11-23 17:16:51 `birth_day` = IF(@birth_day = '', NULL, @birth_day),
- 2022-11-23 17:16:51 `birth_country` = IF(@birth_country = '', NULL, @birth_country),
- 2022-11-23 17:16:51 `birth_state` = IF(@birth_state = '', NULL, @birth_state),
- 2022-11-23 17:16:51 `birth_city` = IF(@birth_city = '', NULL, @birth_city),
- 2022-11-23 17:16:51 `death_year` = IF(@death_year = '', NULL, @death_year),
- 2022-11-23 17:16:51 `death_month` = IF(@death_month = '', NULL, @death_month),
- 2022-11-23 17:16:51 `death_day` = IF(@death_day = '', NULL, @death_day),
- 2022-11-23 17:16:51 `death_country` = IF(@death_country = '', NULL, @death_country),
- 2022-11-23 17:16:51 `death_state` = IF(@death_state = '', NULL, @death_state),
- 2022-11-23 17:16:51 `death_city` = IF(@death_city = '', NULL, @death_city),
- 2022-11-23 17:16:51 `name_first` = IF(@name_first = '', NULL, @name_first),
- 2022-11-23 17:16:51 `name_last` = IF(@name_last = '', NULL, @name_last),
- 2022-11-23 17:16:51 `name_given` = IF(@name_given = '', NULL, @name_given),
- 2022-11-23 17:16:51 `weight` = IF(@weight = '', NULL, @weight),
- 2022-11-23 17:16:51 `bats` = IF(@bats = '', NULL, @bats),
- 2022-11-23 17:16:51 `throws` = IF(@throws = '', NULL, @throws),
- 2022-11-23 17:16:51 `debut` = IF(@debut = '', NULL, @debut),
- 2022-11-23 17:16:51 `final_game` = IF(@final_game = '', NULL, @final_game),
- 2022-11-23 17:16:51 `retro_id` = IF(@retro_id = '', NULL, @retro_id),
- 2022-11-23 17:16:51 `bbref_id` = IF(@bbref_id = '', NULL, @bbref_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/pitching.csv' INTO TABLE baseballdatabank.pitching
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @stint, @team_id, @lg_id, @w, @l, @g, @gs, @cg, @sho, @sv, @ip_outs, @h, @er, @hr, @bb, @so, @ba_opp, @era, @ibb, @wp, @hbp, @bk, @bfp, @gf, @r, @sh, @sf, @gidp)
- 2022-11-23 17:16:51 SET `ba_opp` = IF(@ba_opp IN ('', 'inf'), NULL, @ba_opp),
- 2022-11-23 17:16:51 `era` = IF(@era IN ('', 'inf'), NULL, @era),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `stint` = IF(@stint = '', NULL, @stint),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `w` = IF(@w = '', NULL, @w),
- 2022-11-23 17:16:51 `l` = IF(@l = '', NULL, @l),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `gs` = IF(@gs = '', NULL, @gs),
- 2022-11-23 17:16:51 `cg` = IF(@cg = '', NULL, @cg),
- 2022-11-23 17:16:51 `sho` = IF(@sho = '', NULL, @sho),
- 2022-11-23 17:16:51 `sv` = IF(@sv = '', NULL, @sv),
- 2022-11-23 17:16:51 `ip_outs` = IF(@ip_outs = '', NULL, @ip_outs),
- 2022-11-23 17:16:51 `h` = IF(@h = '', NULL, @h),
- 2022-11-23 17:16:51 `er` = IF(@er = '', NULL, @er),
- 2022-11-23 17:16:51 `hr` = IF(@hr = '', NULL, @hr),
- 2022-11-23 17:16:51 `bb` = IF(@bb = '', NULL, @bb),
- 2022-11-23 17:16:51 `so` = IF(@so = '', NULL, @so),
- 2022-11-23 17:16:51 `ibb` = IF(@ibb = '', NULL, @ibb),
- 2022-11-23 17:16:51 `wp` = IF(@wp = '', NULL, @wp),
- 2022-11-23 17:16:51 `hbp` = IF(@hbp = '', NULL, @hbp),
- 2022-11-23 17:16:51 `bk` = IF(@bk = '', NULL, @bk),
- 2022-11-23 17:16:51 `bfp` = IF(@bfp = '', NULL, @bfp),
- 2022-11-23 17:16:51 `gf` = IF(@gf = '', NULL, @gf),
- 2022-11-23 17:16:51 `r` = IF(@r = '', NULL, @r),
- 2022-11-23 17:16:51 `sh` = IF(@sh = '', NULL, @sh),
- 2022-11-23 17:16:51 `sf` = IF(@sf = '', NULL, @sf),
- 2022-11-23 17:16:51 `gidp` = IF(@gidp = '', NULL, @gidp);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/pitching_post.csv' INTO TABLE baseballdatabank.pitching_post
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@player_id, @year_id, @round, @team_id, @lg_id, @w, @l, @g, @gs, @cg, @sho, @sv, @ip_outs, @h, @er, @hr, @bb, @so, @ba_opp, @era, @ibb, @wp, @hbp, @bk, @bfp, @gf, @r, @sh, @sf, @gidp)
- 2022-11-23 17:16:51 SET `ba_opp` = IF(@ba_opp IN ('', 'inf'), NULL, @ba_opp),
- 2022-11-23 17:16:51 `era` = IF(@era IN ('', 'inf'), NULL, @era),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `round` = IF(@round = '', NULL, @round),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `w` = IF(@w = '', NULL, @w),
- 2022-11-23 17:16:51 `l` = IF(@l = '', NULL, @l),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `gs` = IF(@gs = '', NULL, @gs),
- 2022-11-23 17:16:51 `cg` = IF(@cg = '', NULL, @cg),
- 2022-11-23 17:16:51 `sho` = IF(@sho = '', NULL, @sho),
- 2022-11-23 17:16:51 `sv` = IF(@sv = '', NULL, @sv),
- 2022-11-23 17:16:51 `ip_outs` = IF(@ip_outs = '', NULL, @ip_outs),
- 2022-11-23 17:16:51 `h` = IF(@h = '', NULL, @h),
- 2022-11-23 17:16:51 `er` = IF(@er = '', NULL, @er),
- 2022-11-23 17:16:51 `hr` = IF(@hr = '', NULL, @hr),
- 2022-11-23 17:16:51 `bb` = IF(@bb = '', NULL, @bb),
- 2022-11-23 17:16:51 `so` = IF(@so = '', NULL, @so),
- 2022-11-23 17:16:51 `ibb` = IF(@ibb = '', NULL, @ibb),
- 2022-11-23 17:16:51 `wp` = IF(@wp = '', NULL, @wp),
- 2022-11-23 17:16:51 `hbp` = IF(@hbp = '', NULL, @hbp),
- 2022-11-23 17:16:51 `bk` = IF(@bk = '', NULL, @bk),
- 2022-11-23 17:16:51 `bfp` = IF(@bfp = '', NULL, @bfp),
- 2022-11-23 17:16:51 `gf` = IF(@gf = '', NULL, @gf),
- 2022-11-23 17:16:51 `r` = IF(@r = '', NULL, @r),
- 2022-11-23 17:16:51 `sh` = IF(@sh = '', NULL, @sh),
- 2022-11-23 17:16:51 `sf` = IF(@sf = '', NULL, @sf),
- 2022-11-23 17:16:51 `gidp` = IF(@gidp = '', NULL, @gidp);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/salaries.csv' INTO TABLE baseballdatabank.salaries
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@year_id, @team_id, @lg_id, @player_id, @salary)
- 2022-11-23 17:16:51 SET `salary` = IF(@salary IN ('', 'inf'), NULL, @salary),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/schools.csv' INTO TABLE baseballdatabank.schools
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@school_id, @name_full, @city, @state, @country)
- 2022-11-23 17:16:51 SET `school_id` = IF(@school_id = '', NULL, @school_id),
- 2022-11-23 17:16:51 `name_full` = IF(@name_full = '', NULL, @name_full),
- 2022-11-23 17:16:51 `city` = IF(@city = '', NULL, @city),
- 2022-11-23 17:16:51 `state` = IF(@state = '', NULL, @state),
- 2022-11-23 17:16:51 `country` = IF(@country = '', NULL, @country);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/series_post.csv' INTO TABLE baseballdatabank.series_post
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@year_id, @round, @team_id_winner, @lg_id_winner, @team_id_loser, @lg_id_loser, @wins, @losses, @ties)
- 2022-11-23 17:16:51 SET `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `round` = IF(@round = '', NULL, @round),
- 2022-11-23 17:16:51 `team_id_winner` = IF(@team_id_winner = '', NULL, @team_id_winner),
- 2022-11-23 17:16:51 `lg_id_winner` = IF(@lg_id_winner = '', NULL, @lg_id_winner),
- 2022-11-23 17:16:51 `team_id_loser` = IF(@team_id_loser = '', NULL, @team_id_loser),
- 2022-11-23 17:16:51 `lg_id_loser` = IF(@lg_id_loser = '', NULL, @lg_id_loser),
- 2022-11-23 17:16:51 `wins` = IF(@wins = '', NULL, @wins),
- 2022-11-23 17:16:51 `losses` = IF(@losses = '', NULL, @losses),
- 2022-11-23 17:16:51 `ties` = IF(@ties = '', NULL, @ties);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/teams.csv' INTO TABLE baseballdatabank.teams
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@year_id, @lg_id, @team_id, @franch_id, @div_id, @rank, @g, @g_home, @w, @l, @div_win, @wc_win, @lg_win, @ws_win, @r, @ab, @h, @_2b, @_3b, @hr, @bb, @so, @sb, @cs, @hbp, @sf, @ra, @er, @era, @cg, @sho, @sv, @ip_outs, @h_a, @hr_a, @bb_a, @so_a, @e, @dp, @fp, @name, @park, @attendance, @bpf, @ppf, @team_id_br, @team_id_lahman45, @team_id_retro)
- 2022-11-23 17:16:51 SET `era` = IF(@era IN ('', 'inf'), NULL, @era),
- 2022-11-23 17:16:51 `fp` = IF(@fp IN ('', 'inf'), NULL, @fp),
- 2022-11-23 17:16:51 `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `franch_id` = IF(@franch_id = '', NULL, @franch_id),
- 2022-11-23 17:16:51 `div_id` = IF(@div_id = '', NULL, @div_id),
- 2022-11-23 17:16:51 `rank` = IF(@rank = '', NULL, @rank),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `g_home` = IF(@g_home = '', NULL, @g_home),
- 2022-11-23 17:16:51 `w` = IF(@w = '', NULL, @w),
- 2022-11-23 17:16:51 `l` = IF(@l = '', NULL, @l),
- 2022-11-23 17:16:51 `div_win` = IF(@div_win = '', NULL, @div_win),
- 2022-11-23 17:16:51 `wc_win` = IF(@wc_win = '', NULL, @wc_win),
- 2022-11-23 17:16:51 `lg_win` = IF(@lg_win = '', NULL, @lg_win),
- 2022-11-23 17:16:51 `ws_win` = IF(@ws_win = '', NULL, @ws_win),
- 2022-11-23 17:16:51 `r` = IF(@r = '', NULL, @r),
- 2022-11-23 17:16:51 `ab` = IF(@ab = '', NULL, @ab),
- 2022-11-23 17:16:51 `h` = IF(@h = '', NULL, @h),
- 2022-11-23 17:16:51 `_2b` = IF(@_2b = '', NULL, @_2b),
- 2022-11-23 17:16:51 `_3b` = IF(@_3b = '', NULL, @_3b),
- 2022-11-23 17:16:51 `hr` = IF(@hr = '', NULL, @hr),
- 2022-11-23 17:16:51 `bb` = IF(@bb = '', NULL, @bb),
- 2022-11-23 17:16:51 `so` = IF(@so = '', NULL, @so),
- 2022-11-23 17:16:51 `sb` = IF(@sb = '', NULL, @sb),
- 2022-11-23 17:16:51 `cs` = IF(@cs = '', NULL, @cs),
- 2022-11-23 17:16:51 `hbp` = IF(@hbp = '', NULL, @hbp),
- 2022-11-23 17:16:51 `sf` = IF(@sf = '', NULL, @sf),
- 2022-11-23 17:16:51 `ra` = IF(@ra = '', NULL, @ra),
- 2022-11-23 17:16:51 `er` = IF(@er = '', NULL, @er),
- 2022-11-23 17:16:51 `cg` = IF(@cg = '', NULL, @cg),
- 2022-11-23 17:16:51 `sho` = IF(@sho = '', NULL, @sho),
- 2022-11-23 17:16:51 `sv` = IF(@sv = '', NULL, @sv),
- 2022-11-23 17:16:51 `ip_outs` = IF(@ip_outs = '', NULL, @ip_outs),
- 2022-11-23 17:16:51 `h_a` = IF(@h_a = '', NULL, @h_a),
- 2022-11-23 17:16:51 `hr_a` = IF(@hr_a = '', NULL, @hr_a),
- 2022-11-23 17:16:51 `bb_a` = IF(@bb_a = '', NULL, @bb_a),
- 2022-11-23 17:16:51 `so_a` = IF(@so_a = '', NULL, @so_a),
- 2022-11-23 17:16:51 `e` = IF(@e = '', NULL, @e),
- 2022-11-23 17:16:51 `dp` = IF(@dp = '', NULL, @dp),
- 2022-11-23 17:16:51 `name` = IF(@name = '', NULL, @name),
- 2022-11-23 17:16:51 `park` = IF(@park = '', NULL, @park),
- 2022-11-23 17:16:51 `attendance` = IF(@attendance = '', NULL, @attendance),
- 2022-11-23 17:16:51 `bpf` = IF(@bpf = '', NULL, @bpf),
- 2022-11-23 17:16:51 `ppf` = IF(@ppf = '', NULL, @ppf),
- 2022-11-23 17:16:51 `team_id_br` = IF(@team_id_br = '', NULL, @team_id_br),
- 2022-11-23 17:16:51 `team_id_lahman45` = IF(@team_id_lahman45 = '', NULL, @team_id_lahman45),
- 2022-11-23 17:16:51 `team_id_retro` = IF(@team_id_retro = '', NULL, @team_id_retro);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/teams_franchises.csv' INTO TABLE baseballdatabank.teams_franchises
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@franch_id, @franch_name, @active, @na_assoc)
- 2022-11-23 17:16:51 SET `franch_id` = IF(@franch_id = '', NULL, @franch_id),
- 2022-11-23 17:16:51 `franch_name` = IF(@franch_name = '', NULL, @franch_name),
- 2022-11-23 17:16:51 `active` = IF(@active = '', NULL, @active),
- 2022-11-23 17:16:51 `na_assoc` = IF(@na_assoc = '', NULL, @na_assoc);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/baseballdatabank/teams_half.csv' INTO TABLE baseballdatabank.teams_half
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@year_id, @lg_id, @team_id, @half, @div_id, @div_win, @rank, @g, @w, @l)
- 2022-11-23 17:16:51 SET `year_id` = IF(@year_id = '', NULL, @year_id),
- 2022-11-23 17:16:51 `lg_id` = IF(@lg_id = '', NULL, @lg_id),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `half` = IF(@half = '', NULL, @half),
- 2022-11-23 17:16:51 `div_id` = IF(@div_id = '', NULL, @div_id),
- 2022-11-23 17:16:51 `div_win` = IF(@div_win = '', NULL, @div_win),
- 2022-11-23 17:16:51 `rank` = IF(@rank = '', NULL, @rank),
- 2022-11-23 17:16:51 `g` = IF(@g = '', NULL, @g),
- 2022-11-23 17:16:51 `w` = IF(@w = '', NULL, @w),
- 2022-11-23 17:16:51 `l` = IF(@l = '', NULL, @l);
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51 CREATE SCHEMA retrosheet;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.sub (
- 2022-11-23 17:16:51 game_id CHAR(12),
- 2022-11-23 17:16:51 inn_ct SMALLINT,
- 2022-11-23 17:16:51 bat_home_id SMALLINT,
- 2022-11-23 17:16:51 sub_id CHAR(8),
- 2022-11-23 17:16:51 sub_home_id BOOL,
- 2022-11-23 17:16:51 sub_lineup_id SMALLINT,
- 2022-11-23 17:16:51 sub_fld_cd SMALLINT,
- 2022-11-23 17:16:51 removed_id CHAR(8),
- 2022-11-23 17:16:51 removed_fld_cd SMALLINT,
- 2022-11-23 17:16:51 event_id SMALLINT,
- 2022-11-23 17:16:51 dummy_id INTEGER NOT NULL AUTO_INCREMENT,
- 2022-11-23 17:16:51 PRIMARY KEY (dummy_id),
- 2022-11-23 17:16:51 CHECK (sub_home_id IN (0, 1))
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.comment (
- 2022-11-23 17:16:51 game_id CHAR(12),
- 2022-11-23 17:16:51 event_id SMALLINT,
- 2022-11-23 17:16:51 comment VARCHAR(1638),
- 2022-11-23 17:16:51 ejected_person_id VARCHAR(256),
- 2022-11-23 17:16:51 ejected_person_role_cd VARCHAR(256),
- 2022-11-23 17:16:51 eject_umpire_id VARCHAR(256),
- 2022-11-23 17:16:51 eject_reason VARCHAR(1639),
- 2022-11-23 17:16:51 umpchange_inning VARCHAR(256),
- 2022-11-23 17:16:51 umpchange_position VARCHAR(256),
- 2022-11-23 17:16:51 umpchange_person_id VARCHAR(256),
- 2022-11-23 17:16:51 dummy_id INTEGER NOT NULL AUTO_INCREMENT,
- 2022-11-23 17:16:51 PRIMARY KEY (dummy_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.park (
- 2022-11-23 17:16:51 park_id CHAR(5) NOT NULL,
- 2022-11-23 17:16:51 name VARCHAR(41),
- 2022-11-23 17:16:51 aka VARCHAR(55),
- 2022-11-23 17:16:51 city VARCHAR(17),
- 2022-11-23 17:16:51 state VARCHAR(9),
- 2022-11-23 17:16:51 start_date VARCHAR(10),
- 2022-11-23 17:16:51 end_date VARCHAR(10),
- 2022-11-23 17:16:51 league CHAR(2),
- 2022-11-23 17:16:51 notes VARCHAR(54),
- 2022-11-23 17:16:51 PRIMARY KEY (park_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.roster (
- 2022-11-23 17:16:51 year INTEGER NOT NULL,
- 2022-11-23 17:16:51 player_id CHAR(8) NOT NULL,
- 2022-11-23 17:16:51 last_name VARCHAR(32),
- 2022-11-23 17:16:51 first_name VARCHAR(32),
- 2022-11-23 17:16:51 bats CHAR(1),
- 2022-11-23 17:16:51 throws CHAR(1),
- 2022-11-23 17:16:51 team_id CHAR(3) NOT NULL,
- 2022-11-23 17:16:51 position VARCHAR(2),
- 2022-11-23 17:16:51 PRIMARY KEY (year, player_id, team_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.schedule (
- 2022-11-23 17:16:51 date DATE NOT NULL,
- 2022-11-23 17:16:51 double_header SMALLINT,
- 2022-11-23 17:16:51 day_of_week CHAR(3),
- 2022-11-23 17:16:51 visiting_team CHAR(3),
- 2022-11-23 17:16:51 visiting_team_league CHAR(2),
- 2022-11-23 17:16:51 visiting_team_game_number SMALLINT,
- 2022-11-23 17:16:51 home_team CHAR(3) NOT NULL,
- 2022-11-23 17:16:51 home_team_league CHAR(2),
- 2022-11-23 17:16:51 home_team_game_number INTEGER NOT NULL,
- 2022-11-23 17:16:51 day_night CHAR(1),
- 2022-11-23 17:16:51 postponement_indicator VARCHAR(120),
- 2022-11-23 17:16:51 makeup_dates VARCHAR(120),
- 2022-11-23 17:16:51 PRIMARY KEY (date, home_team, home_team_game_number)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.code_event (
- 2022-11-23 17:16:51 code SMALLINT NOT NULL,
- 2022-11-23 17:16:51 description VARCHAR(30),
- 2022-11-23 17:16:51 PRIMARY KEY (code)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.code_field_park (
- 2022-11-23 17:16:51 code SMALLINT NOT NULL,
- 2022-11-23 17:16:51 description VARCHAR(30),
- 2022-11-23 17:16:51 PRIMARY KEY (code)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.code_method_record (
- 2022-11-23 17:16:51 code SMALLINT NOT NULL,
- 2022-11-23 17:16:51 description VARCHAR(30),
- 2022-11-23 17:16:51 PRIMARY KEY (code)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.code_pitches_record (
- 2022-11-23 17:16:51 code SMALLINT NOT NULL,
- 2022-11-23 17:16:51 description VARCHAR(30),
- 2022-11-23 17:16:51 PRIMARY KEY (code)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.code_precip_park (
- 2022-11-23 17:16:51 code SMALLINT NOT NULL,
- 2022-11-23 17:16:51 description VARCHAR(30),
- 2022-11-23 17:16:51 PRIMARY KEY (code)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.code_sky_park (
- 2022-11-23 17:16:51 code SMALLINT NOT NULL,
- 2022-11-23 17:16:51 description VARCHAR(30),
- 2022-11-23 17:16:51 PRIMARY KEY (code)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.code_wind_direction_park (
- 2022-11-23 17:16:51 code SMALLINT NOT NULL,
- 2022-11-23 17:16:51 description VARCHAR(30),
- 2022-11-23 17:16:51 PRIMARY KEY (code)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.deduced_game (
- 2022-11-23 17:16:51 game_id CHAR(12) NOT NULL,
- 2022-11-23 17:16:51 PRIMARY KEY (game_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.game (
- 2022-11-23 17:16:51 game_id CHAR(12) NOT NULL,
- 2022-11-23 17:16:51 game_dt DATE,
- 2022-11-23 17:16:51 game_ct SMALLINT,
- 2022-11-23 17:16:51 game_dy VARCHAR(9),
- 2022-11-23 17:16:51 start_game_tm SMALLINT,
- 2022-11-23 17:16:51 dh_fl VARCHAR(1),
- 2022-11-23 17:16:51 daynight_park_cd VARCHAR(1),
- 2022-11-23 17:16:51 away_team_id CHAR(3),
- 2022-11-23 17:16:51 home_team_id CHAR(3),
- 2022-11-23 17:16:51 park_id VARCHAR(5),
- 2022-11-23 17:16:51 away_start_pit_id CHAR(8),
- 2022-11-23 17:16:51 home_start_pit_id CHAR(8),
- 2022-11-23 17:16:51 base4_ump_id VARCHAR(32),
- 2022-11-23 17:16:51 base1_ump_id VARCHAR(32),
- 2022-11-23 17:16:51 base2_ump_id VARCHAR(32),
- 2022-11-23 17:16:51 base3_ump_id VARCHAR(32),
- 2022-11-23 17:16:51 lf_ump_id CHAR(8),
- 2022-11-23 17:16:51 rf_ump_id CHAR(8),
- 2022-11-23 17:16:51 attend_park_ct INTEGER,
- 2022-11-23 17:16:51 scorer_record_id VARCHAR(50),
- 2022-11-23 17:16:51 translator_record_id VARCHAR(50),
- 2022-11-23 17:16:51 inputter_record_id VARCHAR(50),
- 2022-11-23 17:16:51 input_record_ts VARCHAR(20),
- 2022-11-23 17:16:51 edit_record_ts VARCHAR(20),
- 2022-11-23 17:16:51 method_record_cd VARCHAR(1),
- 2022-11-23 17:16:51 pitches_record_cd VARCHAR(1),
- 2022-11-23 17:16:51 temp_park_ct SMALLINT,
- 2022-11-23 17:16:51 wind_direction_park_cd SMALLINT,
- 2022-11-23 17:16:51 wind_speed_park_ct SMALLINT,
- 2022-11-23 17:16:51 field_park_cd SMALLINT,
- 2022-11-23 17:16:51 precip_park_cd SMALLINT,
- 2022-11-23 17:16:51 sky_park_cd SMALLINT,
- 2022-11-23 17:16:51 minutes_game_ct SMALLINT,
- 2022-11-23 17:16:51 inn_ct SMALLINT,
- 2022-11-23 17:16:51 away_score_ct SMALLINT,
- 2022-11-23 17:16:51 home_score_ct SMALLINT,
- 2022-11-23 17:16:51 away_hits_ct SMALLINT,
- 2022-11-23 17:16:51 home_hits_ct SMALLINT,
- 2022-11-23 17:16:51 away_err_ct SMALLINT,
- 2022-11-23 17:16:51 home_err_ct SMALLINT,
- 2022-11-23 17:16:51 away_lob_ct SMALLINT,
- 2022-11-23 17:16:51 home_lob_ct SMALLINT,
- 2022-11-23 17:16:51 win_pit_id CHAR(8),
- 2022-11-23 17:16:51 lose_pit_id CHAR(8),
- 2022-11-23 17:16:51 save_pit_id CHAR(8),
- 2022-11-23 17:16:51 gwrbi_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup1_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup1_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_lineup2_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup2_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_lineup3_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup3_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_lineup4_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup4_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_lineup5_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup5_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_lineup6_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup6_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_lineup7_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup7_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_lineup8_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup8_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_lineup9_bat_id CHAR(8),
- 2022-11-23 17:16:51 away_lineup9_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup1_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup1_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup2_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup2_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup3_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup3_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup4_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup4_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup5_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup5_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup6_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup6_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup7_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup7_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup8_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup8_fld_cd SMALLINT,
- 2022-11-23 17:16:51 home_lineup9_bat_id CHAR(8),
- 2022-11-23 17:16:51 home_lineup9_fld_cd SMALLINT,
- 2022-11-23 17:16:51 away_finish_pit_id CHAR(8),
- 2022-11-23 17:16:51 home_finish_pit_id CHAR(8),
- 2022-11-23 17:16:51 away_team_league_id CHAR(1),
- 2022-11-23 17:16:51 home_team_league_id CHAR(1),
- 2022-11-23 17:16:51 away_team_game_ct SMALLINT,
- 2022-11-23 17:16:51 home_team_game_ct SMALLINT,
- 2022-11-23 17:16:51 outs_ct SMALLINT,
- 2022-11-23 17:16:51 completion_tx VARCHAR(26),
- 2022-11-23 17:16:51 forfeit_tx VARCHAR(26),
- 2022-11-23 17:16:51 protest_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_line_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_line_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_ab_ct SMALLINT,
- 2022-11-23 17:16:51 away_2b_ct SMALLINT,
- 2022-11-23 17:16:51 away_3b_ct SMALLINT,
- 2022-11-23 17:16:51 away_hr_ct SMALLINT,
- 2022-11-23 17:16:51 away_bi_ct SMALLINT,
- 2022-11-23 17:16:51 away_sh_ct SMALLINT,
- 2022-11-23 17:16:51 away_sf_ct SMALLINT,
- 2022-11-23 17:16:51 away_hp_ct SMALLINT,
- 2022-11-23 17:16:51 away_bb_ct SMALLINT,
- 2022-11-23 17:16:51 away_ibb_ct SMALLINT,
- 2022-11-23 17:16:51 away_so_ct SMALLINT,
- 2022-11-23 17:16:51 away_sb_ct SMALLINT,
- 2022-11-23 17:16:51 away_cs_ct SMALLINT,
- 2022-11-23 17:16:51 away_gdp_ct SMALLINT,
- 2022-11-23 17:16:51 away_xi_ct SMALLINT,
- 2022-11-23 17:16:51 away_pitcher_ct SMALLINT,
- 2022-11-23 17:16:51 away_er_ct SMALLINT,
- 2022-11-23 17:16:51 away_ter_ct SMALLINT,
- 2022-11-23 17:16:51 away_wp_ct SMALLINT,
- 2022-11-23 17:16:51 away_bk_ct SMALLINT,
- 2022-11-23 17:16:51 away_po_ct SMALLINT,
- 2022-11-23 17:16:51 away_a_ct SMALLINT,
- 2022-11-23 17:16:51 away_pb_ct SMALLINT,
- 2022-11-23 17:16:51 away_dp_ct SMALLINT,
- 2022-11-23 17:16:51 away_tp_ct SMALLINT,
- 2022-11-23 17:16:51 home_ab_ct SMALLINT,
- 2022-11-23 17:16:51 home_2b_ct SMALLINT,
- 2022-11-23 17:16:51 home_3b_ct SMALLINT,
- 2022-11-23 17:16:51 home_hr_ct SMALLINT,
- 2022-11-23 17:16:51 home_bi_ct SMALLINT,
- 2022-11-23 17:16:51 home_sh_ct SMALLINT,
- 2022-11-23 17:16:51 home_sf_ct SMALLINT,
- 2022-11-23 17:16:51 home_hp_ct SMALLINT,
- 2022-11-23 17:16:51 home_bb_ct SMALLINT,
- 2022-11-23 17:16:51 home_ibb_ct SMALLINT,
- 2022-11-23 17:16:51 home_so_ct SMALLINT,
- 2022-11-23 17:16:51 home_sb_ct SMALLINT,
- 2022-11-23 17:16:51 home_cs_ct SMALLINT,
- 2022-11-23 17:16:51 home_gdp_ct SMALLINT,
- 2022-11-23 17:16:51 home_xi_ct SMALLINT,
- 2022-11-23 17:16:51 home_pitcher_ct SMALLINT,
- 2022-11-23 17:16:51 home_er_ct SMALLINT,
- 2022-11-23 17:16:51 home_ter_ct SMALLINT,
- 2022-11-23 17:16:51 home_wp_ct SMALLINT,
- 2022-11-23 17:16:51 home_bk_ct SMALLINT,
- 2022-11-23 17:16:51 home_po_ct SMALLINT,
- 2022-11-23 17:16:51 home_a_ct SMALLINT,
- 2022-11-23 17:16:51 home_pb_ct SMALLINT,
- 2022-11-23 17:16:51 home_dp_ct SMALLINT,
- 2022-11-23 17:16:51 home_tp_ct SMALLINT,
- 2022-11-23 17:16:51 ump_home_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 ump_1b_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 ump_2b_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 ump_3b_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 ump_lf_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 ump_rf_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_manager_id CHAR(8),
- 2022-11-23 17:16:51 away_manager_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_manager_id CHAR(8),
- 2022-11-23 17:16:51 home_manager_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 win_pit_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 lose_pit_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 save_pit_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 goahead_rbi_id CHAR(8),
- 2022-11-23 17:16:51 goahead_rbi_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup1_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup2_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup3_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup4_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup5_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup6_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup7_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup8_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 away_lineup9_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup1_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup2_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup3_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup4_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup5_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup6_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup7_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup8_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 home_lineup9_bat_name_tx VARCHAR(26),
- 2022-11-23 17:16:51 add_info_tx VARCHAR(26),
- 2022-11-23 17:16:51 acq_info_tx VARCHAR(26),
- 2022-11-23 17:16:51 PRIMARY KEY (game_id)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.gamelog (
- 2022-11-23 17:16:51 date DATE NOT NULL,
- 2022-11-23 17:16:51 double_header CHAR(1) NOT NULL,
- 2022-11-23 17:16:51 day_of_week CHAR(3),
- 2022-11-23 17:16:51 visiting_team CHAR(3) NOT NULL,
- 2022-11-23 17:16:51 visiting_team_league CHAR(2),
- 2022-11-23 17:16:51 visiting_team_game_number SMALLINT,
- 2022-11-23 17:16:51 home_team CHAR(3) NOT NULL,
- 2022-11-23 17:16:51 home_team_league CHAR(2),
- 2022-11-23 17:16:51 home_team_game_number SMALLINT,
- 2022-11-23 17:16:51 visitor_runs_scored SMALLINT,
- 2022-11-23 17:16:51 home_runs_score SMALLINT,
- 2022-11-23 17:16:51 length_in_outs SMALLINT,
- 2022-11-23 17:16:51 day_night CHAR(1),
- 2022-11-23 17:16:51 completion_info VARCHAR(23),
- 2022-11-23 17:16:51 forfeit_info VARCHAR(3),
- 2022-11-23 17:16:51 protest_info VARCHAR(3),
- 2022-11-23 17:16:51 park_id CHAR(5),
- 2022-11-23 17:16:51 attendance INTEGER,
- 2022-11-23 17:16:51 duration SMALLINT,
- 2022-11-23 17:16:51 vistor_line_score VARCHAR(26),
- 2022-11-23 17:16:51 home_line_score VARCHAR(26),
- 2022-11-23 17:16:51 visitor_ab SMALLINT,
- 2022-11-23 17:16:51 visitor_h SMALLINT,
- 2022-11-23 17:16:51 visitor_d SMALLINT,
- 2022-11-23 17:16:51 visitor_t SMALLINT,
- 2022-11-23 17:16:51 visitor_hr SMALLINT,
- 2022-11-23 17:16:51 visitor_rbi SMALLINT,
- 2022-11-23 17:16:51 visitor_sh SMALLINT,
- 2022-11-23 17:16:51 visitor_sf SMALLINT,
- 2022-11-23 17:16:51 visitor_hbp SMALLINT,
- 2022-11-23 17:16:51 visitor_bb SMALLINT,
- 2022-11-23 17:16:51 visitor_ibb SMALLINT,
- 2022-11-23 17:16:51 visitor_k SMALLINT,
- 2022-11-23 17:16:51 visitor_sb SMALLINT,
- 2022-11-23 17:16:51 visitor_cs SMALLINT,
- 2022-11-23 17:16:51 visitor_gdp SMALLINT,
- 2022-11-23 17:16:51 visitor_ci SMALLINT,
- 2022-11-23 17:16:51 visitor_lob SMALLINT,
- 2022-11-23 17:16:51 visitor_pitchers SMALLINT,
- 2022-11-23 17:16:51 visitor_er SMALLINT,
- 2022-11-23 17:16:51 visitor_ter SMALLINT,
- 2022-11-23 17:16:51 visitor_wp SMALLINT,
- 2022-11-23 17:16:51 visitor_balks SMALLINT,
- 2022-11-23 17:16:51 visitor_po SMALLINT,
- 2022-11-23 17:16:51 visitor_a SMALLINT,
- 2022-11-23 17:16:51 visitor_e SMALLINT,
- 2022-11-23 17:16:51 visitor_passed SMALLINT,
- 2022-11-23 17:16:51 visitor_db SMALLINT,
- 2022-11-23 17:16:51 visitor_tp SMALLINT,
- 2022-11-23 17:16:51 home_ab SMALLINT,
- 2022-11-23 17:16:51 home_h SMALLINT,
- 2022-11-23 17:16:51 home_d SMALLINT,
- 2022-11-23 17:16:51 home_t SMALLINT,
- 2022-11-23 17:16:51 home_hr SMALLINT,
- 2022-11-23 17:16:51 home_rbi SMALLINT,
- 2022-11-23 17:16:51 home_sh SMALLINT,
- 2022-11-23 17:16:51 home_sf SMALLINT,
- 2022-11-23 17:16:51 home_hbp SMALLINT,
- 2022-11-23 17:16:51 home_bb SMALLINT,
- 2022-11-23 17:16:51 home_ibb SMALLINT,
- 2022-11-23 17:16:51 home_k SMALLINT,
- 2022-11-23 17:16:51 home_sb SMALLINT,
- 2022-11-23 17:16:51 home_cs SMALLINT,
- 2022-11-23 17:16:51 home_gdp SMALLINT,
- 2022-11-23 17:16:51 home_ci SMALLINT,
- 2022-11-23 17:16:51 home_lob SMALLINT,
- 2022-11-23 17:16:51 home_pitchers SMALLINT,
- 2022-11-23 17:16:51 home_er SMALLINT,
- 2022-11-23 17:16:51 home_ter SMALLINT,
- 2022-11-23 17:16:51 home_wp SMALLINT,
- 2022-11-23 17:16:51 home_balks SMALLINT,
- 2022-11-23 17:16:51 home_po SMALLINT,
- 2022-11-23 17:16:51 home_a SMALLINT,
- 2022-11-23 17:16:51 home_e SMALLINT,
- 2022-11-23 17:16:51 home_passed SMALLINT,
- 2022-11-23 17:16:51 home_db SMALLINT,
- 2022-11-23 17:16:51 home_tp SMALLINT,
- 2022-11-23 17:16:51 umpire_h_id CHAR(8),
- 2022-11-23 17:16:51 umpire_h_name VARCHAR(32),
- 2022-11-23 17:16:51 umpire_1b_id CHAR(8),
- 2022-11-23 17:16:51 umpire_1b_name VARCHAR(32),
- 2022-11-23 17:16:51 umpire_2b_id CHAR(8),
- 2022-11-23 17:16:51 umpire_2b_name VARCHAR(32),
- 2022-11-23 17:16:51 umpire_3b_id CHAR(8),
- 2022-11-23 17:16:51 umpire_3b_name VARCHAR(32),
- 2022-11-23 17:16:51 umpire_lf_id CHAR(8),
- 2022-11-23 17:16:51 umpire_lf_name VARCHAR(32),
- 2022-11-23 17:16:51 umpire_rf_id CHAR(8),
- 2022-11-23 17:16:51 umpire_rf_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_manager_id CHAR(8),
- 2022-11-23 17:16:51 visitor_manager_name VARCHAR(32),
- 2022-11-23 17:16:51 home_manager_id CHAR(8),
- 2022-11-23 17:16:51 home_manager_name VARCHAR(32),
- 2022-11-23 17:16:51 winning_pitcher_id CHAR(8),
- 2022-11-23 17:16:51 winning_pitcher_name VARCHAR(32),
- 2022-11-23 17:16:51 losing_pitcher_id CHAR(8),
- 2022-11-23 17:16:51 losing_pitcher_name VARCHAR(32),
- 2022-11-23 17:16:51 saving_pitcher_id CHAR(8),
- 2022-11-23 17:16:51 saving_pitcher_name VARCHAR(32),
- 2022-11-23 17:16:51 game_winning_rbi_id CHAR(8),
- 2022-11-23 17:16:51 game_winning_rbi_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_starting_pitcher_id CHAR(8),
- 2022-11-23 17:16:51 visitor_starting_pitcher_name VARCHAR(32),
- 2022-11-23 17:16:51 home_starting_pitcher_id CHAR(8),
- 2022-11-23 17:16:51 home_starting_pitcher_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_1_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_1_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_1_position SMALLINT,
- 2022-11-23 17:16:51 visitor_batting_2_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_2_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_2_position SMALLINT,
- 2022-11-23 17:16:51 visitor_batting_3_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_3_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_3_position SMALLINT,
- 2022-11-23 17:16:51 visitor_batting_4_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_4_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_4_position SMALLINT,
- 2022-11-23 17:16:51 visitor_batting_5_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_5_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_5_position SMALLINT,
- 2022-11-23 17:16:51 visitor_batting_6_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_6_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_6_position SMALLINT,
- 2022-11-23 17:16:51 visitor_batting_7_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_7_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_7_position SMALLINT,
- 2022-11-23 17:16:51 visitor_batting_8_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_8_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_8_position SMALLINT,
- 2022-11-23 17:16:51 visitor_batting_9_player_id CHAR(8),
- 2022-11-23 17:16:51 visitor_batting_9_name VARCHAR(32),
- 2022-11-23 17:16:51 visitor_batting_9_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_1_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_1_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_1_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_2_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_2_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_2_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_3_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_3_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_3_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_4_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_4_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_4_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_5_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_5_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_5_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_6_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_6_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_6_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_7_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_7_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_7_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_8_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_8_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_8_position SMALLINT,
- 2022-11-23 17:16:51 home_batting_9_player_id CHAR(8),
- 2022-11-23 17:16:51 home_batting_9_name VARCHAR(32),
- 2022-11-23 17:16:51 home_batting_9_position SMALLINT,
- 2022-11-23 17:16:51 additional_info VARCHAR(128),
- 2022-11-23 17:16:51 acquisition_info CHAR(1),
- 2022-11-23 17:16:51 PRIMARY KEY (date, double_header, visiting_team, home_team)
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.daily (
- 2022-11-23 17:16:51 game_id CHAR(12),
- 2022-11-23 17:16:51 game_dt DATE,
- 2022-11-23 17:16:51 game_ct SMALLINT,
- 2022-11-23 17:16:51 appearance_dt DATE,
- 2022-11-23 17:16:51 team_id CHAR(3),
- 2022-11-23 17:16:51 player_id CHAR(8),
- 2022-11-23 17:16:51 slot_ct SMALLINT,
- 2022-11-23 17:16:51 seq_ct SMALLINT,
- 2022-11-23 17:16:51 home_fl BOOL,
- 2022-11-23 17:16:51 opponent_id CHAR(3),
- 2022-11-23 17:16:51 park_id CHAR(5),
- 2022-11-23 17:16:51 b_g SMALLINT,
- 2022-11-23 17:16:51 b_pa SMALLINT,
- 2022-11-23 17:16:51 b_ab SMALLINT,
- 2022-11-23 17:16:51 b_r SMALLINT,
- 2022-11-23 17:16:51 b_h SMALLINT,
- 2022-11-23 17:16:51 b_tb SMALLINT,
- 2022-11-23 17:16:51 b_2b SMALLINT,
- 2022-11-23 17:16:51 b_3b SMALLINT,
- 2022-11-23 17:16:51 b_hr SMALLINT,
- 2022-11-23 17:16:51 b_hr4 SMALLINT,
- 2022-11-23 17:16:51 b_rbi SMALLINT,
- 2022-11-23 17:16:51 b_gw SMALLINT,
- 2022-11-23 17:16:51 b_bb SMALLINT,
- 2022-11-23 17:16:51 b_ibb SMALLINT,
- 2022-11-23 17:16:51 b_so SMALLINT,
- 2022-11-23 17:16:51 b_gdp SMALLINT,
- 2022-11-23 17:16:51 b_hp SMALLINT,
- 2022-11-23 17:16:51 b_sh SMALLINT,
- 2022-11-23 17:16:51 b_sf SMALLINT,
- 2022-11-23 17:16:51 b_sb SMALLINT,
- 2022-11-23 17:16:51 b_cs SMALLINT,
- 2022-11-23 17:16:51 b_xi SMALLINT,
- 2022-11-23 17:16:51 b_g_dh SMALLINT,
- 2022-11-23 17:16:51 b_g_ph SMALLINT,
- 2022-11-23 17:16:51 b_g_pr SMALLINT,
- 2022-11-23 17:16:51 p_g SMALLINT,
- 2022-11-23 17:16:51 p_gs SMALLINT,
- 2022-11-23 17:16:51 p_cg SMALLINT,
- 2022-11-23 17:16:51 p_sho SMALLINT,
- 2022-11-23 17:16:51 p_gf SMALLINT,
- 2022-11-23 17:16:51 p_w SMALLINT,
- 2022-11-23 17:16:51 p_l SMALLINT,
- 2022-11-23 17:16:51 p_sv SMALLINT,
- 2022-11-23 17:16:51 p_out SMALLINT,
- 2022-11-23 17:16:51 p_tbf SMALLINT,
- 2022-11-23 17:16:51 p_ab SMALLINT,
- 2022-11-23 17:16:51 p_r SMALLINT,
- 2022-11-23 17:16:51 p_er SMALLINT,
- 2022-11-23 17:16:51 p_h SMALLINT,
- 2022-11-23 17:16:51 p_tb SMALLINT,
- 2022-11-23 17:16:51 p_2b SMALLINT,
- 2022-11-23 17:16:51 p_3b SMALLINT,
- 2022-11-23 17:16:51 p_hr SMALLINT,
- 2022-11-23 17:16:51 p_hr4 SMALLINT,
- 2022-11-23 17:16:51 p_bb SMALLINT,
- 2022-11-23 17:16:51 p_ibb SMALLINT,
- 2022-11-23 17:16:51 p_so SMALLINT,
- 2022-11-23 17:16:51 p_gdp SMALLINT,
- 2022-11-23 17:16:51 p_hp SMALLINT,
- 2022-11-23 17:16:51 p_sh SMALLINT,
- 2022-11-23 17:16:51 p_sf SMALLINT,
- 2022-11-23 17:16:51 p_xi SMALLINT,
- 2022-11-23 17:16:51 p_wp SMALLINT,
- 2022-11-23 17:16:51 p_bk SMALLINT,
- 2022-11-23 17:16:51 p_ir SMALLINT,
- 2022-11-23 17:16:51 p_irs SMALLINT,
- 2022-11-23 17:16:51 p_go SMALLINT,
- 2022-11-23 17:16:51 p_ao SMALLINT,
- 2022-11-23 17:16:51 p_pitch SMALLINT,
- 2022-11-23 17:16:51 p_strike SMALLINT,
- 2022-11-23 17:16:51 f_p_g SMALLINT,
- 2022-11-23 17:16:51 f_p_gs SMALLINT,
- 2022-11-23 17:16:51 f_p_out SMALLINT,
- 2022-11-23 17:16:51 f_p_tc SMALLINT,
- 2022-11-23 17:16:51 f_p_po SMALLINT,
- 2022-11-23 17:16:51 f_p_a SMALLINT,
- 2022-11-23 17:16:51 f_p_e SMALLINT,
- 2022-11-23 17:16:51 f_p_dp SMALLINT,
- 2022-11-23 17:16:51 f_p_tp SMALLINT,
- 2022-11-23 17:16:51 f_c_g SMALLINT,
- 2022-11-23 17:16:51 f_c_gs SMALLINT,
- 2022-11-23 17:16:51 f_c_out SMALLINT,
- 2022-11-23 17:16:51 f_c_tc SMALLINT,
- 2022-11-23 17:16:51 f_c_po SMALLINT,
- 2022-11-23 17:16:51 f_c_a SMALLINT,
- 2022-11-23 17:16:51 f_c_e SMALLINT,
- 2022-11-23 17:16:51 f_c_dp SMALLINT,
- 2022-11-23 17:16:51 f_c_tp SMALLINT,
- 2022-11-23 17:16:51 f_c_pb SMALLINT,
- 2022-11-23 17:16:51 f_c_xi SMALLINT,
- 2022-11-23 17:16:51 f_1b_g SMALLINT,
- 2022-11-23 17:16:51 f_1b_gs SMALLINT,
- 2022-11-23 17:16:51 f_1b_out SMALLINT,
- 2022-11-23 17:16:51 f_1b_tc SMALLINT,
- 2022-11-23 17:16:51 f_1b_po SMALLINT,
- 2022-11-23 17:16:51 f_1b_a SMALLINT,
- 2022-11-23 17:16:51 f_1b_e SMALLINT,
- 2022-11-23 17:16:51 f_1b_dp SMALLINT,
- 2022-11-23 17:16:51 f_1b_tp SMALLINT,
- 2022-11-23 17:16:51 f_2b_g SMALLINT,
- 2022-11-23 17:16:51 f_2b_gs SMALLINT,
- 2022-11-23 17:16:51 f_2b_out SMALLINT,
- 2022-11-23 17:16:51 f_2b_tc SMALLINT,
- 2022-11-23 17:16:51 f_2b_po SMALLINT,
- 2022-11-23 17:16:51 f_2b_a SMALLINT,
- 2022-11-23 17:16:51 f_2b_e SMALLINT,
- 2022-11-23 17:16:51 f_2b_dp SMALLINT,
- 2022-11-23 17:16:51 f_2b_tp SMALLINT,
- 2022-11-23 17:16:51 f_3b_g SMALLINT,
- 2022-11-23 17:16:51 f_3b_gs SMALLINT,
- 2022-11-23 17:16:51 f_3b_out SMALLINT,
- 2022-11-23 17:16:51 f_3b_tc SMALLINT,
- 2022-11-23 17:16:51 f_3b_po SMALLINT,
- 2022-11-23 17:16:51 f_3b_a SMALLINT,
- 2022-11-23 17:16:51 f_3b_e SMALLINT,
- 2022-11-23 17:16:51 f_3b_dp SMALLINT,
- 2022-11-23 17:16:51 f_3b_tp SMALLINT,
- 2022-11-23 17:16:51 f_ss_g SMALLINT,
- 2022-11-23 17:16:51 f_ss_gs SMALLINT,
- 2022-11-23 17:16:51 f_ss_out SMALLINT,
- 2022-11-23 17:16:51 f_ss_tc SMALLINT,
- 2022-11-23 17:16:51 f_ss_po SMALLINT,
- 2022-11-23 17:16:51 f_ss_a SMALLINT,
- 2022-11-23 17:16:51 f_ss_e SMALLINT,
- 2022-11-23 17:16:51 f_ss_dp SMALLINT,
- 2022-11-23 17:16:51 f_ss_tp SMALLINT,
- 2022-11-23 17:16:51 f_lf_g SMALLINT,
- 2022-11-23 17:16:51 f_lf_gs SMALLINT,
- 2022-11-23 17:16:51 f_lf_out SMALLINT,
- 2022-11-23 17:16:51 f_lf_tc SMALLINT,
- 2022-11-23 17:16:51 f_lf_po SMALLINT,
- 2022-11-23 17:16:51 f_lf_a SMALLINT,
- 2022-11-23 17:16:51 f_lf_e SMALLINT,
- 2022-11-23 17:16:51 f_lf_dp SMALLINT,
- 2022-11-23 17:16:51 f_lf_tp SMALLINT,
- 2022-11-23 17:16:51 f_cf_g SMALLINT,
- 2022-11-23 17:16:51 f_cf_gs SMALLINT,
- 2022-11-23 17:16:51 f_cf_out SMALLINT,
- 2022-11-23 17:16:51 f_cf_tc SMALLINT,
- 2022-11-23 17:16:51 f_cf_po SMALLINT,
- 2022-11-23 17:16:51 f_cf_a SMALLINT,
- 2022-11-23 17:16:51 f_cf_e SMALLINT,
- 2022-11-23 17:16:51 f_cf_dp SMALLINT,
- 2022-11-23 17:16:51 f_cf_tp SMALLINT,
- 2022-11-23 17:16:51 f_rf_g SMALLINT,
- 2022-11-23 17:16:51 f_rf_gs SMALLINT,
- 2022-11-23 17:16:51 f_rf_out SMALLINT,
- 2022-11-23 17:16:51 f_rf_tc SMALLINT,
- 2022-11-23 17:16:51 f_rf_po SMALLINT,
- 2022-11-23 17:16:51 f_rf_a SMALLINT,
- 2022-11-23 17:16:51 f_rf_e SMALLINT,
- 2022-11-23 17:16:51 f_rf_dp SMALLINT,
- 2022-11-23 17:16:51 f_rf_tp SMALLINT,
- 2022-11-23 17:16:51 dummy_id INTEGER NOT NULL AUTO_INCREMENT,
- 2022-11-23 17:16:51 PRIMARY KEY (dummy_id),
- 2022-11-23 17:16:51 CHECK (home_fl IN (0, 1))
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 CREATE TABLE retrosheet.event (
- 2022-11-23 17:16:51 game_id CHAR(12) NOT NULL,
- 2022-11-23 17:16:51 away_team_id CHAR(3),
- 2022-11-23 17:16:51 inn_ct SMALLINT,
- 2022-11-23 17:16:51 bat_home_id BOOL,
- 2022-11-23 17:16:51 outs_ct SMALLINT,
- 2022-11-23 17:16:51 balls_ct SMALLINT,
- 2022-11-23 17:16:51 strikes_ct SMALLINT,
- 2022-11-23 17:16:51 pitch_seq_tx VARCHAR(30),
- 2022-11-23 17:16:51 away_score_ct SMALLINT,
- 2022-11-23 17:16:51 home_score_ct SMALLINT,
- 2022-11-23 17:16:51 bat_id CHAR(8),
- 2022-11-23 17:16:51 bat_hand_cd CHAR(1),
- 2022-11-23 17:16:51 resp_bat_id CHAR(8),
- 2022-11-23 17:16:51 resp_bat_hand_cd CHAR(1),
- 2022-11-23 17:16:51 pit_id CHAR(8),
- 2022-11-23 17:16:51 pit_hand_cd CHAR(1),
- 2022-11-23 17:16:51 resp_pit_id CHAR(8),
- 2022-11-23 17:16:51 resp_pit_hand_cd CHAR(1),
- 2022-11-23 17:16:51 pos2_fld_id CHAR(8),
- 2022-11-23 17:16:51 pos3_fld_id CHAR(8),
- 2022-11-23 17:16:51 pos4_fld_id CHAR(8),
- 2022-11-23 17:16:51 pos5_fld_id CHAR(8),
- 2022-11-23 17:16:51 pos6_fld_id CHAR(8),
- 2022-11-23 17:16:51 pos7_fld_id CHAR(8),
- 2022-11-23 17:16:51 pos8_fld_id CHAR(8),
- 2022-11-23 17:16:51 pos9_fld_id CHAR(8),
- 2022-11-23 17:16:51 base1_run_id CHAR(8),
- 2022-11-23 17:16:51 base2_run_id CHAR(8),
- 2022-11-23 17:16:51 base3_run_id CHAR(8),
- 2022-11-23 17:16:51 event_tx VARCHAR(128),
- 2022-11-23 17:16:51 leadoff_fl BOOL,
- 2022-11-23 17:16:51 ph_fl BOOL,
- 2022-11-23 17:16:51 bat_fld_cd SMALLINT,
- 2022-11-23 17:16:51 bat_lineup_id SMALLINT,
- 2022-11-23 17:16:51 event_cd SMALLINT,
- 2022-11-23 17:16:51 bat_event_fl BOOL,
- 2022-11-23 17:16:51 ab_fl BOOL,
- 2022-11-23 17:16:51 h_fl SMALLINT,
- 2022-11-23 17:16:51 sh_fl BOOL,
- 2022-11-23 17:16:51 sf_fl BOOL,
- 2022-11-23 17:16:51 event_outs_ct SMALLINT,
- 2022-11-23 17:16:51 dp_fl BOOL,
- 2022-11-23 17:16:51 tp_fl BOOL,
- 2022-11-23 17:16:51 rbi_ct SMALLINT,
- 2022-11-23 17:16:51 wp_fl BOOL,
- 2022-11-23 17:16:51 pb_fl BOOL,
- 2022-11-23 17:16:51 fld_cd SMALLINT,
- 2022-11-23 17:16:51 battedball_cd CHAR(1),
- 2022-11-23 17:16:51 bunt_fl BOOL,
- 2022-11-23 17:16:51 foul_fl BOOL,
- 2022-11-23 17:16:51 battedball_loc_tx VARCHAR(5),
- 2022-11-23 17:16:51 err_ct SMALLINT,
- 2022-11-23 17:16:51 err1_fld_cd SMALLINT,
- 2022-11-23 17:16:51 err1_cd CHAR(1),
- 2022-11-23 17:16:51 err2_fld_cd SMALLINT,
- 2022-11-23 17:16:51 err2_cd CHAR(1),
- 2022-11-23 17:16:51 err3_fld_cd SMALLINT,
- 2022-11-23 17:16:51 err3_cd CHAR(1),
- 2022-11-23 17:16:51 bat_dest_id SMALLINT,
- 2022-11-23 17:16:51 run1_dest_id SMALLINT,
- 2022-11-23 17:16:51 run2_dest_id SMALLINT,
- 2022-11-23 17:16:51 run3_dest_id SMALLINT,
- 2022-11-23 17:16:51 bat_play_tx VARCHAR(15),
- 2022-11-23 17:16:51 run1_play_tx VARCHAR(15),
- 2022-11-23 17:16:51 run2_play_tx VARCHAR(15),
- 2022-11-23 17:16:51 run3_play_tx VARCHAR(15),
- 2022-11-23 17:16:51 run1_sb_fl BOOL,
- 2022-11-23 17:16:51 run2_sb_fl BOOL,
- 2022-11-23 17:16:51 run3_sb_fl BOOL,
- 2022-11-23 17:16:51 run1_cs_fl BOOL,
- 2022-11-23 17:16:51 run2_cs_fl BOOL,
- 2022-11-23 17:16:51 run3_cs_fl BOOL,
- 2022-11-23 17:16:51 run1_pk_fl BOOL,
- 2022-11-23 17:16:51 run2_pk_fl BOOL,
- 2022-11-23 17:16:51 run3_pk_fl BOOL,
- 2022-11-23 17:16:51 run1_resp_pit_id CHAR(8),
- 2022-11-23 17:16:51 run2_resp_pit_id CHAR(8),
- 2022-11-23 17:16:51 run3_resp_pit_id CHAR(8),
- 2022-11-23 17:16:51 game_new_fl BOOL,
- 2022-11-23 17:16:51 game_end_fl BOOL,
- 2022-11-23 17:16:51 pr_run1_fl BOOL,
- 2022-11-23 17:16:51 pr_run2_fl BOOL,
- 2022-11-23 17:16:51 pr_run3_fl BOOL,
- 2022-11-23 17:16:51 removed_for_pr_run1_id CHAR(8),
- 2022-11-23 17:16:51 removed_for_pr_run2_id CHAR(8),
- 2022-11-23 17:16:51 removed_for_pr_run3_id CHAR(8),
- 2022-11-23 17:16:51 removed_for_ph_bat_id CHAR(8),
- 2022-11-23 17:16:51 removed_for_ph_bat_fld_cd INTEGER,
- 2022-11-23 17:16:51 po1_fld_cd SMALLINT,
- 2022-11-23 17:16:51 po2_fld_cd SMALLINT,
- 2022-11-23 17:16:51 po3_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass1_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass2_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass3_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass4_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass5_fld_cd SMALLINT,
- 2022-11-23 17:16:51 event_id INTEGER NOT NULL,
- 2022-11-23 17:16:51 home_team_id CHAR(3),
- 2022-11-23 17:16:51 bat_team_id CHAR(3),
- 2022-11-23 17:16:51 fld_team_id CHAR(3),
- 2022-11-23 17:16:51 bat_last_id SMALLINT,
- 2022-11-23 17:16:51 inn_new_fl BOOL,
- 2022-11-23 17:16:51 inn_end_fl BOOL,
- 2022-11-23 17:16:51 start_bat_score_ct SMALLINT,
- 2022-11-23 17:16:51 start_fld_score_ct SMALLINT,
- 2022-11-23 17:16:51 inn_runs_ct SMALLINT,
- 2022-11-23 17:16:51 game_pa_ct SMALLINT,
- 2022-11-23 17:16:51 inn_pa_ct SMALLINT,
- 2022-11-23 17:16:51 pa_new_fl BOOL,
- 2022-11-23 17:16:51 pa_trunc_fl BOOL,
- 2022-11-23 17:16:51 start_bases_cd SMALLINT,
- 2022-11-23 17:16:51 end_bases_cd SMALLINT,
- 2022-11-23 17:16:51 bat_start_fl BOOL,
- 2022-11-23 17:16:51 resp_bat_start_fl BOOL,
- 2022-11-23 17:16:51 bat_on_deck_id CHAR(8),
- 2022-11-23 17:16:51 bat_in_hold_id CHAR(8),
- 2022-11-23 17:16:51 pit_start_fl BOOL,
- 2022-11-23 17:16:51 resp_pit_start_fl BOOL,
- 2022-11-23 17:16:51 run1_fld_cd SMALLINT,
- 2022-11-23 17:16:51 run1_lineup_cd SMALLINT,
- 2022-11-23 17:16:51 run1_origin_event_id SMALLINT,
- 2022-11-23 17:16:51 run2_fld_cd SMALLINT,
- 2022-11-23 17:16:51 run2_lineup_cd SMALLINT,
- 2022-11-23 17:16:51 run2_origin_event_id SMALLINT,
- 2022-11-23 17:16:51 run3_fld_cd SMALLINT,
- 2022-11-23 17:16:51 run3_lineup_cd SMALLINT,
- 2022-11-23 17:16:51 run3_origin_event_id SMALLINT,
- 2022-11-23 17:16:51 run1_resp_cat_id CHAR(8),
- 2022-11-23 17:16:51 run2_resp_cat_id CHAR(8),
- 2022-11-23 17:16:51 run3_resp_cat_id CHAR(8),
- 2022-11-23 17:16:51 pa_ball_ct SMALLINT,
- 2022-11-23 17:16:51 pa_called_ball_ct SMALLINT,
- 2022-11-23 17:16:51 pa_intent_ball_ct SMALLINT,
- 2022-11-23 17:16:51 pa_pitchout_ball_ct SMALLINT,
- 2022-11-23 17:16:51 pa_hitbatter_ball_ct SMALLINT,
- 2022-11-23 17:16:51 pa_other_ball_ct SMALLINT,
- 2022-11-23 17:16:51 pa_strike_ct SMALLINT,
- 2022-11-23 17:16:51 pa_called_strike_ct SMALLINT,
- 2022-11-23 17:16:51 pa_swingmiss_strike_ct SMALLINT,
- 2022-11-23 17:16:51 pa_foul_strike_ct SMALLINT,
- 2022-11-23 17:16:51 pa_inplay_strike_ct SMALLINT,
- 2022-11-23 17:16:51 pa_other_strike_ct SMALLINT,
- 2022-11-23 17:16:51 event_runs_ct SMALLINT,
- 2022-11-23 17:16:51 fld_id CHAR(8),
- 2022-11-23 17:16:51 base2_force_fl BOOL,
- 2022-11-23 17:16:51 base3_force_fl BOOL,
- 2022-11-23 17:16:51 base4_force_fl BOOL,
- 2022-11-23 17:16:51 bat_safe_err_fl BOOL,
- 2022-11-23 17:16:51 bat_fate_id SMALLINT,
- 2022-11-23 17:16:51 run1_fate_id SMALLINT,
- 2022-11-23 17:16:51 run2_fate_id SMALLINT,
- 2022-11-23 17:16:51 run3_fate_id SMALLINT,
- 2022-11-23 17:16:51 fate_runs_ct SMALLINT,
- 2022-11-23 17:16:51 ass6_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass7_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass8_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass9_fld_cd SMALLINT,
- 2022-11-23 17:16:51 ass10_fld_cd SMALLINT,
- 2022-11-23 17:16:51 unknown_out_exc_fl BOOL,
- 2022-11-23 17:16:51 uncertain_play_exc_fl BOOL,
- 2022-11-23 17:16:51 PRIMARY KEY (game_id, event_id),
- 2022-11-23 17:16:51 CHECK (bat_home_id IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (leadoff_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (ph_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (bat_event_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (ab_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (sh_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (sf_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (dp_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (tp_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (wp_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (pb_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (bunt_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (foul_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run1_sb_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run2_sb_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run3_sb_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run1_cs_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run2_cs_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run3_cs_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run1_pk_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run2_pk_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (run3_pk_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (game_new_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (game_end_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (pr_run1_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (pr_run2_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (pr_run3_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (inn_new_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (inn_end_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (pa_new_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (pa_trunc_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (bat_start_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (resp_bat_start_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (pit_start_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (resp_pit_start_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (base2_force_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (base3_force_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (base4_force_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (bat_safe_err_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (unknown_out_exc_fl IN (0, 1)),
- 2022-11-23 17:16:51 CHECK (uncertain_play_exc_fl IN (0, 1))
- 2022-11-23 17:16:51 )
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/sub.csv' INTO TABLE retrosheet.sub
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@game_id, @inn_ct, @bat_home_id, @sub_id, @sub_home_id, @sub_lineup_id, @sub_fld_cd, @removed_id, @removed_fld_cd, @event_id, @dummy_id)
- 2022-11-23 17:16:51 SET `sub_home_id` = IF(@sub_home_id = 'T', 1, IF(@sub_home_id = 'F', 0, IF(@sub_home_id = '', NULL, @sub_home_id))),
- 2022-11-23 17:16:51 `game_id` = IF(@game_id = '', NULL, @game_id),
- 2022-11-23 17:16:51 `inn_ct` = IF(@inn_ct = '', NULL, @inn_ct),
- 2022-11-23 17:16:51 `bat_home_id` = IF(@bat_home_id = '', NULL, @bat_home_id),
- 2022-11-23 17:16:51 `sub_id` = IF(@sub_id = '', NULL, @sub_id),
- 2022-11-23 17:16:51 `sub_lineup_id` = IF(@sub_lineup_id = '', NULL, @sub_lineup_id),
- 2022-11-23 17:16:51 `sub_fld_cd` = IF(@sub_fld_cd = '', NULL, @sub_fld_cd),
- 2022-11-23 17:16:51 `removed_id` = IF(@removed_id = '', NULL, @removed_id),
- 2022-11-23 17:16:51 `removed_fld_cd` = IF(@removed_fld_cd = '', NULL, @removed_fld_cd),
- 2022-11-23 17:16:51 `event_id` = IF(@event_id = '', NULL, @event_id),
- 2022-11-23 17:16:51 `dummy_id` = IF(@dummy_id = '', NULL, @dummy_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/comment.csv' INTO TABLE retrosheet.comment
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@game_id, @event_id, @comment, @ejected_person_id, @ejected_person_role_cd, @eject_umpire_id, @eject_reason, @umpchange_inning, @umpchange_position, @umpchange_person_id, @dummy_id)
- 2022-11-23 17:16:51 SET `game_id` = IF(@game_id = '', NULL, @game_id),
- 2022-11-23 17:16:51 `event_id` = IF(@event_id = '', NULL, @event_id),
- 2022-11-23 17:16:51 `comment` = IF(@comment = '', NULL, @comment),
- 2022-11-23 17:16:51 `ejected_person_id` = IF(@ejected_person_id = '', NULL, @ejected_person_id),
- 2022-11-23 17:16:51 `ejected_person_role_cd` = IF(@ejected_person_role_cd = '', NULL, @ejected_person_role_cd),
- 2022-11-23 17:16:51 `eject_umpire_id` = IF(@eject_umpire_id = '', NULL, @eject_umpire_id),
- 2022-11-23 17:16:51 `eject_reason` = IF(@eject_reason = '', NULL, @eject_reason),
- 2022-11-23 17:16:51 `umpchange_inning` = IF(@umpchange_inning = '', NULL, @umpchange_inning),
- 2022-11-23 17:16:51 `umpchange_position` = IF(@umpchange_position = '', NULL, @umpchange_position),
- 2022-11-23 17:16:51 `umpchange_person_id` = IF(@umpchange_person_id = '', NULL, @umpchange_person_id),
- 2022-11-23 17:16:51 `dummy_id` = IF(@dummy_id = '', NULL, @dummy_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/park.csv' INTO TABLE retrosheet.park
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@park_id, @name, @aka, @city, @state, @start_date, @end_date, @league, @notes)
- 2022-11-23 17:16:51 SET `park_id` = IF(@park_id = '', NULL, @park_id),
- 2022-11-23 17:16:51 `name` = IF(@name = '', NULL, @name),
- 2022-11-23 17:16:51 `aka` = IF(@aka = '', NULL, @aka),
- 2022-11-23 17:16:51 `city` = IF(@city = '', NULL, @city),
- 2022-11-23 17:16:51 `state` = IF(@state = '', NULL, @state),
- 2022-11-23 17:16:51 `start_date` = IF(@start_date = '', NULL, @start_date),
- 2022-11-23 17:16:51 `end_date` = IF(@end_date = '', NULL, @end_date),
- 2022-11-23 17:16:51 `league` = IF(@league = '', NULL, @league),
- 2022-11-23 17:16:51 `notes` = IF(@notes = '', NULL, @notes);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/roster.csv' INTO TABLE retrosheet.roster
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@year, @player_id, @last_name, @first_name, @bats, @throws, @team_id, @position)
- 2022-11-23 17:16:51 SET `year` = IF(@year = '', NULL, @year),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `last_name` = IF(@last_name = '', NULL, @last_name),
- 2022-11-23 17:16:51 `first_name` = IF(@first_name = '', NULL, @first_name),
- 2022-11-23 17:16:51 `bats` = IF(@bats = '', NULL, @bats),
- 2022-11-23 17:16:51 `throws` = IF(@throws = '', NULL, @throws),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `position` = IF(@position = '', NULL, @position);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/schedule.csv' INTO TABLE retrosheet.schedule
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@date, @double_header, @day_of_week, @visiting_team, @visiting_team_league, @visiting_team_game_number, @home_team, @home_team_league, @home_team_game_number, @day_night, @postponement_indicator, @makeup_dates)
- 2022-11-23 17:16:51 SET `date` = IF(@date = '', NULL, @date),
- 2022-11-23 17:16:51 `double_header` = IF(@double_header = '', NULL, @double_header),
- 2022-11-23 17:16:51 `day_of_week` = IF(@day_of_week = '', NULL, @day_of_week),
- 2022-11-23 17:16:51 `visiting_team` = IF(@visiting_team = '', NULL, @visiting_team),
- 2022-11-23 17:16:51 `visiting_team_league` = IF(@visiting_team_league = '', NULL, @visiting_team_league),
- 2022-11-23 17:16:51 `visiting_team_game_number` = IF(@visiting_team_game_number = '', NULL, @visiting_team_game_number),
- 2022-11-23 17:16:51 `home_team` = IF(@home_team = '', NULL, @home_team),
- 2022-11-23 17:16:51 `home_team_league` = IF(@home_team_league = '', NULL, @home_team_league),
- 2022-11-23 17:16:51 `home_team_game_number` = IF(@home_team_game_number = '', NULL, @home_team_game_number),
- 2022-11-23 17:16:51 `day_night` = IF(@day_night = '', NULL, @day_night),
- 2022-11-23 17:16:51 `postponement_indicator` = IF(@postponement_indicator = '', NULL, @postponement_indicator),
- 2022-11-23 17:16:51 `makeup_dates` = IF(@makeup_dates = '', NULL, @makeup_dates);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/code_event.csv' INTO TABLE retrosheet.code_event
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@code, @description)
- 2022-11-23 17:16:51 SET `code` = IF(@code = '', NULL, @code),
- 2022-11-23 17:16:51 `description` = IF(@description = '', NULL, @description);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/code_field_park.csv' INTO TABLE retrosheet.code_field_park
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@code, @description)
- 2022-11-23 17:16:51 SET `code` = IF(@code = '', NULL, @code),
- 2022-11-23 17:16:51 `description` = IF(@description = '', NULL, @description);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/code_method_record.csv' INTO TABLE retrosheet.code_method_record
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@code, @description)
- 2022-11-23 17:16:51 SET `code` = IF(@code = '', NULL, @code),
- 2022-11-23 17:16:51 `description` = IF(@description = '', NULL, @description);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/code_pitches_record.csv' INTO TABLE retrosheet.code_pitches_record
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@code, @description)
- 2022-11-23 17:16:51 SET `code` = IF(@code = '', NULL, @code),
- 2022-11-23 17:16:51 `description` = IF(@description = '', NULL, @description);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/code_precip_park.csv' INTO TABLE retrosheet.code_precip_park
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@code, @description)
- 2022-11-23 17:16:51 SET `code` = IF(@code = '', NULL, @code),
- 2022-11-23 17:16:51 `description` = IF(@description = '', NULL, @description);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/code_sky_park.csv' INTO TABLE retrosheet.code_sky_park
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@code, @description)
- 2022-11-23 17:16:51 SET `code` = IF(@code = '', NULL, @code),
- 2022-11-23 17:16:51 `description` = IF(@description = '', NULL, @description);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/code_wind_direction_park.csv' INTO TABLE retrosheet.code_wind_direction_park
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@code, @description)
- 2022-11-23 17:16:51 SET `code` = IF(@code = '', NULL, @code),
- 2022-11-23 17:16:51 `description` = IF(@description = '', NULL, @description);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/deduced_game.csv' INTO TABLE retrosheet.deduced_game
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@game_id)
- 2022-11-23 17:16:51 SET `game_id` = IF(@game_id = '', NULL, @game_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/game.csv' INTO TABLE retrosheet.game
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@game_id, @game_dt, @game_ct, @game_dy, @start_game_tm, @dh_fl, @daynight_park_cd, @away_team_id, @home_team_id, @park_id, @away_start_pit_id, @home_start_pit_id, @base4_ump_id, @base1_ump_id, @base2_ump_id, @base3_ump_id, @lf_ump_id, @rf_ump_id, @attend_park_ct, @scorer_record_id, @translator_record_id, @inputter_record_id, @input_record_ts, @edit_record_ts, @method_record_cd, @pitches_record_cd, @temp_park_ct, @wind_direction_park_cd, @wind_speed_park_ct, @field_park_cd, @precip_park_cd, @sky_park_cd, @minutes_game_ct, @inn_ct, @away_score_ct, @home_score_ct, @away_hits_ct, @home_hits_ct, @away_err_ct, @home_err_ct, @away_lob_ct, @home_lob_ct, @win_pit_id, @lose_pit_id, @save_pit_id, @gwrbi_bat_id, @away_lineup1_bat_id, @away_lineup1_fld_cd, @away_lineup2_bat_id, @away_lineup2_fld_cd, @away_lineup3_bat_id, @away_lineup3_fld_cd, @away_lineup4_bat_id, @away_lineup4_fld_cd, @away_lineup5_bat_id, @away_lineup5_fld_cd, @away_lineup6_bat_id, @away_lineup6_fld_cd, @away_lineup7_bat_id, @away_lineup7_fld_cd, @away_lineup8_bat_id, @away_lineup8_fld_cd, @away_lineup9_bat_id, @away_lineup9_fld_cd, @home_lineup1_bat_id, @home_lineup1_fld_cd, @home_lineup2_bat_id, @home_lineup2_fld_cd, @home_lineup3_bat_id, @home_lineup3_fld_cd, @home_lineup4_bat_id, @home_lineup4_fld_cd, @home_lineup5_bat_id, @home_lineup5_fld_cd, @home_lineup6_bat_id, @home_lineup6_fld_cd, @home_lineup7_bat_id, @home_lineup7_fld_cd, @home_lineup8_bat_id, @home_lineup8_fld_cd, @home_lineup9_bat_id, @home_lineup9_fld_cd, @away_finish_pit_id, @home_finish_pit_id, @away_team_league_id, @home_team_league_id, @away_team_game_ct, @home_team_game_ct, @outs_ct, @completion_tx, @forfeit_tx, @protest_tx, @away_line_tx, @home_line_tx, @away_ab_ct, @away_2b_ct, @away_3b_ct, @away_hr_ct, @away_bi_ct, @away_sh_ct, @away_sf_ct, @away_hp_ct, @away_bb_ct, @away_ibb_ct, @away_so_ct, @away_sb_ct, @away_cs_ct, @away_gdp_ct, @away_xi_ct, @away_pitcher_ct, @away_er_ct, @away_ter_ct, @away_wp_ct, @away_bk_ct, @away_po_ct, @away_a_ct, @away_pb_ct, @away_dp_ct, @away_tp_ct, @home_ab_ct, @home_2b_ct, @home_3b_ct, @home_hr_ct, @home_bi_ct, @home_sh_ct, @home_sf_ct, @home_hp_ct, @home_bb_ct, @home_ibb_ct, @home_so_ct, @home_sb_ct, @home_cs_ct, @home_gdp_ct, @home_xi_ct, @home_pitcher_ct, @home_er_ct, @home_ter_ct, @home_wp_ct, @home_bk_ct, @home_po_ct, @home_a_ct, @home_pb_ct, @home_dp_ct, @home_tp_ct, @ump_home_name_tx, @ump_1b_name_tx, @ump_2b_name_tx, @ump_3b_name_tx, @ump_lf_name_tx, @ump_rf_name_tx, @away_manager_id, @away_manager_name_tx, @home_manager_id, @home_manager_name_tx, @win_pit_name_tx, @lose_pit_name_tx, @save_pit_name_tx, @goahead_rbi_id, @goahead_rbi_name_tx, @away_lineup1_bat_name_tx, @away_lineup2_bat_name_tx, @away_lineup3_bat_name_tx, @away_lineup4_bat_name_tx, @away_lineup5_bat_name_tx, @away_lineup6_bat_name_tx, @away_lineup7_bat_name_tx, @away_lineup8_bat_name_tx, @away_lineup9_bat_name_tx, @home_lineup1_bat_name_tx, @home_lineup2_bat_name_tx, @home_lineup3_bat_name_tx, @home_lineup4_bat_name_tx, @home_lineup5_bat_name_tx, @home_lineup6_bat_name_tx, @home_lineup7_bat_name_tx, @home_lineup8_bat_name_tx, @home_lineup9_bat_name_tx, @add_info_tx, @acq_info_tx)
- 2022-11-23 17:16:51 SET `game_id` = IF(@game_id = '', NULL, @game_id),
- 2022-11-23 17:16:51 `game_dt` = IF(@game_dt = '', NULL, @game_dt),
- 2022-11-23 17:16:51 `game_ct` = IF(@game_ct = '', NULL, @game_ct),
- 2022-11-23 17:16:51 `game_dy` = IF(@game_dy = '', NULL, @game_dy),
- 2022-11-23 17:16:51 `start_game_tm` = IF(@start_game_tm = '', NULL, @start_game_tm),
- 2022-11-23 17:16:51 `dh_fl` = IF(@dh_fl = '', NULL, @dh_fl),
- 2022-11-23 17:16:51 `daynight_park_cd` = IF(@daynight_park_cd = '', NULL, @daynight_park_cd),
- 2022-11-23 17:16:51 `away_team_id` = IF(@away_team_id = '', NULL, @away_team_id),
- 2022-11-23 17:16:51 `home_team_id` = IF(@home_team_id = '', NULL, @home_team_id),
- 2022-11-23 17:16:51 `park_id` = IF(@park_id = '', NULL, @park_id),
- 2022-11-23 17:16:51 `away_start_pit_id` = IF(@away_start_pit_id = '', NULL, @away_start_pit_id),
- 2022-11-23 17:16:51 `home_start_pit_id` = IF(@home_start_pit_id = '', NULL, @home_start_pit_id),
- 2022-11-23 17:16:51 `base4_ump_id` = IF(@base4_ump_id = '', NULL, @base4_ump_id),
- 2022-11-23 17:16:51 `base1_ump_id` = IF(@base1_ump_id = '', NULL, @base1_ump_id),
- 2022-11-23 17:16:51 `base2_ump_id` = IF(@base2_ump_id = '', NULL, @base2_ump_id),
- 2022-11-23 17:16:51 `base3_ump_id` = IF(@base3_ump_id = '', NULL, @base3_ump_id),
- 2022-11-23 17:16:51 `lf_ump_id` = IF(@lf_ump_id = '', NULL, @lf_ump_id),
- 2022-11-23 17:16:51 `rf_ump_id` = IF(@rf_ump_id = '', NULL, @rf_ump_id),
- 2022-11-23 17:16:51 `attend_park_ct` = IF(@attend_park_ct = '', NULL, @attend_park_ct),
- 2022-11-23 17:16:51 `scorer_record_id` = IF(@scorer_record_id = '', NULL, @scorer_record_id),
- 2022-11-23 17:16:51 `translator_record_id` = IF(@translator_record_id = '', NULL, @translator_record_id),
- 2022-11-23 17:16:51 `inputter_record_id` = IF(@inputter_record_id = '', NULL, @inputter_record_id),
- 2022-11-23 17:16:51 `input_record_ts` = IF(@input_record_ts = '', NULL, @input_record_ts),
- 2022-11-23 17:16:51 `edit_record_ts` = IF(@edit_record_ts = '', NULL, @edit_record_ts),
- 2022-11-23 17:16:51 `method_record_cd` = IF(@method_record_cd = '', NULL, @method_record_cd),
- 2022-11-23 17:16:51 `pitches_record_cd` = IF(@pitches_record_cd = '', NULL, @pitches_record_cd),
- 2022-11-23 17:16:51 `temp_park_ct` = IF(@temp_park_ct = '', NULL, @temp_park_ct),
- 2022-11-23 17:16:51 `wind_direction_park_cd` = IF(@wind_direction_park_cd = '', NULL, @wind_direction_park_cd),
- 2022-11-23 17:16:51 `wind_speed_park_ct` = IF(@wind_speed_park_ct = '', NULL, @wind_speed_park_ct),
- 2022-11-23 17:16:51 `field_park_cd` = IF(@field_park_cd = '', NULL, @field_park_cd),
- 2022-11-23 17:16:51 `precip_park_cd` = IF(@precip_park_cd = '', NULL, @precip_park_cd),
- 2022-11-23 17:16:51 `sky_park_cd` = IF(@sky_park_cd = '', NULL, @sky_park_cd),
- 2022-11-23 17:16:51 `minutes_game_ct` = IF(@minutes_game_ct = '', NULL, @minutes_game_ct),
- 2022-11-23 17:16:51 `inn_ct` = IF(@inn_ct = '', NULL, @inn_ct),
- 2022-11-23 17:16:51 `away_score_ct` = IF(@away_score_ct = '', NULL, @away_score_ct),
- 2022-11-23 17:16:51 `home_score_ct` = IF(@home_score_ct = '', NULL, @home_score_ct),
- 2022-11-23 17:16:51 `away_hits_ct` = IF(@away_hits_ct = '', NULL, @away_hits_ct),
- 2022-11-23 17:16:51 `home_hits_ct` = IF(@home_hits_ct = '', NULL, @home_hits_ct),
- 2022-11-23 17:16:51 `away_err_ct` = IF(@away_err_ct = '', NULL, @away_err_ct),
- 2022-11-23 17:16:51 `home_err_ct` = IF(@home_err_ct = '', NULL, @home_err_ct),
- 2022-11-23 17:16:51 `away_lob_ct` = IF(@away_lob_ct = '', NULL, @away_lob_ct),
- 2022-11-23 17:16:51 `home_lob_ct` = IF(@home_lob_ct = '', NULL, @home_lob_ct),
- 2022-11-23 17:16:51 `win_pit_id` = IF(@win_pit_id = '', NULL, @win_pit_id),
- 2022-11-23 17:16:51 `lose_pit_id` = IF(@lose_pit_id = '', NULL, @lose_pit_id),
- 2022-11-23 17:16:51 `save_pit_id` = IF(@save_pit_id = '', NULL, @save_pit_id),
- 2022-11-23 17:16:51 `gwrbi_bat_id` = IF(@gwrbi_bat_id = '', NULL, @gwrbi_bat_id),
- 2022-11-23 17:16:51 `away_lineup1_bat_id` = IF(@away_lineup1_bat_id = '', NULL, @away_lineup1_bat_id),
- 2022-11-23 17:16:51 `away_lineup1_fld_cd` = IF(@away_lineup1_fld_cd = '', NULL, @away_lineup1_fld_cd),
- 2022-11-23 17:16:51 `away_lineup2_bat_id` = IF(@away_lineup2_bat_id = '', NULL, @away_lineup2_bat_id),
- 2022-11-23 17:16:51 `away_lineup2_fld_cd` = IF(@away_lineup2_fld_cd = '', NULL, @away_lineup2_fld_cd),
- 2022-11-23 17:16:51 `away_lineup3_bat_id` = IF(@away_lineup3_bat_id = '', NULL, @away_lineup3_bat_id),
- 2022-11-23 17:16:51 `away_lineup3_fld_cd` = IF(@away_lineup3_fld_cd = '', NULL, @away_lineup3_fld_cd),
- 2022-11-23 17:16:51 `away_lineup4_bat_id` = IF(@away_lineup4_bat_id = '', NULL, @away_lineup4_bat_id),
- 2022-11-23 17:16:51 `away_lineup4_fld_cd` = IF(@away_lineup4_fld_cd = '', NULL, @away_lineup4_fld_cd),
- 2022-11-23 17:16:51 `away_lineup5_bat_id` = IF(@away_lineup5_bat_id = '', NULL, @away_lineup5_bat_id),
- 2022-11-23 17:16:51 `away_lineup5_fld_cd` = IF(@away_lineup5_fld_cd = '', NULL, @away_lineup5_fld_cd),
- 2022-11-23 17:16:51 `away_lineup6_bat_id` = IF(@away_lineup6_bat_id = '', NULL, @away_lineup6_bat_id),
- 2022-11-23 17:16:51 `away_lineup6_fld_cd` = IF(@away_lineup6_fld_cd = '', NULL, @away_lineup6_fld_cd),
- 2022-11-23 17:16:51 `away_lineup7_bat_id` = IF(@away_lineup7_bat_id = '', NULL, @away_lineup7_bat_id),
- 2022-11-23 17:16:51 `away_lineup7_fld_cd` = IF(@away_lineup7_fld_cd = '', NULL, @away_lineup7_fld_cd),
- 2022-11-23 17:16:51 `away_lineup8_bat_id` = IF(@away_lineup8_bat_id = '', NULL, @away_lineup8_bat_id),
- 2022-11-23 17:16:51 `away_lineup8_fld_cd` = IF(@away_lineup8_fld_cd = '', NULL, @away_lineup8_fld_cd),
- 2022-11-23 17:16:51 `away_lineup9_bat_id` = IF(@away_lineup9_bat_id = '', NULL, @away_lineup9_bat_id),
- 2022-11-23 17:16:51 `away_lineup9_fld_cd` = IF(@away_lineup9_fld_cd = '', NULL, @away_lineup9_fld_cd),
- 2022-11-23 17:16:51 `home_lineup1_bat_id` = IF(@home_lineup1_bat_id = '', NULL, @home_lineup1_bat_id),
- 2022-11-23 17:16:51 `home_lineup1_fld_cd` = IF(@home_lineup1_fld_cd = '', NULL, @home_lineup1_fld_cd),
- 2022-11-23 17:16:51 `home_lineup2_bat_id` = IF(@home_lineup2_bat_id = '', NULL, @home_lineup2_bat_id),
- 2022-11-23 17:16:51 `home_lineup2_fld_cd` = IF(@home_lineup2_fld_cd = '', NULL, @home_lineup2_fld_cd),
- 2022-11-23 17:16:51 `home_lineup3_bat_id` = IF(@home_lineup3_bat_id = '', NULL, @home_lineup3_bat_id),
- 2022-11-23 17:16:51 `home_lineup3_fld_cd` = IF(@home_lineup3_fld_cd = '', NULL, @home_lineup3_fld_cd),
- 2022-11-23 17:16:51 `home_lineup4_bat_id` = IF(@home_lineup4_bat_id = '', NULL, @home_lineup4_bat_id),
- 2022-11-23 17:16:51 `home_lineup4_fld_cd` = IF(@home_lineup4_fld_cd = '', NULL, @home_lineup4_fld_cd),
- 2022-11-23 17:16:51 `home_lineup5_bat_id` = IF(@home_lineup5_bat_id = '', NULL, @home_lineup5_bat_id),
- 2022-11-23 17:16:51 `home_lineup5_fld_cd` = IF(@home_lineup5_fld_cd = '', NULL, @home_lineup5_fld_cd),
- 2022-11-23 17:16:51 `home_lineup6_bat_id` = IF(@home_lineup6_bat_id = '', NULL, @home_lineup6_bat_id),
- 2022-11-23 17:16:51 `home_lineup6_fld_cd` = IF(@home_lineup6_fld_cd = '', NULL, @home_lineup6_fld_cd),
- 2022-11-23 17:16:51 `home_lineup7_bat_id` = IF(@home_lineup7_bat_id = '', NULL, @home_lineup7_bat_id),
- 2022-11-23 17:16:51 `home_lineup7_fld_cd` = IF(@home_lineup7_fld_cd = '', NULL, @home_lineup7_fld_cd),
- 2022-11-23 17:16:51 `home_lineup8_bat_id` = IF(@home_lineup8_bat_id = '', NULL, @home_lineup8_bat_id),
- 2022-11-23 17:16:51 `home_lineup8_fld_cd` = IF(@home_lineup8_fld_cd = '', NULL, @home_lineup8_fld_cd),
- 2022-11-23 17:16:51 `home_lineup9_bat_id` = IF(@home_lineup9_bat_id = '', NULL, @home_lineup9_bat_id),
- 2022-11-23 17:16:51 `home_lineup9_fld_cd` = IF(@home_lineup9_fld_cd = '', NULL, @home_lineup9_fld_cd),
- 2022-11-23 17:16:51 `away_finish_pit_id` = IF(@away_finish_pit_id = '', NULL, @away_finish_pit_id),
- 2022-11-23 17:16:51 `home_finish_pit_id` = IF(@home_finish_pit_id = '', NULL, @home_finish_pit_id),
- 2022-11-23 17:16:51 `away_team_league_id` = IF(@away_team_league_id = '', NULL, @away_team_league_id),
- 2022-11-23 17:16:51 `home_team_league_id` = IF(@home_team_league_id = '', NULL, @home_team_league_id),
- 2022-11-23 17:16:51 `away_team_game_ct` = IF(@away_team_game_ct = '', NULL, @away_team_game_ct),
- 2022-11-23 17:16:51 `home_team_game_ct` = IF(@home_team_game_ct = '', NULL, @home_team_game_ct),
- 2022-11-23 17:16:51 `outs_ct` = IF(@outs_ct = '', NULL, @outs_ct),
- 2022-11-23 17:16:51 `completion_tx` = IF(@completion_tx = '', NULL, @completion_tx),
- 2022-11-23 17:16:51 `forfeit_tx` = IF(@forfeit_tx = '', NULL, @forfeit_tx),
- 2022-11-23 17:16:51 `protest_tx` = IF(@protest_tx = '', NULL, @protest_tx),
- 2022-11-23 17:16:51 `away_line_tx` = IF(@away_line_tx = '', NULL, @away_line_tx),
- 2022-11-23 17:16:51 `home_line_tx` = IF(@home_line_tx = '', NULL, @home_line_tx),
- 2022-11-23 17:16:51 `away_ab_ct` = IF(@away_ab_ct = '', NULL, @away_ab_ct),
- 2022-11-23 17:16:51 `away_2b_ct` = IF(@away_2b_ct = '', NULL, @away_2b_ct),
- 2022-11-23 17:16:51 `away_3b_ct` = IF(@away_3b_ct = '', NULL, @away_3b_ct),
- 2022-11-23 17:16:51 `away_hr_ct` = IF(@away_hr_ct = '', NULL, @away_hr_ct),
- 2022-11-23 17:16:51 `away_bi_ct` = IF(@away_bi_ct = '', NULL, @away_bi_ct),
- 2022-11-23 17:16:51 `away_sh_ct` = IF(@away_sh_ct = '', NULL, @away_sh_ct),
- 2022-11-23 17:16:51 `away_sf_ct` = IF(@away_sf_ct = '', NULL, @away_sf_ct),
- 2022-11-23 17:16:51 `away_hp_ct` = IF(@away_hp_ct = '', NULL, @away_hp_ct),
- 2022-11-23 17:16:51 `away_bb_ct` = IF(@away_bb_ct = '', NULL, @away_bb_ct),
- 2022-11-23 17:16:51 `away_ibb_ct` = IF(@away_ibb_ct = '', NULL, @away_ibb_ct),
- 2022-11-23 17:16:51 `away_so_ct` = IF(@away_so_ct = '', NULL, @away_so_ct),
- 2022-11-23 17:16:51 `away_sb_ct` = IF(@away_sb_ct = '', NULL, @away_sb_ct),
- 2022-11-23 17:16:51 `away_cs_ct` = IF(@away_cs_ct = '', NULL, @away_cs_ct),
- 2022-11-23 17:16:51 `away_gdp_ct` = IF(@away_gdp_ct = '', NULL, @away_gdp_ct),
- 2022-11-23 17:16:51 `away_xi_ct` = IF(@away_xi_ct = '', NULL, @away_xi_ct),
- 2022-11-23 17:16:51 `away_pitcher_ct` = IF(@away_pitcher_ct = '', NULL, @away_pitcher_ct),
- 2022-11-23 17:16:51 `away_er_ct` = IF(@away_er_ct = '', NULL, @away_er_ct),
- 2022-11-23 17:16:51 `away_ter_ct` = IF(@away_ter_ct = '', NULL, @away_ter_ct),
- 2022-11-23 17:16:51 `away_wp_ct` = IF(@away_wp_ct = '', NULL, @away_wp_ct),
- 2022-11-23 17:16:51 `away_bk_ct` = IF(@away_bk_ct = '', NULL, @away_bk_ct),
- 2022-11-23 17:16:51 `away_po_ct` = IF(@away_po_ct = '', NULL, @away_po_ct),
- 2022-11-23 17:16:51 `away_a_ct` = IF(@away_a_ct = '', NULL, @away_a_ct),
- 2022-11-23 17:16:51 `away_pb_ct` = IF(@away_pb_ct = '', NULL, @away_pb_ct),
- 2022-11-23 17:16:51 `away_dp_ct` = IF(@away_dp_ct = '', NULL, @away_dp_ct),
- 2022-11-23 17:16:51 `away_tp_ct` = IF(@away_tp_ct = '', NULL, @away_tp_ct),
- 2022-11-23 17:16:51 `home_ab_ct` = IF(@home_ab_ct = '', NULL, @home_ab_ct),
- 2022-11-23 17:16:51 `home_2b_ct` = IF(@home_2b_ct = '', NULL, @home_2b_ct),
- 2022-11-23 17:16:51 `home_3b_ct` = IF(@home_3b_ct = '', NULL, @home_3b_ct),
- 2022-11-23 17:16:51 `home_hr_ct` = IF(@home_hr_ct = '', NULL, @home_hr_ct),
- 2022-11-23 17:16:51 `home_bi_ct` = IF(@home_bi_ct = '', NULL, @home_bi_ct),
- 2022-11-23 17:16:51 `home_sh_ct` = IF(@home_sh_ct = '', NULL, @home_sh_ct),
- 2022-11-23 17:16:51 `home_sf_ct` = IF(@home_sf_ct = '', NULL, @home_sf_ct),
- 2022-11-23 17:16:51 `home_hp_ct` = IF(@home_hp_ct = '', NULL, @home_hp_ct),
- 2022-11-23 17:16:51 `home_bb_ct` = IF(@home_bb_ct = '', NULL, @home_bb_ct),
- 2022-11-23 17:16:51 `home_ibb_ct` = IF(@home_ibb_ct = '', NULL, @home_ibb_ct),
- 2022-11-23 17:16:51 `home_so_ct` = IF(@home_so_ct = '', NULL, @home_so_ct),
- 2022-11-23 17:16:51 `home_sb_ct` = IF(@home_sb_ct = '', NULL, @home_sb_ct),
- 2022-11-23 17:16:51 `home_cs_ct` = IF(@home_cs_ct = '', NULL, @home_cs_ct),
- 2022-11-23 17:16:51 `home_gdp_ct` = IF(@home_gdp_ct = '', NULL, @home_gdp_ct),
- 2022-11-23 17:16:51 `home_xi_ct` = IF(@home_xi_ct = '', NULL, @home_xi_ct),
- 2022-11-23 17:16:51 `home_pitcher_ct` = IF(@home_pitcher_ct = '', NULL, @home_pitcher_ct),
- 2022-11-23 17:16:51 `home_er_ct` = IF(@home_er_ct = '', NULL, @home_er_ct),
- 2022-11-23 17:16:51 `home_ter_ct` = IF(@home_ter_ct = '', NULL, @home_ter_ct),
- 2022-11-23 17:16:51 `home_wp_ct` = IF(@home_wp_ct = '', NULL, @home_wp_ct),
- 2022-11-23 17:16:51 `home_bk_ct` = IF(@home_bk_ct = '', NULL, @home_bk_ct),
- 2022-11-23 17:16:51 `home_po_ct` = IF(@home_po_ct = '', NULL, @home_po_ct),
- 2022-11-23 17:16:51 `home_a_ct` = IF(@home_a_ct = '', NULL, @home_a_ct),
- 2022-11-23 17:16:51 `home_pb_ct` = IF(@home_pb_ct = '', NULL, @home_pb_ct),
- 2022-11-23 17:16:51 `home_dp_ct` = IF(@home_dp_ct = '', NULL, @home_dp_ct),
- 2022-11-23 17:16:51 `home_tp_ct` = IF(@home_tp_ct = '', NULL, @home_tp_ct),
- 2022-11-23 17:16:51 `ump_home_name_tx` = IF(@ump_home_name_tx = '', NULL, @ump_home_name_tx),
- 2022-11-23 17:16:51 `ump_1b_name_tx` = IF(@ump_1b_name_tx = '', NULL, @ump_1b_name_tx),
- 2022-11-23 17:16:51 `ump_2b_name_tx` = IF(@ump_2b_name_tx = '', NULL, @ump_2b_name_tx),
- 2022-11-23 17:16:51 `ump_3b_name_tx` = IF(@ump_3b_name_tx = '', NULL, @ump_3b_name_tx),
- 2022-11-23 17:16:51 `ump_lf_name_tx` = IF(@ump_lf_name_tx = '', NULL, @ump_lf_name_tx),
- 2022-11-23 17:16:51 `ump_rf_name_tx` = IF(@ump_rf_name_tx = '', NULL, @ump_rf_name_tx),
- 2022-11-23 17:16:51 `away_manager_id` = IF(@away_manager_id = '', NULL, @away_manager_id),
- 2022-11-23 17:16:51 `away_manager_name_tx` = IF(@away_manager_name_tx = '', NULL, @away_manager_name_tx),
- 2022-11-23 17:16:51 `home_manager_id` = IF(@home_manager_id = '', NULL, @home_manager_id),
- 2022-11-23 17:16:51 `home_manager_name_tx` = IF(@home_manager_name_tx = '', NULL, @home_manager_name_tx),
- 2022-11-23 17:16:51 `win_pit_name_tx` = IF(@win_pit_name_tx = '', NULL, @win_pit_name_tx),
- 2022-11-23 17:16:51 `lose_pit_name_tx` = IF(@lose_pit_name_tx = '', NULL, @lose_pit_name_tx),
- 2022-11-23 17:16:51 `save_pit_name_tx` = IF(@save_pit_name_tx = '', NULL, @save_pit_name_tx),
- 2022-11-23 17:16:51 `goahead_rbi_id` = IF(@goahead_rbi_id = '', NULL, @goahead_rbi_id),
- 2022-11-23 17:16:51 `goahead_rbi_name_tx` = IF(@goahead_rbi_name_tx = '', NULL, @goahead_rbi_name_tx),
- 2022-11-23 17:16:51 `away_lineup1_bat_name_tx` = IF(@away_lineup1_bat_name_tx = '', NULL, @away_lineup1_bat_name_tx),
- 2022-11-23 17:16:51 `away_lineup2_bat_name_tx` = IF(@away_lineup2_bat_name_tx = '', NULL, @away_lineup2_bat_name_tx),
- 2022-11-23 17:16:51 `away_lineup3_bat_name_tx` = IF(@away_lineup3_bat_name_tx = '', NULL, @away_lineup3_bat_name_tx),
- 2022-11-23 17:16:51 `away_lineup4_bat_name_tx` = IF(@away_lineup4_bat_name_tx = '', NULL, @away_lineup4_bat_name_tx),
- 2022-11-23 17:16:51 `away_lineup5_bat_name_tx` = IF(@away_lineup5_bat_name_tx = '', NULL, @away_lineup5_bat_name_tx),
- 2022-11-23 17:16:51 `away_lineup6_bat_name_tx` = IF(@away_lineup6_bat_name_tx = '', NULL, @away_lineup6_bat_name_tx),
- 2022-11-23 17:16:51 `away_lineup7_bat_name_tx` = IF(@away_lineup7_bat_name_tx = '', NULL, @away_lineup7_bat_name_tx),
- 2022-11-23 17:16:51 `away_lineup8_bat_name_tx` = IF(@away_lineup8_bat_name_tx = '', NULL, @away_lineup8_bat_name_tx),
- 2022-11-23 17:16:51 `away_lineup9_bat_name_tx` = IF(@away_lineup9_bat_name_tx = '', NULL, @away_lineup9_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup1_bat_name_tx` = IF(@home_lineup1_bat_name_tx = '', NULL, @home_lineup1_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup2_bat_name_tx` = IF(@home_lineup2_bat_name_tx = '', NULL, @home_lineup2_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup3_bat_name_tx` = IF(@home_lineup3_bat_name_tx = '', NULL, @home_lineup3_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup4_bat_name_tx` = IF(@home_lineup4_bat_name_tx = '', NULL, @home_lineup4_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup5_bat_name_tx` = IF(@home_lineup5_bat_name_tx = '', NULL, @home_lineup5_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup6_bat_name_tx` = IF(@home_lineup6_bat_name_tx = '', NULL, @home_lineup6_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup7_bat_name_tx` = IF(@home_lineup7_bat_name_tx = '', NULL, @home_lineup7_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup8_bat_name_tx` = IF(@home_lineup8_bat_name_tx = '', NULL, @home_lineup8_bat_name_tx),
- 2022-11-23 17:16:51 `home_lineup9_bat_name_tx` = IF(@home_lineup9_bat_name_tx = '', NULL, @home_lineup9_bat_name_tx),
- 2022-11-23 17:16:51 `add_info_tx` = IF(@add_info_tx = '', NULL, @add_info_tx),
- 2022-11-23 17:16:51 `acq_info_tx` = IF(@acq_info_tx = '', NULL, @acq_info_tx);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/gamelog.csv' INTO TABLE retrosheet.gamelog
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@date, @double_header, @day_of_week, @visiting_team, @visiting_team_league, @visiting_team_game_number, @home_team, @home_team_league, @home_team_game_number, @visitor_runs_scored, @home_runs_score, @length_in_outs, @day_night, @completion_info, @forfeit_info, @protest_info, @park_id, @attendance, @duration, @vistor_line_score, @home_line_score, @visitor_ab, @visitor_h, @visitor_d, @visitor_t, @visitor_hr, @visitor_rbi, @visitor_sh, @visitor_sf, @visitor_hbp, @visitor_bb, @visitor_ibb, @visitor_k, @visitor_sb, @visitor_cs, @visitor_gdp, @visitor_ci, @visitor_lob, @visitor_pitchers, @visitor_er, @visitor_ter, @visitor_wp, @visitor_balks, @visitor_po, @visitor_a, @visitor_e, @visitor_passed, @visitor_db, @visitor_tp, @home_ab, @home_h, @home_d, @home_t, @home_hr, @home_rbi, @home_sh, @home_sf, @home_hbp, @home_bb, @home_ibb, @home_k, @home_sb, @home_cs, @home_gdp, @home_ci, @home_lob, @home_pitchers, @home_er, @home_ter, @home_wp, @home_balks, @home_po, @home_a, @home_e, @home_passed, @home_db, @home_tp, @umpire_h_id, @umpire_h_name, @umpire_1b_id, @umpire_1b_name, @umpire_2b_id, @umpire_2b_name, @umpire_3b_id, @umpire_3b_name, @umpire_lf_id, @umpire_lf_name, @umpire_rf_id, @umpire_rf_name, @visitor_manager_id, @visitor_manager_name, @home_manager_id, @home_manager_name, @winning_pitcher_id, @winning_pitcher_name, @losing_pitcher_id, @losing_pitcher_name, @saving_pitcher_id, @saving_pitcher_name, @game_winning_rbi_id, @game_winning_rbi_name, @visitor_starting_pitcher_id, @visitor_starting_pitcher_name, @home_starting_pitcher_id, @home_starting_pitcher_name, @visitor_batting_1_player_id, @visitor_batting_1_name, @visitor_batting_1_position, @visitor_batting_2_player_id, @visitor_batting_2_name, @visitor_batting_2_position, @visitor_batting_3_player_id, @visitor_batting_3_name, @visitor_batting_3_position, @visitor_batting_4_player_id, @visitor_batting_4_name, @visitor_batting_4_position, @visitor_batting_5_player_id, @visitor_batting_5_name, @visitor_batting_5_position, @visitor_batting_6_player_id, @visitor_batting_6_name, @visitor_batting_6_position, @visitor_batting_7_player_id, @visitor_batting_7_name, @visitor_batting_7_position, @visitor_batting_8_player_id, @visitor_batting_8_name, @visitor_batting_8_position, @visitor_batting_9_player_id, @visitor_batting_9_name, @visitor_batting_9_position, @home_batting_1_player_id, @home_batting_1_name, @home_batting_1_position, @home_batting_2_player_id, @home_batting_2_name, @home_batting_2_position, @home_batting_3_player_id, @home_batting_3_name, @home_batting_3_position, @home_batting_4_player_id, @home_batting_4_name, @home_batting_4_position, @home_batting_5_player_id, @home_batting_5_name, @home_batting_5_position, @home_batting_6_player_id, @home_batting_6_name, @home_batting_6_position, @home_batting_7_player_id, @home_batting_7_name, @home_batting_7_position, @home_batting_8_player_id, @home_batting_8_name, @home_batting_8_position, @home_batting_9_player_id, @home_batting_9_name, @home_batting_9_position, @additional_info, @acquisition_info)
- 2022-11-23 17:16:51 SET `date` = IF(@date = '', NULL, @date),
- 2022-11-23 17:16:51 `double_header` = IF(@double_header = '', NULL, @double_header),
- 2022-11-23 17:16:51 `day_of_week` = IF(@day_of_week = '', NULL, @day_of_week),
- 2022-11-23 17:16:51 `visiting_team` = IF(@visiting_team = '', NULL, @visiting_team),
- 2022-11-23 17:16:51 `visiting_team_league` = IF(@visiting_team_league = '', NULL, @visiting_team_league),
- 2022-11-23 17:16:51 `visiting_team_game_number` = IF(@visiting_team_game_number = '', NULL, @visiting_team_game_number),
- 2022-11-23 17:16:51 `home_team` = IF(@home_team = '', NULL, @home_team),
- 2022-11-23 17:16:51 `home_team_league` = IF(@home_team_league = '', NULL, @home_team_league),
- 2022-11-23 17:16:51 `home_team_game_number` = IF(@home_team_game_number = '', NULL, @home_team_game_number),
- 2022-11-23 17:16:51 `visitor_runs_scored` = IF(@visitor_runs_scored = '', NULL, @visitor_runs_scored),
- 2022-11-23 17:16:51 `home_runs_score` = IF(@home_runs_score = '', NULL, @home_runs_score),
- 2022-11-23 17:16:51 `length_in_outs` = IF(@length_in_outs = '', NULL, @length_in_outs),
- 2022-11-23 17:16:51 `day_night` = IF(@day_night = '', NULL, @day_night),
- 2022-11-23 17:16:51 `completion_info` = IF(@completion_info = '', NULL, @completion_info),
- 2022-11-23 17:16:51 `forfeit_info` = IF(@forfeit_info = '', NULL, @forfeit_info),
- 2022-11-23 17:16:51 `protest_info` = IF(@protest_info = '', NULL, @protest_info),
- 2022-11-23 17:16:51 `park_id` = IF(@park_id = '', NULL, @park_id),
- 2022-11-23 17:16:51 `attendance` = IF(@attendance = '', NULL, @attendance),
- 2022-11-23 17:16:51 `duration` = IF(@duration = '', NULL, @duration),
- 2022-11-23 17:16:51 `vistor_line_score` = IF(@vistor_line_score = '', NULL, @vistor_line_score),
- 2022-11-23 17:16:51 `home_line_score` = IF(@home_line_score = '', NULL, @home_line_score),
- 2022-11-23 17:16:51 `visitor_ab` = IF(@visitor_ab = '', NULL, @visitor_ab),
- 2022-11-23 17:16:51 `visitor_h` = IF(@visitor_h = '', NULL, @visitor_h),
- 2022-11-23 17:16:51 `visitor_d` = IF(@visitor_d = '', NULL, @visitor_d),
- 2022-11-23 17:16:51 `visitor_t` = IF(@visitor_t = '', NULL, @visitor_t),
- 2022-11-23 17:16:51 `visitor_hr` = IF(@visitor_hr = '', NULL, @visitor_hr),
- 2022-11-23 17:16:51 `visitor_rbi` = IF(@visitor_rbi = '', NULL, @visitor_rbi),
- 2022-11-23 17:16:51 `visitor_sh` = IF(@visitor_sh = '', NULL, @visitor_sh),
- 2022-11-23 17:16:51 `visitor_sf` = IF(@visitor_sf = '', NULL, @visitor_sf),
- 2022-11-23 17:16:51 `visitor_hbp` = IF(@visitor_hbp = '', NULL, @visitor_hbp),
- 2022-11-23 17:16:51 `visitor_bb` = IF(@visitor_bb = '', NULL, @visitor_bb),
- 2022-11-23 17:16:51 `visitor_ibb` = IF(@visitor_ibb = '', NULL, @visitor_ibb),
- 2022-11-23 17:16:51 `visitor_k` = IF(@visitor_k = '', NULL, @visitor_k),
- 2022-11-23 17:16:51 `visitor_sb` = IF(@visitor_sb = '', NULL, @visitor_sb),
- 2022-11-23 17:16:51 `visitor_cs` = IF(@visitor_cs = '', NULL, @visitor_cs),
- 2022-11-23 17:16:51 `visitor_gdp` = IF(@visitor_gdp = '', NULL, @visitor_gdp),
- 2022-11-23 17:16:51 `visitor_ci` = IF(@visitor_ci = '', NULL, @visitor_ci),
- 2022-11-23 17:16:51 `visitor_lob` = IF(@visitor_lob = '', NULL, @visitor_lob),
- 2022-11-23 17:16:51 `visitor_pitchers` = IF(@visitor_pitchers = '', NULL, @visitor_pitchers),
- 2022-11-23 17:16:51 `visitor_er` = IF(@visitor_er = '', NULL, @visitor_er),
- 2022-11-23 17:16:51 `visitor_ter` = IF(@visitor_ter = '', NULL, @visitor_ter),
- 2022-11-23 17:16:51 `visitor_wp` = IF(@visitor_wp = '', NULL, @visitor_wp),
- 2022-11-23 17:16:51 `visitor_balks` = IF(@visitor_balks = '', NULL, @visitor_balks),
- 2022-11-23 17:16:51 `visitor_po` = IF(@visitor_po = '', NULL, @visitor_po),
- 2022-11-23 17:16:51 `visitor_a` = IF(@visitor_a = '', NULL, @visitor_a),
- 2022-11-23 17:16:51 `visitor_e` = IF(@visitor_e = '', NULL, @visitor_e),
- 2022-11-23 17:16:51 `visitor_passed` = IF(@visitor_passed = '', NULL, @visitor_passed),
- 2022-11-23 17:16:51 `visitor_db` = IF(@visitor_db = '', NULL, @visitor_db),
- 2022-11-23 17:16:51 `visitor_tp` = IF(@visitor_tp = '', NULL, @visitor_tp),
- 2022-11-23 17:16:51 `home_ab` = IF(@home_ab = '', NULL, @home_ab),
- 2022-11-23 17:16:51 `home_h` = IF(@home_h = '', NULL, @home_h),
- 2022-11-23 17:16:51 `home_d` = IF(@home_d = '', NULL, @home_d),
- 2022-11-23 17:16:51 `home_t` = IF(@home_t = '', NULL, @home_t),
- 2022-11-23 17:16:51 `home_hr` = IF(@home_hr = '', NULL, @home_hr),
- 2022-11-23 17:16:51 `home_rbi` = IF(@home_rbi = '', NULL, @home_rbi),
- 2022-11-23 17:16:51 `home_sh` = IF(@home_sh = '', NULL, @home_sh),
- 2022-11-23 17:16:51 `home_sf` = IF(@home_sf = '', NULL, @home_sf),
- 2022-11-23 17:16:51 `home_hbp` = IF(@home_hbp = '', NULL, @home_hbp),
- 2022-11-23 17:16:51 `home_bb` = IF(@home_bb = '', NULL, @home_bb),
- 2022-11-23 17:16:51 `home_ibb` = IF(@home_ibb = '', NULL, @home_ibb),
- 2022-11-23 17:16:51 `home_k` = IF(@home_k = '', NULL, @home_k),
- 2022-11-23 17:16:51 `home_sb` = IF(@home_sb = '', NULL, @home_sb),
- 2022-11-23 17:16:51 `home_cs` = IF(@home_cs = '', NULL, @home_cs),
- 2022-11-23 17:16:51 `home_gdp` = IF(@home_gdp = '', NULL, @home_gdp),
- 2022-11-23 17:16:51 `home_ci` = IF(@home_ci = '', NULL, @home_ci),
- 2022-11-23 17:16:51 `home_lob` = IF(@home_lob = '', NULL, @home_lob),
- 2022-11-23 17:16:51 `home_pitchers` = IF(@home_pitchers = '', NULL, @home_pitchers),
- 2022-11-23 17:16:51 `home_er` = IF(@home_er = '', NULL, @home_er),
- 2022-11-23 17:16:51 `home_ter` = IF(@home_ter = '', NULL, @home_ter),
- 2022-11-23 17:16:51 `home_wp` = IF(@home_wp = '', NULL, @home_wp),
- 2022-11-23 17:16:51 `home_balks` = IF(@home_balks = '', NULL, @home_balks),
- 2022-11-23 17:16:51 `home_po` = IF(@home_po = '', NULL, @home_po),
- 2022-11-23 17:16:51 `home_a` = IF(@home_a = '', NULL, @home_a),
- 2022-11-23 17:16:51 `home_e` = IF(@home_e = '', NULL, @home_e),
- 2022-11-23 17:16:51 `home_passed` = IF(@home_passed = '', NULL, @home_passed),
- 2022-11-23 17:16:51 `home_db` = IF(@home_db = '', NULL, @home_db),
- 2022-11-23 17:16:51 `home_tp` = IF(@home_tp = '', NULL, @home_tp),
- 2022-11-23 17:16:51 `umpire_h_id` = IF(@umpire_h_id = '', NULL, @umpire_h_id),
- 2022-11-23 17:16:51 `umpire_h_name` = IF(@umpire_h_name = '', NULL, @umpire_h_name),
- 2022-11-23 17:16:51 `umpire_1b_id` = IF(@umpire_1b_id = '', NULL, @umpire_1b_id),
- 2022-11-23 17:16:51 `umpire_1b_name` = IF(@umpire_1b_name = '', NULL, @umpire_1b_name),
- 2022-11-23 17:16:51 `umpire_2b_id` = IF(@umpire_2b_id = '', NULL, @umpire_2b_id),
- 2022-11-23 17:16:51 `umpire_2b_name` = IF(@umpire_2b_name = '', NULL, @umpire_2b_name),
- 2022-11-23 17:16:51 `umpire_3b_id` = IF(@umpire_3b_id = '', NULL, @umpire_3b_id),
- 2022-11-23 17:16:51 `umpire_3b_name` = IF(@umpire_3b_name = '', NULL, @umpire_3b_name),
- 2022-11-23 17:16:51 `umpire_lf_id` = IF(@umpire_lf_id = '', NULL, @umpire_lf_id),
- 2022-11-23 17:16:51 `umpire_lf_name` = IF(@umpire_lf_name = '', NULL, @umpire_lf_name),
- 2022-11-23 17:16:51 `umpire_rf_id` = IF(@umpire_rf_id = '', NULL, @umpire_rf_id),
- 2022-11-23 17:16:51 `umpire_rf_name` = IF(@umpire_rf_name = '', NULL, @umpire_rf_name),
- 2022-11-23 17:16:51 `visitor_manager_id` = IF(@visitor_manager_id = '', NULL, @visitor_manager_id),
- 2022-11-23 17:16:51 `visitor_manager_name` = IF(@visitor_manager_name = '', NULL, @visitor_manager_name),
- 2022-11-23 17:16:51 `home_manager_id` = IF(@home_manager_id = '', NULL, @home_manager_id),
- 2022-11-23 17:16:51 `home_manager_name` = IF(@home_manager_name = '', NULL, @home_manager_name),
- 2022-11-23 17:16:51 `winning_pitcher_id` = IF(@winning_pitcher_id = '', NULL, @winning_pitcher_id),
- 2022-11-23 17:16:51 `winning_pitcher_name` = IF(@winning_pitcher_name = '', NULL, @winning_pitcher_name),
- 2022-11-23 17:16:51 `losing_pitcher_id` = IF(@losing_pitcher_id = '', NULL, @losing_pitcher_id),
- 2022-11-23 17:16:51 `losing_pitcher_name` = IF(@losing_pitcher_name = '', NULL, @losing_pitcher_name),
- 2022-11-23 17:16:51 `saving_pitcher_id` = IF(@saving_pitcher_id = '', NULL, @saving_pitcher_id),
- 2022-11-23 17:16:51 `saving_pitcher_name` = IF(@saving_pitcher_name = '', NULL, @saving_pitcher_name),
- 2022-11-23 17:16:51 `game_winning_rbi_id` = IF(@game_winning_rbi_id = '', NULL, @game_winning_rbi_id),
- 2022-11-23 17:16:51 `game_winning_rbi_name` = IF(@game_winning_rbi_name = '', NULL, @game_winning_rbi_name),
- 2022-11-23 17:16:51 `visitor_starting_pitcher_id` = IF(@visitor_starting_pitcher_id = '', NULL, @visitor_starting_pitcher_id),
- 2022-11-23 17:16:51 `visitor_starting_pitcher_name` = IF(@visitor_starting_pitcher_name = '', NULL, @visitor_starting_pitcher_name),
- 2022-11-23 17:16:51 `home_starting_pitcher_id` = IF(@home_starting_pitcher_id = '', NULL, @home_starting_pitcher_id),
- 2022-11-23 17:16:51 `home_starting_pitcher_name` = IF(@home_starting_pitcher_name = '', NULL, @home_starting_pitcher_name),
- 2022-11-23 17:16:51 `visitor_batting_1_player_id` = IF(@visitor_batting_1_player_id = '', NULL, @visitor_batting_1_player_id),
- 2022-11-23 17:16:51 `visitor_batting_1_name` = IF(@visitor_batting_1_name = '', NULL, @visitor_batting_1_name),
- 2022-11-23 17:16:51 `visitor_batting_1_position` = IF(@visitor_batting_1_position = '', NULL, @visitor_batting_1_position),
- 2022-11-23 17:16:51 `visitor_batting_2_player_id` = IF(@visitor_batting_2_player_id = '', NULL, @visitor_batting_2_player_id),
- 2022-11-23 17:16:51 `visitor_batting_2_name` = IF(@visitor_batting_2_name = '', NULL, @visitor_batting_2_name),
- 2022-11-23 17:16:51 `visitor_batting_2_position` = IF(@visitor_batting_2_position = '', NULL, @visitor_batting_2_position),
- 2022-11-23 17:16:51 `visitor_batting_3_player_id` = IF(@visitor_batting_3_player_id = '', NULL, @visitor_batting_3_player_id),
- 2022-11-23 17:16:51 `visitor_batting_3_name` = IF(@visitor_batting_3_name = '', NULL, @visitor_batting_3_name),
- 2022-11-23 17:16:51 `visitor_batting_3_position` = IF(@visitor_batting_3_position = '', NULL, @visitor_batting_3_position),
- 2022-11-23 17:16:51 `visitor_batting_4_player_id` = IF(@visitor_batting_4_player_id = '', NULL, @visitor_batting_4_player_id),
- 2022-11-23 17:16:51 `visitor_batting_4_name` = IF(@visitor_batting_4_name = '', NULL, @visitor_batting_4_name),
- 2022-11-23 17:16:51 `visitor_batting_4_position` = IF(@visitor_batting_4_position = '', NULL, @visitor_batting_4_position),
- 2022-11-23 17:16:51 `visitor_batting_5_player_id` = IF(@visitor_batting_5_player_id = '', NULL, @visitor_batting_5_player_id),
- 2022-11-23 17:16:51 `visitor_batting_5_name` = IF(@visitor_batting_5_name = '', NULL, @visitor_batting_5_name),
- 2022-11-23 17:16:51 `visitor_batting_5_position` = IF(@visitor_batting_5_position = '', NULL, @visitor_batting_5_position),
- 2022-11-23 17:16:51 `visitor_batting_6_player_id` = IF(@visitor_batting_6_player_id = '', NULL, @visitor_batting_6_player_id),
- 2022-11-23 17:16:51 `visitor_batting_6_name` = IF(@visitor_batting_6_name = '', NULL, @visitor_batting_6_name),
- 2022-11-23 17:16:51 `visitor_batting_6_position` = IF(@visitor_batting_6_position = '', NULL, @visitor_batting_6_position),
- 2022-11-23 17:16:51 `visitor_batting_7_player_id` = IF(@visitor_batting_7_player_id = '', NULL, @visitor_batting_7_player_id),
- 2022-11-23 17:16:51 `visitor_batting_7_name` = IF(@visitor_batting_7_name = '', NULL, @visitor_batting_7_name),
- 2022-11-23 17:16:51 `visitor_batting_7_position` = IF(@visitor_batting_7_position = '', NULL, @visitor_batting_7_position),
- 2022-11-23 17:16:51 `visitor_batting_8_player_id` = IF(@visitor_batting_8_player_id = '', NULL, @visitor_batting_8_player_id),
- 2022-11-23 17:16:51 `visitor_batting_8_name` = IF(@visitor_batting_8_name = '', NULL, @visitor_batting_8_name),
- 2022-11-23 17:16:51 `visitor_batting_8_position` = IF(@visitor_batting_8_position = '', NULL, @visitor_batting_8_position),
- 2022-11-23 17:16:51 `visitor_batting_9_player_id` = IF(@visitor_batting_9_player_id = '', NULL, @visitor_batting_9_player_id),
- 2022-11-23 17:16:51 `visitor_batting_9_name` = IF(@visitor_batting_9_name = '', NULL, @visitor_batting_9_name),
- 2022-11-23 17:16:51 `visitor_batting_9_position` = IF(@visitor_batting_9_position = '', NULL, @visitor_batting_9_position),
- 2022-11-23 17:16:51 `home_batting_1_player_id` = IF(@home_batting_1_player_id = '', NULL, @home_batting_1_player_id),
- 2022-11-23 17:16:51 `home_batting_1_name` = IF(@home_batting_1_name = '', NULL, @home_batting_1_name),
- 2022-11-23 17:16:51 `home_batting_1_position` = IF(@home_batting_1_position = '', NULL, @home_batting_1_position),
- 2022-11-23 17:16:51 `home_batting_2_player_id` = IF(@home_batting_2_player_id = '', NULL, @home_batting_2_player_id),
- 2022-11-23 17:16:51 `home_batting_2_name` = IF(@home_batting_2_name = '', NULL, @home_batting_2_name),
- 2022-11-23 17:16:51 `home_batting_2_position` = IF(@home_batting_2_position = '', NULL, @home_batting_2_position),
- 2022-11-23 17:16:51 `home_batting_3_player_id` = IF(@home_batting_3_player_id = '', NULL, @home_batting_3_player_id),
- 2022-11-23 17:16:51 `home_batting_3_name` = IF(@home_batting_3_name = '', NULL, @home_batting_3_name),
- 2022-11-23 17:16:51 `home_batting_3_position` = IF(@home_batting_3_position = '', NULL, @home_batting_3_position),
- 2022-11-23 17:16:51 `home_batting_4_player_id` = IF(@home_batting_4_player_id = '', NULL, @home_batting_4_player_id),
- 2022-11-23 17:16:51 `home_batting_4_name` = IF(@home_batting_4_name = '', NULL, @home_batting_4_name),
- 2022-11-23 17:16:51 `home_batting_4_position` = IF(@home_batting_4_position = '', NULL, @home_batting_4_position),
- 2022-11-23 17:16:51 `home_batting_5_player_id` = IF(@home_batting_5_player_id = '', NULL, @home_batting_5_player_id),
- 2022-11-23 17:16:51 `home_batting_5_name` = IF(@home_batting_5_name = '', NULL, @home_batting_5_name),
- 2022-11-23 17:16:51 `home_batting_5_position` = IF(@home_batting_5_position = '', NULL, @home_batting_5_position),
- 2022-11-23 17:16:51 `home_batting_6_player_id` = IF(@home_batting_6_player_id = '', NULL, @home_batting_6_player_id),
- 2022-11-23 17:16:51 `home_batting_6_name` = IF(@home_batting_6_name = '', NULL, @home_batting_6_name),
- 2022-11-23 17:16:51 `home_batting_6_position` = IF(@home_batting_6_position = '', NULL, @home_batting_6_position),
- 2022-11-23 17:16:51 `home_batting_7_player_id` = IF(@home_batting_7_player_id = '', NULL, @home_batting_7_player_id),
- 2022-11-23 17:16:51 `home_batting_7_name` = IF(@home_batting_7_name = '', NULL, @home_batting_7_name),
- 2022-11-23 17:16:51 `home_batting_7_position` = IF(@home_batting_7_position = '', NULL, @home_batting_7_position),
- 2022-11-23 17:16:51 `home_batting_8_player_id` = IF(@home_batting_8_player_id = '', NULL, @home_batting_8_player_id),
- 2022-11-23 17:16:51 `home_batting_8_name` = IF(@home_batting_8_name = '', NULL, @home_batting_8_name),
- 2022-11-23 17:16:51 `home_batting_8_position` = IF(@home_batting_8_position = '', NULL, @home_batting_8_position),
- 2022-11-23 17:16:51 `home_batting_9_player_id` = IF(@home_batting_9_player_id = '', NULL, @home_batting_9_player_id),
- 2022-11-23 17:16:51 `home_batting_9_name` = IF(@home_batting_9_name = '', NULL, @home_batting_9_name),
- 2022-11-23 17:16:51 `home_batting_9_position` = IF(@home_batting_9_position = '', NULL, @home_batting_9_position),
- 2022-11-23 17:16:51 `additional_info` = IF(@additional_info = '', NULL, @additional_info),
- 2022-11-23 17:16:51 `acquisition_info` = IF(@acquisition_info = '', NULL, @acquisition_info);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/daily.csv' INTO TABLE retrosheet.daily
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@game_id, @game_dt, @game_ct, @appearance_dt, @team_id, @player_id, @slot_ct, @seq_ct, @home_fl, @opponent_id, @park_id, @b_g, @b_pa, @b_ab, @b_r, @b_h, @b_tb, @b_2b, @b_3b, @b_hr, @b_hr4, @b_rbi, @b_gw, @b_bb, @b_ibb, @b_so, @b_gdp, @b_hp, @b_sh, @b_sf, @b_sb, @b_cs, @b_xi, @b_g_dh, @b_g_ph, @b_g_pr, @p_g, @p_gs, @p_cg, @p_sho, @p_gf, @p_w, @p_l, @p_sv, @p_out, @p_tbf, @p_ab, @p_r, @p_er, @p_h, @p_tb, @p_2b, @p_3b, @p_hr, @p_hr4, @p_bb, @p_ibb, @p_so, @p_gdp, @p_hp, @p_sh, @p_sf, @p_xi, @p_wp, @p_bk, @p_ir, @p_irs, @p_go, @p_ao, @p_pitch, @p_strike, @f_p_g, @f_p_gs, @f_p_out, @f_p_tc, @f_p_po, @f_p_a, @f_p_e, @f_p_dp, @f_p_tp, @f_c_g, @f_c_gs, @f_c_out, @f_c_tc, @f_c_po, @f_c_a, @f_c_e, @f_c_dp, @f_c_tp, @f_c_pb, @f_c_xi, @f_1b_g, @f_1b_gs, @f_1b_out, @f_1b_tc, @f_1b_po, @f_1b_a, @f_1b_e, @f_1b_dp, @f_1b_tp, @f_2b_g, @f_2b_gs, @f_2b_out, @f_2b_tc, @f_2b_po, @f_2b_a, @f_2b_e, @f_2b_dp, @f_2b_tp, @f_3b_g, @f_3b_gs, @f_3b_out, @f_3b_tc, @f_3b_po, @f_3b_a, @f_3b_e, @f_3b_dp, @f_3b_tp, @f_ss_g, @f_ss_gs, @f_ss_out, @f_ss_tc, @f_ss_po, @f_ss_a, @f_ss_e, @f_ss_dp, @f_ss_tp, @f_lf_g, @f_lf_gs, @f_lf_out, @f_lf_tc, @f_lf_po, @f_lf_a, @f_lf_e, @f_lf_dp, @f_lf_tp, @f_cf_g, @f_cf_gs, @f_cf_out, @f_cf_tc, @f_cf_po, @f_cf_a, @f_cf_e, @f_cf_dp, @f_cf_tp, @f_rf_g, @f_rf_gs, @f_rf_out, @f_rf_tc, @f_rf_po, @f_rf_a, @f_rf_e, @f_rf_dp, @f_rf_tp, @dummy_id)
- 2022-11-23 17:16:51 SET `home_fl` = IF(@home_fl = 'T', 1, IF(@home_fl = 'F', 0, IF(@home_fl = '', NULL, @home_fl))),
- 2022-11-23 17:16:51 `game_id` = IF(@game_id = '', NULL, @game_id),
- 2022-11-23 17:16:51 `game_dt` = IF(@game_dt = '', NULL, @game_dt),
- 2022-11-23 17:16:51 `game_ct` = IF(@game_ct = '', NULL, @game_ct),
- 2022-11-23 17:16:51 `appearance_dt` = IF(@appearance_dt = '', NULL, @appearance_dt),
- 2022-11-23 17:16:51 `team_id` = IF(@team_id = '', NULL, @team_id),
- 2022-11-23 17:16:51 `player_id` = IF(@player_id = '', NULL, @player_id),
- 2022-11-23 17:16:51 `slot_ct` = IF(@slot_ct = '', NULL, @slot_ct),
- 2022-11-23 17:16:51 `seq_ct` = IF(@seq_ct = '', NULL, @seq_ct),
- 2022-11-23 17:16:51 `opponent_id` = IF(@opponent_id = '', NULL, @opponent_id),
- 2022-11-23 17:16:51 `park_id` = IF(@park_id = '', NULL, @park_id),
- 2022-11-23 17:16:51 `b_g` = IF(@b_g = '', NULL, @b_g),
- 2022-11-23 17:16:51 `b_pa` = IF(@b_pa = '', NULL, @b_pa),
- 2022-11-23 17:16:51 `b_ab` = IF(@b_ab = '', NULL, @b_ab),
- 2022-11-23 17:16:51 `b_r` = IF(@b_r = '', NULL, @b_r),
- 2022-11-23 17:16:51 `b_h` = IF(@b_h = '', NULL, @b_h),
- 2022-11-23 17:16:51 `b_tb` = IF(@b_tb = '', NULL, @b_tb),
- 2022-11-23 17:16:51 `b_2b` = IF(@b_2b = '', NULL, @b_2b),
- 2022-11-23 17:16:51 `b_3b` = IF(@b_3b = '', NULL, @b_3b),
- 2022-11-23 17:16:51 `b_hr` = IF(@b_hr = '', NULL, @b_hr),
- 2022-11-23 17:16:51 `b_hr4` = IF(@b_hr4 = '', NULL, @b_hr4),
- 2022-11-23 17:16:51 `b_rbi` = IF(@b_rbi = '', NULL, @b_rbi),
- 2022-11-23 17:16:51 `b_gw` = IF(@b_gw = '', NULL, @b_gw),
- 2022-11-23 17:16:51 `b_bb` = IF(@b_bb = '', NULL, @b_bb),
- 2022-11-23 17:16:51 `b_ibb` = IF(@b_ibb = '', NULL, @b_ibb),
- 2022-11-23 17:16:51 `b_so` = IF(@b_so = '', NULL, @b_so),
- 2022-11-23 17:16:51 `b_gdp` = IF(@b_gdp = '', NULL, @b_gdp),
- 2022-11-23 17:16:51 `b_hp` = IF(@b_hp = '', NULL, @b_hp),
- 2022-11-23 17:16:51 `b_sh` = IF(@b_sh = '', NULL, @b_sh),
- 2022-11-23 17:16:51 `b_sf` = IF(@b_sf = '', NULL, @b_sf),
- 2022-11-23 17:16:51 `b_sb` = IF(@b_sb = '', NULL, @b_sb),
- 2022-11-23 17:16:51 `b_cs` = IF(@b_cs = '', NULL, @b_cs),
- 2022-11-23 17:16:51 `b_xi` = IF(@b_xi = '', NULL, @b_xi),
- 2022-11-23 17:16:51 `b_g_dh` = IF(@b_g_dh = '', NULL, @b_g_dh),
- 2022-11-23 17:16:51 `b_g_ph` = IF(@b_g_ph = '', NULL, @b_g_ph),
- 2022-11-23 17:16:51 `b_g_pr` = IF(@b_g_pr = '', NULL, @b_g_pr),
- 2022-11-23 17:16:51 `p_g` = IF(@p_g = '', NULL, @p_g),
- 2022-11-23 17:16:51 `p_gs` = IF(@p_gs = '', NULL, @p_gs),
- 2022-11-23 17:16:51 `p_cg` = IF(@p_cg = '', NULL, @p_cg),
- 2022-11-23 17:16:51 `p_sho` = IF(@p_sho = '', NULL, @p_sho),
- 2022-11-23 17:16:51 `p_gf` = IF(@p_gf = '', NULL, @p_gf),
- 2022-11-23 17:16:51 `p_w` = IF(@p_w = '', NULL, @p_w),
- 2022-11-23 17:16:51 `p_l` = IF(@p_l = '', NULL, @p_l),
- 2022-11-23 17:16:51 `p_sv` = IF(@p_sv = '', NULL, @p_sv),
- 2022-11-23 17:16:51 `p_out` = IF(@p_out = '', NULL, @p_out),
- 2022-11-23 17:16:51 `p_tbf` = IF(@p_tbf = '', NULL, @p_tbf),
- 2022-11-23 17:16:51 `p_ab` = IF(@p_ab = '', NULL, @p_ab),
- 2022-11-23 17:16:51 `p_r` = IF(@p_r = '', NULL, @p_r),
- 2022-11-23 17:16:51 `p_er` = IF(@p_er = '', NULL, @p_er),
- 2022-11-23 17:16:51 `p_h` = IF(@p_h = '', NULL, @p_h),
- 2022-11-23 17:16:51 `p_tb` = IF(@p_tb = '', NULL, @p_tb),
- 2022-11-23 17:16:51 `p_2b` = IF(@p_2b = '', NULL, @p_2b),
- 2022-11-23 17:16:51 `p_3b` = IF(@p_3b = '', NULL, @p_3b),
- 2022-11-23 17:16:51 `p_hr` = IF(@p_hr = '', NULL, @p_hr),
- 2022-11-23 17:16:51 `p_hr4` = IF(@p_hr4 = '', NULL, @p_hr4),
- 2022-11-23 17:16:51 `p_bb` = IF(@p_bb = '', NULL, @p_bb),
- 2022-11-23 17:16:51 `p_ibb` = IF(@p_ibb = '', NULL, @p_ibb),
- 2022-11-23 17:16:51 `p_so` = IF(@p_so = '', NULL, @p_so),
- 2022-11-23 17:16:51 `p_gdp` = IF(@p_gdp = '', NULL, @p_gdp),
- 2022-11-23 17:16:51 `p_hp` = IF(@p_hp = '', NULL, @p_hp),
- 2022-11-23 17:16:51 `p_sh` = IF(@p_sh = '', NULL, @p_sh),
- 2022-11-23 17:16:51 `p_sf` = IF(@p_sf = '', NULL, @p_sf),
- 2022-11-23 17:16:51 `p_xi` = IF(@p_xi = '', NULL, @p_xi),
- 2022-11-23 17:16:51 `p_wp` = IF(@p_wp = '', NULL, @p_wp),
- 2022-11-23 17:16:51 `p_bk` = IF(@p_bk = '', NULL, @p_bk),
- 2022-11-23 17:16:51 `p_ir` = IF(@p_ir = '', NULL, @p_ir),
- 2022-11-23 17:16:51 `p_irs` = IF(@p_irs = '', NULL, @p_irs),
- 2022-11-23 17:16:51 `p_go` = IF(@p_go = '', NULL, @p_go),
- 2022-11-23 17:16:51 `p_ao` = IF(@p_ao = '', NULL, @p_ao),
- 2022-11-23 17:16:51 `p_pitch` = IF(@p_pitch = '', NULL, @p_pitch),
- 2022-11-23 17:16:51 `p_strike` = IF(@p_strike = '', NULL, @p_strike),
- 2022-11-23 17:16:51 `f_p_g` = IF(@f_p_g = '', NULL, @f_p_g),
- 2022-11-23 17:16:51 `f_p_gs` = IF(@f_p_gs = '', NULL, @f_p_gs),
- 2022-11-23 17:16:51 `f_p_out` = IF(@f_p_out = '', NULL, @f_p_out),
- 2022-11-23 17:16:51 `f_p_tc` = IF(@f_p_tc = '', NULL, @f_p_tc),
- 2022-11-23 17:16:51 `f_p_po` = IF(@f_p_po = '', NULL, @f_p_po),
- 2022-11-23 17:16:51 `f_p_a` = IF(@f_p_a = '', NULL, @f_p_a),
- 2022-11-23 17:16:51 `f_p_e` = IF(@f_p_e = '', NULL, @f_p_e),
- 2022-11-23 17:16:51 `f_p_dp` = IF(@f_p_dp = '', NULL, @f_p_dp),
- 2022-11-23 17:16:51 `f_p_tp` = IF(@f_p_tp = '', NULL, @f_p_tp),
- 2022-11-23 17:16:51 `f_c_g` = IF(@f_c_g = '', NULL, @f_c_g),
- 2022-11-23 17:16:51 `f_c_gs` = IF(@f_c_gs = '', NULL, @f_c_gs),
- 2022-11-23 17:16:51 `f_c_out` = IF(@f_c_out = '', NULL, @f_c_out),
- 2022-11-23 17:16:51 `f_c_tc` = IF(@f_c_tc = '', NULL, @f_c_tc),
- 2022-11-23 17:16:51 `f_c_po` = IF(@f_c_po = '', NULL, @f_c_po),
- 2022-11-23 17:16:51 `f_c_a` = IF(@f_c_a = '', NULL, @f_c_a),
- 2022-11-23 17:16:51 `f_c_e` = IF(@f_c_e = '', NULL, @f_c_e),
- 2022-11-23 17:16:51 `f_c_dp` = IF(@f_c_dp = '', NULL, @f_c_dp),
- 2022-11-23 17:16:51 `f_c_tp` = IF(@f_c_tp = '', NULL, @f_c_tp),
- 2022-11-23 17:16:51 `f_c_pb` = IF(@f_c_pb = '', NULL, @f_c_pb),
- 2022-11-23 17:16:51 `f_c_xi` = IF(@f_c_xi = '', NULL, @f_c_xi),
- 2022-11-23 17:16:51 `f_1b_g` = IF(@f_1b_g = '', NULL, @f_1b_g),
- 2022-11-23 17:16:51 `f_1b_gs` = IF(@f_1b_gs = '', NULL, @f_1b_gs),
- 2022-11-23 17:16:51 `f_1b_out` = IF(@f_1b_out = '', NULL, @f_1b_out),
- 2022-11-23 17:16:51 `f_1b_tc` = IF(@f_1b_tc = '', NULL, @f_1b_tc),
- 2022-11-23 17:16:51 `f_1b_po` = IF(@f_1b_po = '', NULL, @f_1b_po),
- 2022-11-23 17:16:51 `f_1b_a` = IF(@f_1b_a = '', NULL, @f_1b_a),
- 2022-11-23 17:16:51 `f_1b_e` = IF(@f_1b_e = '', NULL, @f_1b_e),
- 2022-11-23 17:16:51 `f_1b_dp` = IF(@f_1b_dp = '', NULL, @f_1b_dp),
- 2022-11-23 17:16:51 `f_1b_tp` = IF(@f_1b_tp = '', NULL, @f_1b_tp),
- 2022-11-23 17:16:51 `f_2b_g` = IF(@f_2b_g = '', NULL, @f_2b_g),
- 2022-11-23 17:16:51 `f_2b_gs` = IF(@f_2b_gs = '', NULL, @f_2b_gs),
- 2022-11-23 17:16:51 `f_2b_out` = IF(@f_2b_out = '', NULL, @f_2b_out),
- 2022-11-23 17:16:51 `f_2b_tc` = IF(@f_2b_tc = '', NULL, @f_2b_tc),
- 2022-11-23 17:16:51 `f_2b_po` = IF(@f_2b_po = '', NULL, @f_2b_po),
- 2022-11-23 17:16:51 `f_2b_a` = IF(@f_2b_a = '', NULL, @f_2b_a),
- 2022-11-23 17:16:51 `f_2b_e` = IF(@f_2b_e = '', NULL, @f_2b_e),
- 2022-11-23 17:16:51 `f_2b_dp` = IF(@f_2b_dp = '', NULL, @f_2b_dp),
- 2022-11-23 17:16:51 `f_2b_tp` = IF(@f_2b_tp = '', NULL, @f_2b_tp),
- 2022-11-23 17:16:51 `f_3b_g` = IF(@f_3b_g = '', NULL, @f_3b_g),
- 2022-11-23 17:16:51 `f_3b_gs` = IF(@f_3b_gs = '', NULL, @f_3b_gs),
- 2022-11-23 17:16:51 `f_3b_out` = IF(@f_3b_out = '', NULL, @f_3b_out),
- 2022-11-23 17:16:51 `f_3b_tc` = IF(@f_3b_tc = '', NULL, @f_3b_tc),
- 2022-11-23 17:16:51 `f_3b_po` = IF(@f_3b_po = '', NULL, @f_3b_po),
- 2022-11-23 17:16:51 `f_3b_a` = IF(@f_3b_a = '', NULL, @f_3b_a),
- 2022-11-23 17:16:51 `f_3b_e` = IF(@f_3b_e = '', NULL, @f_3b_e),
- 2022-11-23 17:16:51 `f_3b_dp` = IF(@f_3b_dp = '', NULL, @f_3b_dp),
- 2022-11-23 17:16:51 `f_3b_tp` = IF(@f_3b_tp = '', NULL, @f_3b_tp),
- 2022-11-23 17:16:51 `f_ss_g` = IF(@f_ss_g = '', NULL, @f_ss_g),
- 2022-11-23 17:16:51 `f_ss_gs` = IF(@f_ss_gs = '', NULL, @f_ss_gs),
- 2022-11-23 17:16:51 `f_ss_out` = IF(@f_ss_out = '', NULL, @f_ss_out),
- 2022-11-23 17:16:51 `f_ss_tc` = IF(@f_ss_tc = '', NULL, @f_ss_tc),
- 2022-11-23 17:16:51 `f_ss_po` = IF(@f_ss_po = '', NULL, @f_ss_po),
- 2022-11-23 17:16:51 `f_ss_a` = IF(@f_ss_a = '', NULL, @f_ss_a),
- 2022-11-23 17:16:51 `f_ss_e` = IF(@f_ss_e = '', NULL, @f_ss_e),
- 2022-11-23 17:16:51 `f_ss_dp` = IF(@f_ss_dp = '', NULL, @f_ss_dp),
- 2022-11-23 17:16:51 `f_ss_tp` = IF(@f_ss_tp = '', NULL, @f_ss_tp),
- 2022-11-23 17:16:51 `f_lf_g` = IF(@f_lf_g = '', NULL, @f_lf_g),
- 2022-11-23 17:16:51 `f_lf_gs` = IF(@f_lf_gs = '', NULL, @f_lf_gs),
- 2022-11-23 17:16:51 `f_lf_out` = IF(@f_lf_out = '', NULL, @f_lf_out),
- 2022-11-23 17:16:51 `f_lf_tc` = IF(@f_lf_tc = '', NULL, @f_lf_tc),
- 2022-11-23 17:16:51 `f_lf_po` = IF(@f_lf_po = '', NULL, @f_lf_po),
- 2022-11-23 17:16:51 `f_lf_a` = IF(@f_lf_a = '', NULL, @f_lf_a),
- 2022-11-23 17:16:51 `f_lf_e` = IF(@f_lf_e = '', NULL, @f_lf_e),
- 2022-11-23 17:16:51 `f_lf_dp` = IF(@f_lf_dp = '', NULL, @f_lf_dp),
- 2022-11-23 17:16:51 `f_lf_tp` = IF(@f_lf_tp = '', NULL, @f_lf_tp),
- 2022-11-23 17:16:51 `f_cf_g` = IF(@f_cf_g = '', NULL, @f_cf_g),
- 2022-11-23 17:16:51 `f_cf_gs` = IF(@f_cf_gs = '', NULL, @f_cf_gs),
- 2022-11-23 17:16:51 `f_cf_out` = IF(@f_cf_out = '', NULL, @f_cf_out),
- 2022-11-23 17:16:51 `f_cf_tc` = IF(@f_cf_tc = '', NULL, @f_cf_tc),
- 2022-11-23 17:16:51 `f_cf_po` = IF(@f_cf_po = '', NULL, @f_cf_po),
- 2022-11-23 17:16:51 `f_cf_a` = IF(@f_cf_a = '', NULL, @f_cf_a),
- 2022-11-23 17:16:51 `f_cf_e` = IF(@f_cf_e = '', NULL, @f_cf_e),
- 2022-11-23 17:16:51 `f_cf_dp` = IF(@f_cf_dp = '', NULL, @f_cf_dp),
- 2022-11-23 17:16:51 `f_cf_tp` = IF(@f_cf_tp = '', NULL, @f_cf_tp),
- 2022-11-23 17:16:51 `f_rf_g` = IF(@f_rf_g = '', NULL, @f_rf_g),
- 2022-11-23 17:16:51 `f_rf_gs` = IF(@f_rf_gs = '', NULL, @f_rf_gs),
- 2022-11-23 17:16:51 `f_rf_out` = IF(@f_rf_out = '', NULL, @f_rf_out),
- 2022-11-23 17:16:51 `f_rf_tc` = IF(@f_rf_tc = '', NULL, @f_rf_tc),
- 2022-11-23 17:16:51 `f_rf_po` = IF(@f_rf_po = '', NULL, @f_rf_po),
- 2022-11-23 17:16:51 `f_rf_a` = IF(@f_rf_a = '', NULL, @f_rf_a),
- 2022-11-23 17:16:51 `f_rf_e` = IF(@f_rf_e = '', NULL, @f_rf_e),
- 2022-11-23 17:16:51 `f_rf_dp` = IF(@f_rf_dp = '', NULL, @f_rf_dp),
- 2022-11-23 17:16:51 `f_rf_tp` = IF(@f_rf_tp = '', NULL, @f_rf_tp),
- 2022-11-23 17:16:51 `dummy_id` = IF(@dummy_id = '', NULL, @dummy_id);
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 LOAD DATA INFILE '/data/retrosheet/event.csv' INTO TABLE retrosheet.event
- 2022-11-23 17:16:51 FIELDS TERMINATED BY ','
- 2022-11-23 17:16:51 OPTIONALLY ENCLOSED BY '"'
- 2022-11-23 17:16:51 LINES TERMINATED BY '
- 2022-11-23 17:16:51 '
- 2022-11-23 17:16:51 (@game_id, @away_team_id, @inn_ct, @bat_home_id, @outs_ct, @balls_ct, @strikes_ct, @pitch_seq_tx, @away_score_ct, @home_score_ct, @bat_id, @bat_hand_cd, @resp_bat_id, @resp_bat_hand_cd, @pit_id, @pit_hand_cd, @resp_pit_id, @resp_pit_hand_cd, @pos2_fld_id, @pos3_fld_id, @pos4_fld_id, @pos5_fld_id, @pos6_fld_id, @pos7_fld_id, @pos8_fld_id, @pos9_fld_id, @base1_run_id, @base2_run_id, @base3_run_id, @event_tx, @leadoff_fl, @ph_fl, @bat_fld_cd, @bat_lineup_id, @event_cd, @bat_event_fl, @ab_fl, @h_fl, @sh_fl, @sf_fl, @event_outs_ct, @dp_fl, @tp_fl, @rbi_ct, @wp_fl, @pb_fl, @fld_cd, @battedball_cd, @bunt_fl, @foul_fl, @battedball_loc_tx, @err_ct, @err1_fld_cd, @err1_cd, @err2_fld_cd, @err2_cd, @err3_fld_cd, @err3_cd, @bat_dest_id, @run1_dest_id, @run2_dest_id, @run3_dest_id, @bat_play_tx, @run1_play_tx, @run2_play_tx, @run3_play_tx, @run1_sb_fl, @run2_sb_fl, @run3_sb_fl, @run1_cs_fl, @run2_cs_fl, @run3_cs_fl, @run1_pk_fl, @run2_pk_fl, @run3_pk_fl, @run1_resp_pit_id, @run2_resp_pit_id, @run3_resp_pit_id, @game_new_fl, @game_end_fl, @pr_run1_fl, @pr_run2_fl, @pr_run3_fl, @removed_for_pr_run1_id, @removed_for_pr_run2_id, @removed_for_pr_run3_id, @removed_for_ph_bat_id, @removed_for_ph_bat_fld_cd, @po1_fld_cd, @po2_fld_cd, @po3_fld_cd, @ass1_fld_cd, @ass2_fld_cd, @ass3_fld_cd, @ass4_fld_cd, @ass5_fld_cd, @event_id, @home_team_id, @bat_team_id, @fld_team_id, @bat_last_id, @inn_new_fl, @inn_end_fl, @start_bat_score_ct, @start_fld_score_ct, @inn_runs_ct, @game_pa_ct, @inn_pa_ct, @pa_new_fl, @pa_trunc_fl, @start_bases_cd, @end_bases_cd, @bat_start_fl, @resp_bat_start_fl, @bat_on_deck_id, @bat_in_hold_id, @pit_start_fl, @resp_pit_start_fl, @run1_fld_cd, @run1_lineup_cd, @run1_origin_event_id, @run2_fld_cd, @run2_lineup_cd, @run2_origin_event_id, @run3_fld_cd, @run3_lineup_cd, @run3_origin_event_id, @run1_resp_cat_id, @run2_resp_cat_id, @run3_resp_cat_id, @pa_ball_ct, @pa_called_ball_ct, @pa_intent_ball_ct, @pa_pitchout_ball_ct, @pa_hitbatter_ball_ct, @pa_other_ball_ct, @pa_strike_ct, @pa_called_strike_ct, @pa_swingmiss_strike_ct, @pa_foul_strike_ct, @pa_inplay_strike_ct, @pa_other_strike_ct, @event_runs_ct, @fld_id, @base2_force_fl, @base3_force_fl, @base4_force_fl, @bat_safe_err_fl, @bat_fate_id, @run1_fate_id, @run2_fate_id, @run3_fate_id, @fate_runs_ct, @ass6_fld_cd, @ass7_fld_cd, @ass8_fld_cd, @ass9_fld_cd, @ass10_fld_cd, @unknown_out_exc_fl, @uncertain_play_exc_fl)
- 2022-11-23 17:16:51 SET `bat_home_id` = IF(@bat_home_id = 'T', 1, IF(@bat_home_id = 'F', 0, IF(@bat_home_id = '', NULL, @bat_home_id))),
- 2022-11-23 17:16:51 `leadoff_fl` = IF(@leadoff_fl = 'T', 1, IF(@leadoff_fl = 'F', 0, IF(@leadoff_fl = '', NULL, @leadoff_fl))),
- 2022-11-23 17:16:51 `ph_fl` = IF(@ph_fl = 'T', 1, IF(@ph_fl = 'F', 0, IF(@ph_fl = '', NULL, @ph_fl))),
- 2022-11-23 17:16:51 `bat_event_fl` = IF(@bat_event_fl = 'T', 1, IF(@bat_event_fl = 'F', 0, IF(@bat_event_fl = '', NULL, @bat_event_fl))),
- 2022-11-23 17:16:51 `ab_fl` = IF(@ab_fl = 'T', 1, IF(@ab_fl = 'F', 0, IF(@ab_fl = '', NULL, @ab_fl))),
- 2022-11-23 17:16:51 `sh_fl` = IF(@sh_fl = 'T', 1, IF(@sh_fl = 'F', 0, IF(@sh_fl = '', NULL, @sh_fl))),
- 2022-11-23 17:16:51 `sf_fl` = IF(@sf_fl = 'T', 1, IF(@sf_fl = 'F', 0, IF(@sf_fl = '', NULL, @sf_fl))),
- 2022-11-23 17:16:51 `dp_fl` = IF(@dp_fl = 'T', 1, IF(@dp_fl = 'F', 0, IF(@dp_fl = '', NULL, @dp_fl))),
- 2022-11-23 17:16:51 `tp_fl` = IF(@tp_fl = 'T', 1, IF(@tp_fl = 'F', 0, IF(@tp_fl = '', NULL, @tp_fl))),
- 2022-11-23 17:16:51 `wp_fl` = IF(@wp_fl = 'T', 1, IF(@wp_fl = 'F', 0, IF(@wp_fl = '', NULL, @wp_fl))),
- 2022-11-23 17:16:51 `pb_fl` = IF(@pb_fl = 'T', 1, IF(@pb_fl = 'F', 0, IF(@pb_fl = '', NULL, @pb_fl))),
- 2022-11-23 17:16:51 `bunt_fl` = IF(@bunt_fl = 'T', 1, IF(@bunt_fl = 'F', 0, IF(@bunt_fl = '', NULL, @bunt_fl))),
- 2022-11-23 17:16:51 `foul_fl` = IF(@foul_fl = 'T', 1, IF(@foul_fl = 'F', 0, IF(@foul_fl = '', NULL, @foul_fl))),
- 2022-11-23 17:16:51 `run1_sb_fl` = IF(@run1_sb_fl = 'T', 1, IF(@run1_sb_fl = 'F', 0, IF(@run1_sb_fl = '', NULL, @run1_sb_fl))),
- 2022-11-23 17:16:51 `run2_sb_fl` = IF(@run2_sb_fl = 'T', 1, IF(@run2_sb_fl = 'F', 0, IF(@run2_sb_fl = '', NULL, @run2_sb_fl))),
- 2022-11-23 17:16:51 `run3_sb_fl` = IF(@run3_sb_fl = 'T', 1, IF(@run3_sb_fl = 'F', 0, IF(@run3_sb_fl = '', NULL, @run3_sb_fl))),
- 2022-11-23 17:16:51 `run1_cs_fl` = IF(@run1_cs_fl = 'T', 1, IF(@run1_cs_fl = 'F', 0, IF(@run1_cs_fl = '', NULL, @run1_cs_fl))),
- 2022-11-23 17:16:51 `run2_cs_fl` = IF(@run2_cs_fl = 'T', 1, IF(@run2_cs_fl = 'F', 0, IF(@run2_cs_fl = '', NULL, @run2_cs_fl))),
- 2022-11-23 17:16:51 `run3_cs_fl` = IF(@run3_cs_fl = 'T', 1, IF(@run3_cs_fl = 'F', 0, IF(@run3_cs_fl = '', NULL, @run3_cs_fl))),
- 2022-11-23 17:16:51 `run1_pk_fl` = IF(@run1_pk_fl = 'T', 1, IF(@run1_pk_fl = 'F', 0, IF(@run1_pk_fl = '', NULL, @run1_pk_fl))),
- 2022-11-23 17:16:51 `run2_pk_fl` = IF(@run2_pk_fl = 'T', 1, IF(@run2_pk_fl = 'F', 0, IF(@run2_pk_fl = '', NULL, @run2_pk_fl))),
- 2022-11-23 17:16:51 `run3_pk_fl` = IF(@run3_pk_fl = 'T', 1, IF(@run3_pk_fl = 'F', 0, IF(@run3_pk_fl = '', NULL, @run3_pk_fl))),
- 2022-11-23 17:16:51 `game_new_fl` = IF(@game_new_fl = 'T', 1, IF(@game_new_fl = 'F', 0, IF(@game_new_fl = '', NULL, @game_new_fl))),
- 2022-11-23 17:16:51 `game_end_fl` = IF(@game_end_fl = 'T', 1, IF(@game_end_fl = 'F', 0, IF(@game_end_fl = '', NULL, @game_end_fl))),
- 2022-11-23 17:16:51 `pr_run1_fl` = IF(@pr_run1_fl = 'T', 1, IF(@pr_run1_fl = 'F', 0, IF(@pr_run1_fl = '', NULL, @pr_run1_fl))),
- 2022-11-23 17:16:51 `pr_run2_fl` = IF(@pr_run2_fl = 'T', 1, IF(@pr_run2_fl = 'F', 0, IF(@pr_run2_fl = '', NULL, @pr_run2_fl))),
- 2022-11-23 17:16:51 `pr_run3_fl` = IF(@pr_run3_fl = 'T', 1, IF(@pr_run3_fl = 'F', 0, IF(@pr_run3_fl = '', NULL, @pr_run3_fl))),
- 2022-11-23 17:16:51 `inn_new_fl` = IF(@inn_new_fl = 'T', 1, IF(@inn_new_fl = 'F', 0, IF(@inn_new_fl = '', NULL, @inn_new_fl))),
- 2022-11-23 17:16:51 `inn_end_fl` = IF(@inn_end_fl = 'T', 1, IF(@inn_end_fl = 'F', 0, IF(@inn_end_fl = '', NULL, @inn_end_fl))),
- 2022-11-23 17:16:51 `pa_new_fl` = IF(@pa_new_fl = 'T', 1, IF(@pa_new_fl = 'F', 0, IF(@pa_new_fl = '', NULL, @pa_new_fl))),
- 2022-11-23 17:16:51 `pa_trunc_fl` = IF(@pa_trunc_fl = 'T', 1, IF(@pa_trunc_fl = 'F', 0, IF(@pa_trunc_fl = '', NULL, @pa_trunc_fl))),
- 2022-11-23 17:16:51 `bat_start_fl` = IF(@bat_start_fl = 'T', 1, IF(@bat_start_fl = 'F', 0, IF(@bat_start_fl = '', NULL, @bat_start_fl))),
- 2022-11-23 17:16:51 `resp_bat_start_fl` = IF(@resp_bat_start_fl = 'T', 1, IF(@resp_bat_start_fl = 'F', 0, IF(@resp_bat_start_fl = '', NULL, @resp_bat_start_fl))),
- 2022-11-23 17:16:51 `pit_start_fl` = IF(@pit_start_fl = 'T', 1, IF(@pit_start_fl = 'F', 0, IF(@pit_start_fl = '', NULL, @pit_start_fl))),
- 2022-11-23 17:16:51 `resp_pit_start_fl` = IF(@resp_pit_start_fl = 'T', 1, IF(@resp_pit_start_fl = 'F', 0, IF(@resp_pit_start_fl = '', NULL, @resp_pit_start_fl))),
- 2022-11-23 17:16:51 `base2_force_fl` = IF(@base2_force_fl = 'T', 1, IF(@base2_force_fl = 'F', 0, IF(@base2_force_fl = '', NULL, @base2_force_fl))),
- 2022-11-23 17:16:51 `base3_force_fl` = IF(@base3_force_fl = 'T', 1, IF(@base3_force_fl = 'F', 0, IF(@base3_force_fl = '', NULL, @base3_force_fl))),
- 2022-11-23 17:16:51 `base4_force_fl` = IF(@base4_force_fl = 'T', 1, IF(@base4_force_fl = 'F', 0, IF(@base4_force_fl = '', NULL, @base4_force_fl))),
- 2022-11-23 17:16:51 `bat_safe_err_fl` = IF(@bat_safe_err_fl = 'T', 1, IF(@bat_safe_err_fl = 'F', 0, IF(@bat_safe_err_fl = '', NULL, @bat_safe_err_fl))),
- 2022-11-23 17:16:51 `unknown_out_exc_fl` = IF(@unknown_out_exc_fl = 'T', 1, IF(@unknown_out_exc_fl = 'F', 0, IF(@unknown_out_exc_fl = '', NULL, @unknown_out_exc_fl))),
- 2022-11-23 17:16:51 `uncertain_play_exc_fl` = IF(@uncertain_play_exc_fl = 'T', 1, IF(@uncertain_play_exc_fl = 'F', 0, IF(@uncertain_play_exc_fl = '', NULL, @uncertain_play_exc_fl))),
- 2022-11-23 17:16:51 `game_id` = IF(@game_id = '', NULL, @game_id),
- 2022-11-23 17:16:51 `away_team_id` = IF(@away_team_id = '', NULL, @away_team_id),
- 2022-11-23 17:16:51 `inn_ct` = IF(@inn_ct = '', NULL, @inn_ct),
- 2022-11-23 17:16:51 `outs_ct` = IF(@outs_ct = '', NULL, @outs_ct),
- 2022-11-23 17:16:51 `balls_ct` = IF(@balls_ct = '', NULL, @balls_ct),
- 2022-11-23 17:16:51 `strikes_ct` = IF(@strikes_ct = '', NULL, @strikes_ct),
- 2022-11-23 17:16:51 `pitch_seq_tx` = IF(@pitch_seq_tx = '', NULL, @pitch_seq_tx),
- 2022-11-23 17:16:51 `away_score_ct` = IF(@away_score_ct = '', NULL, @away_score_ct),
- 2022-11-23 17:16:51 `home_score_ct` = IF(@home_score_ct = '', NULL, @home_score_ct),
- 2022-11-23 17:16:51 `bat_id` = IF(@bat_id = '', NULL, @bat_id),
- 2022-11-23 17:16:51 `bat_hand_cd` = IF(@bat_hand_cd = '', NULL, @bat_hand_cd),
- 2022-11-23 17:16:51 `resp_bat_id` = IF(@resp_bat_id = '', NULL, @resp_bat_id),
- 2022-11-23 17:16:51 `resp_bat_hand_cd` = IF(@resp_bat_hand_cd = '', NULL, @resp_bat_hand_cd),
- 2022-11-23 17:16:51 `pit_id` = IF(@pit_id = '', NULL, @pit_id),
- 2022-11-23 17:16:51 `pit_hand_cd` = IF(@pit_hand_cd = '', NULL, @pit_hand_cd),
- 2022-11-23 17:16:51 `resp_pit_id` = IF(@resp_pit_id = '', NULL, @resp_pit_id),
- 2022-11-23 17:16:51 `resp_pit_hand_cd` = IF(@resp_pit_hand_cd = '', NULL, @resp_pit_hand_cd),
- 2022-11-23 17:16:51 `pos2_fld_id` = IF(@pos2_fld_id = '', NULL, @pos2_fld_id),
- 2022-11-23 17:16:51 `pos3_fld_id` = IF(@pos3_fld_id = '', NULL, @pos3_fld_id),
- 2022-11-23 17:16:51 `pos4_fld_id` = IF(@pos4_fld_id = '', NULL, @pos4_fld_id),
- 2022-11-23 17:16:51 `pos5_fld_id` = IF(@pos5_fld_id = '', NULL, @pos5_fld_id),
- 2022-11-23 17:16:51 `pos6_fld_id` = IF(@pos6_fld_id = '', NULL, @pos6_fld_id),
- 2022-11-23 17:16:51 `pos7_fld_id` = IF(@pos7_fld_id = '', NULL, @pos7_fld_id),
- 2022-11-23 17:16:51 `pos8_fld_id` = IF(@pos8_fld_id = '', NULL, @pos8_fld_id),
- 2022-11-23 17:16:51 `pos9_fld_id` = IF(@pos9_fld_id = '', NULL, @pos9_fld_id),
- 2022-11-23 17:16:51 `base1_run_id` = IF(@base1_run_id = '', NULL, @base1_run_id),
- 2022-11-23 17:16:51 `base2_run_id` = IF(@base2_run_id = '', NULL, @base2_run_id),
- 2022-11-23 17:16:51 `base3_run_id` = IF(@base3_run_id = '', NULL, @base3_run_id),
- 2022-11-23 17:16:51 `event_tx` = IF(@event_tx = '', NULL, @event_tx),
- 2022-11-23 17:16:51 `bat_fld_cd` = IF(@bat_fld_cd = '', NULL, @bat_fld_cd),
- 2022-11-23 17:16:51 `bat_lineup_id` = IF(@bat_lineup_id = '', NULL, @bat_lineup_id),
- 2022-11-23 17:16:51 `event_cd` = IF(@event_cd = '', NULL, @event_cd),
- 2022-11-23 17:16:51 `h_fl` = IF(@h_fl = '', NULL, @h_fl),
- 2022-11-23 17:16:51 `event_outs_ct` = IF(@event_outs_ct = '', NULL, @event_outs_ct),
- 2022-11-23 17:16:51 `rbi_ct` = IF(@rbi_ct = '', NULL, @rbi_ct),
- 2022-11-23 17:16:51 `fld_cd` = IF(@fld_cd = '', NULL, @fld_cd),
- 2022-11-23 17:16:51 `battedball_cd` = IF(@battedball_cd = '', NULL, @battedball_cd),
- 2022-11-23 17:16:51 `battedball_loc_tx` = IF(@battedball_loc_tx = '', NULL, @battedball_loc_tx),
- 2022-11-23 17:16:51 `err_ct` = IF(@err_ct = '', NULL, @err_ct),
- 2022-11-23 17:16:51 `err1_fld_cd` = IF(@err1_fld_cd = '', NULL, @err1_fld_cd),
- 2022-11-23 17:16:51 `err1_cd` = IF(@err1_cd = '', NULL, @err1_cd),
- 2022-11-23 17:16:51 `err2_fld_cd` = IF(@err2_fld_cd = '', NULL, @err2_fld_cd),
- 2022-11-23 17:16:51 `err2_cd` = IF(@err2_cd = '', NULL, @err2_cd),
- 2022-11-23 17:16:51 `err3_fld_cd` = IF(@err3_fld_cd = '', NULL, @err3_fld_cd),
- 2022-11-23 17:16:51 `err3_cd` = IF(@err3_cd = '', NULL, @err3_cd),
- 2022-11-23 17:16:51 `bat_dest_id` = IF(@bat_dest_id = '', NULL, @bat_dest_id),
- 2022-11-23 17:16:51 `run1_dest_id` = IF(@run1_dest_id = '', NULL, @run1_dest_id),
- 2022-11-23 17:16:51 `run2_dest_id` = IF(@run2_dest_id = '', NULL, @run2_dest_id),
- 2022-11-23 17:16:51 `run3_dest_id` = IF(@run3_dest_id = '', NULL, @run3_dest_id),
- 2022-11-23 17:16:51 `bat_play_tx` = IF(@bat_play_tx = '', NULL, @bat_play_tx),
- 2022-11-23 17:16:51 `run1_play_tx` = IF(@run1_play_tx = '', NULL, @run1_play_tx),
- 2022-11-23 17:16:51 `run2_play_tx` = IF(@run2_play_tx = '', NULL, @run2_play_tx),
- 2022-11-23 17:16:51 `run3_play_tx` = IF(@run3_play_tx = '', NULL, @run3_play_tx),
- 2022-11-23 17:16:51 `run1_resp_pit_id` = IF(@run1_resp_pit_id = '', NULL, @run1_resp_pit_id),
- 2022-11-23 17:16:51 `run2_resp_pit_id` = IF(@run2_resp_pit_id = '', NULL, @run2_resp_pit_id),
- 2022-11-23 17:16:51 `run3_resp_pit_id` = IF(@run3_resp_pit_id = '', NULL, @run3_resp_pit_id),
- 2022-11-23 17:16:51 `removed_for_pr_run1_id` = IF(@removed_for_pr_run1_id = '', NULL, @removed_for_pr_run1_id),
- 2022-11-23 17:16:51 `removed_for_pr_run2_id` = IF(@removed_for_pr_run2_id = '', NULL, @removed_for_pr_run2_id),
- 2022-11-23 17:16:51 `removed_for_pr_run3_id` = IF(@removed_for_pr_run3_id = '', NULL, @removed_for_pr_run3_id),
- 2022-11-23 17:16:51 `removed_for_ph_bat_id` = IF(@removed_for_ph_bat_id = '', NULL, @removed_for_ph_bat_id),
- 2022-11-23 17:16:51 `removed_for_ph_bat_fld_cd` = IF(@removed_for_ph_bat_fld_cd = '', NULL, @removed_for_ph_bat_fld_cd),
- 2022-11-23 17:16:51 `po1_fld_cd` = IF(@po1_fld_cd = '', NULL, @po1_fld_cd),
- 2022-11-23 17:16:51 `po2_fld_cd` = IF(@po2_fld_cd = '', NULL, @po2_fld_cd),
- 2022-11-23 17:16:51 `po3_fld_cd` = IF(@po3_fld_cd = '', NULL, @po3_fld_cd),
- 2022-11-23 17:16:51 `ass1_fld_cd` = IF(@ass1_fld_cd = '', NULL, @ass1_fld_cd),
- 2022-11-23 17:16:51 `ass2_fld_cd` = IF(@ass2_fld_cd = '', NULL, @ass2_fld_cd),
- 2022-11-23 17:16:51 `ass3_fld_cd` = IF(@ass3_fld_cd = '', NULL, @ass3_fld_cd),
- 2022-11-23 17:16:51 `ass4_fld_cd` = IF(@ass4_fld_cd = '', NULL, @ass4_fld_cd),
- 2022-11-23 17:16:51 `ass5_fld_cd` = IF(@ass5_fld_cd = '', NULL, @ass5_fld_cd),
- 2022-11-23 17:16:51 `event_id` = IF(@event_id = '', NULL, @event_id),
- 2022-11-23 17:16:51 `home_team_id` = IF(@home_team_id = '', NULL, @home_team_id),
- 2022-11-23 17:16:51 `bat_team_id` = IF(@bat_team_id = '', NULL, @bat_team_id),
- 2022-11-23 17:16:51 `fld_team_id` = IF(@fld_team_id = '', NULL, @fld_team_id),
- 2022-11-23 17:16:51 `bat_last_id` = IF(@bat_last_id = '', NULL, @bat_last_id),
- 2022-11-23 17:16:51 `start_bat_score_ct` = IF(@start_bat_score_ct = '', NULL, @start_bat_score_ct),
- 2022-11-23 17:16:51 `start_fld_score_ct` = IF(@start_fld_score_ct = '', NULL, @start_fld_score_ct),
- 2022-11-23 17:16:51 `inn_runs_ct` = IF(@inn_runs_ct = '', NULL, @inn_runs_ct),
- 2022-11-23 17:16:51 `game_pa_ct` = IF(@game_pa_ct = '', NULL, @game_pa_ct),
- 2022-11-23 17:16:51 `inn_pa_ct` = IF(@inn_pa_ct = '', NULL, @inn_pa_ct),
- 2022-11-23 17:16:51 `start_bases_cd` = IF(@start_bases_cd = '', NULL, @start_bases_cd),
- 2022-11-23 17:16:51 `end_bases_cd` = IF(@end_bases_cd = '', NULL, @end_bases_cd),
- 2022-11-23 17:16:51 `bat_on_deck_id` = IF(@bat_on_deck_id = '', NULL, @bat_on_deck_id),
- 2022-11-23 17:16:51 `bat_in_hold_id` = IF(@bat_in_hold_id = '', NULL, @bat_in_hold_id),
- 2022-11-23 17:16:51 `run1_fld_cd` = IF(@run1_fld_cd = '', NULL, @run1_fld_cd),
- 2022-11-23 17:16:51 `run1_lineup_cd` = IF(@run1_lineup_cd = '', NULL, @run1_lineup_cd),
- 2022-11-23 17:16:51 `run1_origin_event_id` = IF(@run1_origin_event_id = '', NULL, @run1_origin_event_id),
- 2022-11-23 17:16:51 `run2_fld_cd` = IF(@run2_fld_cd = '', NULL, @run2_fld_cd),
- 2022-11-23 17:16:51 `run2_lineup_cd` = IF(@run2_lineup_cd = '', NULL, @run2_lineup_cd),
- 2022-11-23 17:16:51 `run2_origin_event_id` = IF(@run2_origin_event_id = '', NULL, @run2_origin_event_id),
- 2022-11-23 17:16:51 `run3_fld_cd` = IF(@run3_fld_cd = '', NULL, @run3_fld_cd),
- 2022-11-23 17:16:51 `run3_lineup_cd` = IF(@run3_lineup_cd = '', NULL, @run3_lineup_cd),
- 2022-11-23 17:16:51 `run3_origin_event_id` = IF(@run3_origin_event_id = '', NULL, @run3_origin_event_id),
- 2022-11-23 17:16:51 `run1_resp_cat_id` = IF(@run1_resp_cat_id = '', NULL, @run1_resp_cat_id),
- 2022-11-23 17:16:51 `run2_resp_cat_id` = IF(@run2_resp_cat_id = '', NULL, @run2_resp_cat_id),
- 2022-11-23 17:16:51 `run3_resp_cat_id` = IF(@run3_resp_cat_id = '', NULL, @run3_resp_cat_id),
- 2022-11-23 17:16:51 `pa_ball_ct` = IF(@pa_ball_ct = '', NULL, @pa_ball_ct),
- 2022-11-23 17:16:51 `pa_called_ball_ct` = IF(@pa_called_ball_ct = '', NULL, @pa_called_ball_ct),
- 2022-11-23 17:16:51 `pa_intent_ball_ct` = IF(@pa_intent_ball_ct = '', NULL, @pa_intent_ball_ct),
- 2022-11-23 17:16:51 `pa_pitchout_ball_ct` = IF(@pa_pitchout_ball_ct = '', NULL, @pa_pitchout_ball_ct),
- 2022-11-23 17:16:51 `pa_hitbatter_ball_ct` = IF(@pa_hitbatter_ball_ct = '', NULL, @pa_hitbatter_ball_ct),
- 2022-11-23 17:16:51 `pa_other_ball_ct` = IF(@pa_other_ball_ct = '', NULL, @pa_other_ball_ct),
- 2022-11-23 17:16:51 `pa_strike_ct` = IF(@pa_strike_ct = '', NULL, @pa_strike_ct),
- 2022-11-23 17:16:51 `pa_called_strike_ct` = IF(@pa_called_strike_ct = '', NULL, @pa_called_strike_ct),
- 2022-11-23 17:16:51 `pa_swingmiss_strike_ct` = IF(@pa_swingmiss_strike_ct = '', NULL, @pa_swingmiss_strike_ct),
- 2022-11-23 17:16:51 `pa_foul_strike_ct` = IF(@pa_foul_strike_ct = '', NULL, @pa_foul_strike_ct),
- 2022-11-23 17:16:51 `pa_inplay_strike_ct` = IF(@pa_inplay_strike_ct = '', NULL, @pa_inplay_strike_ct),
- 2022-11-23 17:16:51 `pa_other_strike_ct` = IF(@pa_other_strike_ct = '', NULL, @pa_other_strike_ct),
- 2022-11-23 17:16:51 `event_runs_ct` = IF(@event_runs_ct = '', NULL, @event_runs_ct),
- 2022-11-23 17:16:51 `fld_id` = IF(@fld_id = '', NULL, @fld_id),
- 2022-11-23 17:16:51 `bat_fate_id` = IF(@bat_fate_id = '', NULL, @bat_fate_id),
- 2022-11-23 17:16:51 `run1_fate_id` = IF(@run1_fate_id = '', NULL, @run1_fate_id),
- 2022-11-23 17:16:51 `run2_fate_id` = IF(@run2_fate_id = '', NULL, @run2_fate_id),
- 2022-11-23 17:16:51 `run3_fate_id` = IF(@run3_fate_id = '', NULL, @run3_fate_id),
- 2022-11-23 17:16:51 `fate_runs_ct` = IF(@fate_runs_ct = '', NULL, @fate_runs_ct),
- 2022-11-23 17:16:51 `ass6_fld_cd` = IF(@ass6_fld_cd = '', NULL, @ass6_fld_cd),
- 2022-11-23 17:16:51 `ass7_fld_cd` = IF(@ass7_fld_cd = '', NULL, @ass7_fld_cd),
- 2022-11-23 17:16:51 `ass8_fld_cd` = IF(@ass8_fld_cd = '', NULL, @ass8_fld_cd),
- 2022-11-23 17:16:51 `ass9_fld_cd` = IF(@ass9_fld_cd = '', NULL, @ass9_fld_cd),
- 2022-11-23 17:16:51 `ass10_fld_cd` = IF(@ass10_fld_cd = '', NULL, @ass10_fld_cd);
- 2022-11-23 17:16:51 ;
- 2022-11-23 17:16:51
- 2022-11-23 17:16:51 2022-11-23 22:16:51+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/mysql.sql
- 2022-11-23 17:18:07 ERROR 1262 (01000) at line 2063: Row 112998 was truncated; it contained more data than there were input columns
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement