Error by uploding SQL

Community support
#1

i get a error messege if i uplode 1 of this sql’s

New empte.sql

#
# Table structure for table `players`
#
CREATE TABLE players (
player_id int(5) NOT NULL auto_increment,
  name varchar(30)  NOT NULL,
  games int(5)  NOT NULL,
  entered int(10)  NOT NULL,
  1st int(4)  NOT NULL,
  2nd int(4)  NOT NULL,
  3rd int(4)  NOT NULL,
  points int(6)  NOT NULL,
  power decimal(4,2)  NOT NULL,
  percent decimal(4,2)  NOT NULL,
  ppg decimal(4,2) NOT NULL,
  buyin int(3)  NOT NULL,
  amountwon int(4)  NOT NULL,
  PRIMARY KEY  (player_id),
  KEY PRIMARY_KEY (player_id)
) TYPE=MyISAM;
#
# Table structure for table `games`
#
CREATE TABLE games (
  game_id int(5) NOT NULL auto_increment,
  game_num int(5) NOT NULL,
  date date  NOT NULL,
  player_id int(5)  NOT NULL,
  entered int(3)  NOT NULL,
  place int(3)  NOT NULL,
  points int(3)  NOT NULL,
  buyin int(3)  NOT NULL,
  payout int(4)  NOT NULL,
  PRIMARY KEY  (game_id),
  KEY PRIMARY_KEY (game_id)
) TYPE=MyISAM;
#





+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



my test.sql
-------------------


#
# Table structure for table `players`
#
CREATE TABLE players (
player_id int(5) NOT NULL auto_increment,
  name varchar(30)  NOT NULL,
  games int(5)  NOT NULL,
  entered int(10)  NOT NULL,
  1st int(4)  NOT NULL,
  2nd int(4)  NOT NULL,
  3rd int(4)  NOT NULL,
  points int(6)  NOT NULL,
  power decimal(4,2)  NOT NULL,
  percent decimal(4,2)  NOT NULL,
  ppg decimal(4,2) NOT NULL,
  buyin int(3)  NOT NULL,
  amountwon int(4)  NOT NULL,
  PRIMARY KEY  (player_id),
  KEY PRIMARY_KEY (player_id)
) TYPE=MyISAM;
#
# Dump data into Table players
#
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Alan', '5', '25', '1', '2', '1', '17', '68', '80', '3.4', '10', '60');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Becky', '5', '25', '0', '2', '2', '15', '60', '80', '3', '10', '20');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Chris', '5', '25', '2', '1', '1', '19', '76', '80', '3.8', '10', '90');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Dave', '5', '25', '0', '1', '0', '11', '44', '20', '2.2', '10', '10');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Jack', '5', '25', '1', '0', '2', '14', '56', '60', '2.8', '10', '40');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Jenn', '5', '25', '1', '0', '3', '16', '64', '80', '3.2', '10', '40');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Jill', '5', '25', '0', '3', '0', '15', '60', '60', '3', '10', '30');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'John', '5', '25', '2', '1', '1', '18', '72', '80', '3.6', '10', '90');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Mike', '5', '25', '1', '0', '0', '11', '44', '20', '2.2', '10', '40');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Tim', '5', '25', '2', '0', '0', '14', '56', '40', '2.8', '10', '80');
#
# Table structure for table `games`
#
CREATE TABLE games (
  game_id int(5) NOT NULL auto_increment,
  game_num int(5) NOT NULL,
  date date  NOT NULL,
  player_id int(5)  NOT NULL,
  entered int(3)  NOT NULL,
  place int(3)  NOT NULL,
  points int(3)  NOT NULL,
  buyin int(3)  NOT NULL,
  payout int(4)  NOT NULL,
  PRIMARY KEY  (game_id),
  KEY PRIMARY_KEY (game_id)
) TYPE=MyISAM;
#
# Dump data into Table games
#
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '3', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '2', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '1', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '4', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '5', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '6', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '7', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '8', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '9', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '10', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '1', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '3', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '5', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '7', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '9', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '10', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '8', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '6', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '4', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '2', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '8', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '1', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '2', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '9', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '10', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '3', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '4', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '5', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '6', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '7', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '8', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '7', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '6', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '4', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '1', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '10', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '2', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '3', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '5', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '9', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '5', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '1', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '2', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '3', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '4', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '9', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '7', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '6', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '10', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '8', '5', '5', '1', '10', '0');
#2

What errors do you get?

#3

Error

Static analysis:

3 errors were found during analysis.

A symbol name was expected! (near "1" at position 254)
Unexpected beginning of statement. (near "4" at position 262)
Unrecognized statement type. (near "NOT NULL" at position 266)

SQL query:

mypokersite # # # Table structure for table players # CREATE TABLE players ( player_id int(5) NOT NULL auto_increment, name varchar(30) NOT NULL, games int(5) NOT NULL, entered int(10) NOT NULL, 1st int(4) NOT NULL, 2nd int(4) NOT NULL, 3rd int(4) NOT NULL, points int(6) NOT NULL, power decimal(4,2) NOT NULL, percent decimal(4,2) NOT NULL, ppg decimal(4,2) NOT NULL, buyin int(3) NOT NULL, amountwon int(4) NOT NULL, PRIMARY KEY (player_id), KEY PRIMARY_KEY (player_id) ) TYPE=MyISAM

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘TYPE=MyISAM’ at line 23

