dougong5817 2015-11-25 06:45
浏览 114

MySQL问题:不正确的整数值:第1列的''

For the following sql statements (inside of php):

$sql = "CREATE TABLE {$value}_GAMES ( ".  // Creating a new table for each team
    "nfl_game_id INT NOT NULL, ".
    "team VARCHAR(3) NOT NULL, ".
    "opponent VARCHAR(3) NOT NULL, ".
    "totfd INT NOT NULL, ".
    "totyds INT NOT NULL, ".
    "pyds INT NOT NULL, ".
    "ryds INT NOT NULL, ".
    "pen INT NOT NULL, ".
    "penyds INT NOT NULL, ".
    "trnovr INT NOT NULL, ".
    "pt INT NOT NULL, ".
    "ptyds INT NOT NULL, ".
    "ptavg INT NOT NULL, ".
    "PRIMARY KEY ( nfl_game_id ));";

$retval = mysql_query($sql, $con); // Execute SQL Code
if(! $retval)
{
die('Could not create table: ' . mysql_error());

$sql = "INSERT INTO {$value}_GAMES(nfl_game_id, team, opponent, totfd, ".
"totyds, pyds, ryds, pen, penyds, trnovr, pt, ptyds, ptavg)".
"VALUES('$game', '$team', '$opponent', '$totfirstdown', '$totyds',".
"'$pyds', '$ryds', '$pen', '$penyds', '$trnovr', '$pt', '$ptyds', ".
"'$ptavg')";
$ret_val = mysql_query($sql,$con); // Execute SQL Code
if(! $ret_val)
{
    die('Could not add JSON data to table: ' . mysql_error());
}

I'm getting the following error:

Could not add JSON data to table: Incorrect integer value: '' for column 'nfl_game_id' at row 1

When I echo the API call, this is what the data looks like:

[{"nfl_game_id":2009081350,"team":"ARI","opponent":"PIT","totfd":22,"totyds":329‌​,"pyds":259,"ryds":70,"pen":4,"penyds":27,"trnovr":2,"pt":6,"ptyds":266,"ptavg":3‌​7}, .....

Any idea what's going on?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 MATLAB中streamslice问题
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 51单片机中C语言怎么做到下面类似的功能的函数(相关搜索:c语言)
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端