#4

Hi @icenter

000webhost has a latest version of MYSQL. So, you have to replace TYPE=MyISAM with ENGINE=MyISAM

#
# Table structure for table `players`
#
CREATE TABLE players (
player_id int(5) NOT NULL auto_increment,
  name varchar(30)  NOT NULL,
  games int(5)  NOT NULL,
  entered int(10)  NOT NULL,
  1st int(4)  NOT NULL,
  2nd int(4)  NOT NULL,
  3rd int(4)  NOT NULL,
  points int(6)  NOT NULL,
  power decimal(4,2)  NOT NULL,
  percent decimal(4,2)  NOT NULL,
  ppg decimal(4,2) NOT NULL,
  buyin int(3)  NOT NULL,
  amountwon int(4)  NOT NULL,
  PRIMARY KEY  (player_id),
  KEY PRIMARY_KEY (player_id)
) ENGINE=MyISAM;
#
# Table structure for table `games`
#
CREATE TABLE games (
  game_id int(5) NOT NULL auto_increment,
  game_num int(5) NOT NULL,
  date date  NOT NULL,
  player_id int(5)  NOT NULL,
  entered int(3)  NOT NULL,
  place int(3)  NOT NULL,
  points int(3)  NOT NULL,
  buyin int(3)  NOT NULL,
  payout int(4)  NOT NULL,
  PRIMARY KEY  (game_id),
  KEY PRIMARY_KEY (game_id)
) ENGINE=MyISAM;
#





+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



my test.sql
-------------------


#
# Table structure for table `players`
#
CREATE TABLE players (
player_id int(5) NOT NULL auto_increment,
  name varchar(30)  NOT NULL,
  games int(5)  NOT NULL,
  entered int(10)  NOT NULL,
  1st int(4)  NOT NULL,
  2nd int(4)  NOT NULL,
  3rd int(4)  NOT NULL,
  points int(6)  NOT NULL,
  power decimal(4,2)  NOT NULL,
  percent decimal(4,2)  NOT NULL,
  ppg decimal(4,2) NOT NULL,
  buyin int(3)  NOT NULL,
  amountwon int(4)  NOT NULL,
  PRIMARY KEY  (player_id),
  KEY PRIMARY_KEY (player_id)
) ENGINE=MyISAM;
#
# Dump data into Table players
#
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Alan', '5', '25', '1', '2', '1', '17', '68', '80', '3.4', '10', '60');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Becky', '5', '25', '0', '2', '2', '15', '60', '80', '3', '10', '20');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Chris', '5', '25', '2', '1', '1', '19', '76', '80', '3.8', '10', '90');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Dave', '5', '25', '0', '1', '0', '11', '44', '20', '2.2', '10', '10');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Jack', '5', '25', '1', '0', '2', '14', '56', '60', '2.8', '10', '40');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Jenn', '5', '25', '1', '0', '3', '16', '64', '80', '3.2', '10', '40');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Jill', '5', '25', '0', '3', '0', '15', '60', '60', '3', '10', '30');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'John', '5', '25', '2', '1', '1', '18', '72', '80', '3.6', '10', '90');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Mike', '5', '25', '1', '0', '0', '11', '44', '20', '2.2', '10', '40');
INSERT INTO players (player_id, name, games, entered, 1st, 2nd, 3rd, points, power, percent, ppg, buyin, amountwon) VALUES ('', 'Tim', '5', '25', '2', '0', '0', '14', '56', '40', '2.8', '10', '80');
#
# Table structure for table `games`
#
CREATE TABLE games (
  game_id int(5) NOT NULL auto_increment,
  game_num int(5) NOT NULL,
  date date  NOT NULL,
  player_id int(5)  NOT NULL,
  entered int(3)  NOT NULL,
  place int(3)  NOT NULL,
  points int(3)  NOT NULL,
  buyin int(3)  NOT NULL,
  payout int(4)  NOT NULL,
  PRIMARY KEY  (game_id),
  KEY PRIMARY_KEY (game_id)
) ENGINE=MyISAM;
#
# Dump data into Table games
#
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '3', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '2', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '1', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '4', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '1', '2005-07-01', '5', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '6', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '7', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '8', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '9', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '2', '2005-07-02', '10', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '1', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '3', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '5', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '7', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '3', '2005-07-03', '9', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '10', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '8', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '6', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '4', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '4', '2005-07-04', '2', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '8', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '1', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '2', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '9', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '5', '2005-07-05', '10', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '3', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '4', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '5', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '6', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '6', '2005-07-06', '7', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '8', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '7', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '6', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '4', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '7', '2005-07-07', '1', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '10', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '2', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '3', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '5', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '8', '2005-07-08', '9', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '5', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '1', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '2', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '3', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '9', '2005-07-09', '4', '5', '5', '1', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '9', '5', '1', '5', '10', '40');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '7', '5', '2', '4', '10', '10');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '6', '5', '3', '3', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '10', '5', '4', '2', '10', '0');
INSERT INTO games (game_id, game_num, date, player_id, entered, place, points, buyin, payout) VALUES ('', '10', '2005-07-10', '8', '5', '5', '1', '10', '0');
1 Like