gpt4 book ai didi

php - 有人可以帮忙解决 MYSQL 错误消息吗?

转载 作者:行者123 更新时间:2023-11-29 08:07:15 25 4
gpt4 key购买 nike

我正在尝试安装 php 脚本,并且有一个补丁 sql 文件应该更新数据库中的表。我可以从原始文件设置结构,但更新文件不断给我这个错误,我不知道如何修复它,我也不想把事情搞砸。

我查看了两个文件的第 72 行,它们似乎对于导致错误的行没有意义。这是我收到的消息:

“正在安装新的 1.5.1 数据库您的 SQL 语法有错误;请检查与您的 MySQL 服务器版本相对应的手册,了解在“AFTER 时间”附近使用的正确语法,PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1' 在第 72 行"

有人可以帮我解决这个问题吗? :( 谢谢!

我无法添加所有文件,因此我删除了一些我认为在第二个文件中不必要的随机内容。这是 2 个文件:

还有另外 2 个文件,名为“convert_1_0_3_to_1_5.sql”和“convert_1_5_to_1_5_1”,我已添加了使用代码进行在线笔记共享的链接:

http://shrib.com/W24OJZd3

http://shrib.com/59Wo3a9r

结构.sql:

-- phpMyAdmin SQL Dump
-- version 2.11.2deb2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 14, 2007 at 04:27 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3-1ubuntu6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


-- --------------------------------------------------------

--
-- Table structure for table `scores`
--

DROP TABLE IF EXISTS `scores`;
CREATE TABLE `scores` (
`id` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `best_scores`
--

DROP TABLE IF EXISTS `best_scores`;
CREATE TABLE `best_scores` (
`id` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `blog`
--

DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
`id` int(11) NOT NULL auto_increment,
`title` tinytext NOT NULL,
`subtitle` tinytext NOT NULL,
`content` text NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `brackets`
--

DROP TABLE IF EXISTS `brackets`;
CREATE TABLE `brackets` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(128) NOT NULL,
`email` varchar(256) NOT NULL,
`tiebreaker` int(3) NOT NULL,
`paid` tinyint(1) NOT NULL default 0 COMMENT '1=paid,0=unpaid,2=exempted',
`1` varchar(32) NOT NULL,
`2` varchar(32) NOT NULL,
`3` varchar(32) NOT NULL,
`4` varchar(32) NOT NULL,
`5` varchar(32) NOT NULL,
`6` varchar(32) NOT NULL,
`7` varchar(32) NOT NULL,
`8` varchar(32) NOT NULL,
`9` varchar(32) NOT NULL,
`10` varchar(32) NOT NULL,
`11` varchar(32) NOT NULL,
`12` varchar(32) NOT NULL,
`13` varchar(32) NOT NULL,
`14` varchar(32) NOT NULL,
`15` varchar(32) NOT NULL,
`16` varchar(32) NOT NULL,
`17` varchar(32) NOT NULL,
`18` varchar(32) NOT NULL,
`19` varchar(32) NOT NULL,
`20` varchar(32) NOT NULL,
`21` varchar(32) NOT NULL,
`22` varchar(32) NOT NULL,
`23` varchar(32) NOT NULL,
`24` varchar(32) NOT NULL,
`25` varchar(32) NOT NULL,
`26` varchar(32) NOT NULL,
`27` varchar(32) NOT NULL,
`28` varchar(32) NOT NULL,
`29` varchar(32) NOT NULL,
`30` varchar(32) NOT NULL,
`31` varchar(32) NOT NULL,
`32` varchar(32) NOT NULL,
`33` varchar(32) NOT NULL,
`34` varchar(32) NOT NULL,
`35` varchar(32) NOT NULL,
`36` varchar(32) NOT NULL,
`37` varchar(32) NOT NULL,
`38` varchar(32) NOT NULL,
`39` varchar(32) NOT NULL,
`40` varchar(32) NOT NULL,
`41` varchar(32) NOT NULL,
`42` varchar(32) NOT NULL,
`43` varchar(32) NOT NULL,
`44` varchar(32) NOT NULL,
`45` varchar(32) NOT NULL,
`46` varchar(32) NOT NULL,
`47` varchar(32) NOT NULL,
`48` varchar(32) NOT NULL,
`49` varchar(32) NOT NULL,
`50` varchar(32) NOT NULL,
`51` varchar(32) NOT NULL,
`52` varchar(32) NOT NULL,
`53` varchar(32) NOT NULL,
`54` varchar(32) NOT NULL,
`55` varchar(32) NOT NULL,
`56` varchar(32) NOT NULL,
`57` varchar(32) NOT NULL,
`58` varchar(32) NOT NULL,
`59` varchar(32) NOT NULL,
`60` varchar(32) NOT NULL,
`61` varchar(32) NOT NULL,
`62` varchar(32) NOT NULL,
`63` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `master`
--

DROP TABLE IF EXISTS `master`;
CREATE TABLE `master` (
`id` int(11) NOT NULL auto_increment,
`1` varchar(32) NOT NULL,
`2` varchar(32) NOT NULL,
`3` varchar(32) NOT NULL,
`4` varchar(32) NOT NULL,
`5` varchar(32) NOT NULL,
`6` varchar(32) NOT NULL,
`7` varchar(32) NOT NULL,
`8` varchar(32) NOT NULL,
`9` varchar(32) NOT NULL,
`10` varchar(32) NOT NULL,
`11` varchar(32) NOT NULL,
`12` varchar(32) NOT NULL,
`13` varchar(32) NOT NULL,
`14` varchar(32) NOT NULL,
`15` varchar(32) NOT NULL,
`16` varchar(32) NOT NULL,
`17` varchar(32) NOT NULL,
`18` varchar(32) NOT NULL,
`19` varchar(32) NOT NULL,
`20` varchar(32) NOT NULL,
`21` varchar(32) NOT NULL,
`22` varchar(32) NOT NULL,
`23` varchar(32) NOT NULL,
`24` varchar(32) NOT NULL,
`25` varchar(32) NOT NULL,
`26` varchar(32) NOT NULL,
`27` varchar(32) NOT NULL,
`28` varchar(32) NOT NULL,
`29` varchar(32) NOT NULL,
`30` varchar(32) NOT NULL,
`31` varchar(32) NOT NULL,
`32` varchar(32) NOT NULL,
`33` varchar(32) NOT NULL,
`34` varchar(32) NOT NULL,
`35` varchar(32) NOT NULL,
`36` varchar(32) NOT NULL,
`37` varchar(32) NOT NULL,
`38` varchar(32) NOT NULL,
`39` varchar(32) NOT NULL,
`40` varchar(32) NOT NULL,
`41` varchar(32) NOT NULL,
`42` varchar(32) NOT NULL,
`43` varchar(32) NOT NULL,
`44` varchar(32) NOT NULL,
`45` varchar(32) NOT NULL,
`46` varchar(32) NOT NULL,
`47` varchar(32) NOT NULL,
`48` varchar(32) NOT NULL,
`49` varchar(32) NOT NULL,
`50` varchar(32) NOT NULL,
`51` varchar(32) NOT NULL,
`52` varchar(32) NOT NULL,
`53` varchar(32) NOT NULL,
`54` varchar(32) NOT NULL,
`55` varchar(32) NOT NULL,
`56` varchar(32) NOT NULL,
`57` varchar(32) NOT NULL,
`58` varchar(32) NOT NULL,
`59` varchar(32) NOT NULL,
`60` varchar(32) NOT NULL,
`61` varchar(32) NOT NULL,
`62` varchar(32) NOT NULL,
`63` varchar(32) NOT NULL,
`64` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `meta`
--

DROP TABLE IF EXISTS `meta`;
CREATE TABLE `meta` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(64) NOT NULL,
`subtitle` varchar(128) NOT NULL,
`name` varchar(128) NOT NULL,
`email` varchar(128) NOT NULL,
`cost` double NOT NULL,
`cut` double NOT NULL,
`cutType` int(1) NOT NULL COMMENT '1=percent, 0=dollars',
`closed` tinyint(1) NOT NULL COMMENT '1=submission is closed',
`sweet16` tinyint(1) NOT NULL COMMENT '1=sweet 16 has started',
`round64Value` int(11) NOT NULL,
`round32Value` int(11) NOT NULL,
`sweet16Value` int(11) NOT NULL,
`elite8Value` int(11) NOT NULL,
`final4Value` int(11) NOT NULL,
`champValue` int(11) NOT NULL,
`rules` text NOT NULL,
`mail` int(1) NOT NULL,
`tiebreaker` int(3),
`region1` varchar(64) NOT NULL,
`region2` varchar(64) NOT NULL,
`region3` varchar(64) NOT NULL,
`region4` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

结构_1_5_1.sql:

# Dump of table best_scores
# ------------------------------------------------------------

DROP TABLE IF EXISTS `best_scores`;

CREATE TABLE `best_scores` (
`id` int(11) NOT NULL DEFAULT '0',
`name` varchar(128) NOT NULL DEFAULT '',
`score` double NOT NULL DEFAULT '0',
`scoring_type` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`scoring_type`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table blog
# ------------------------------------------------------------

DROP TABLE IF EXISTS `blog`;

CREATE TABLE `blog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` tinytext NOT NULL,
`subtitle` tinytext NOT NULL,
`content` text NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table brackets
# ------------------------------------------------------------

DROP TABLE IF EXISTS `brackets`;

CREATE TABLE `brackets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person` text NOT NULL,
`name` varchar(128) NOT NULL DEFAULT '',
`email` text NOT NULL,
`tiebreaker` int(3) NOT NULL DEFAULT '0',
`paid` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=paid,0=unpaid,2=exempted',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'time bracket was submitted',
`1` varchar(32) NOT NULL DEFAULT '',
`2` varchar(32) NOT NULL DEFAULT '',
`3` varchar(32) NOT NULL DEFAULT '',
`4` varchar(32) NOT NULL DEFAULT '',
`5` varchar(32) NOT NULL DEFAULT '',
`6` varchar(32) NOT NULL DEFAULT '',
`7` varchar(32) NOT NULL DEFAULT '',
`8` varchar(32) NOT NULL DEFAULT '',
`9` varchar(32) NOT NULL DEFAULT '',
`10` varchar(32) NOT NULL DEFAULT '',
`11` varchar(32) NOT NULL DEFAULT '',
`12` varchar(32) NOT NULL DEFAULT '',
`13` varchar(32) NOT NULL DEFAULT '',
`14` varchar(32) NOT NULL DEFAULT '',
`15` varchar(32) NOT NULL DEFAULT '',
`16` varchar(32) NOT NULL DEFAULT '',
`17` varchar(32) NOT NULL DEFAULT '',
`18` varchar(32) NOT NULL DEFAULT '',
`19` varchar(32) NOT NULL DEFAULT '',
`20` varchar(32) NOT NULL DEFAULT '',
`21` varchar(32) NOT NULL DEFAULT '',
`22` varchar(32) NOT NULL DEFAULT '',
`23` varchar(32) NOT NULL DEFAULT '',
`24` varchar(32) NOT NULL DEFAULT '',
`25` varchar(32) NOT NULL DEFAULT '',
`26` varchar(32) NOT NULL DEFAULT '',
`27` varchar(32) NOT NULL DEFAULT '',
`28` varchar(32) NOT NULL DEFAULT '',
`29` varchar(32) NOT NULL DEFAULT '',
`30` varchar(32) NOT NULL DEFAULT '',
`31` varchar(32) NOT NULL DEFAULT '',
`32` varchar(32) NOT NULL DEFAULT '',
`33` varchar(32) NOT NULL DEFAULT '',
`34` varchar(32) NOT NULL DEFAULT '',
`35` varchar(32) NOT NULL DEFAULT '',
`36` varchar(32) NOT NULL DEFAULT '',
`37` varchar(32) NOT NULL DEFAULT '',
`38` varchar(32) NOT NULL DEFAULT '',
`39` varchar(32) NOT NULL DEFAULT '',
`40` varchar(32) NOT NULL DEFAULT '',
`41` varchar(32) NOT NULL DEFAULT '',
`42` varchar(32) NOT NULL DEFAULT '',
`43` varchar(32) NOT NULL DEFAULT '',
`44` varchar(32) NOT NULL DEFAULT '',
`45` varchar(32) NOT NULL DEFAULT '',
`46` varchar(32) NOT NULL DEFAULT '',
`47` varchar(32) NOT NULL DEFAULT '',
`48` varchar(32) NOT NULL DEFAULT '',
`49` varchar(32) NOT NULL DEFAULT '',
`50` varchar(32) NOT NULL DEFAULT '',
`51` varchar(32) NOT NULL DEFAULT '',
`52` varchar(32) NOT NULL DEFAULT '',
`53` varchar(32) NOT NULL DEFAULT '',
`54` varchar(32) NOT NULL DEFAULT '',
`55` varchar(32) NOT NULL DEFAULT '',
`56` varchar(32) NOT NULL DEFAULT '',
`57` varchar(32) NOT NULL DEFAULT '',
`58` varchar(32) NOT NULL DEFAULT '',
`59` varchar(32) NOT NULL DEFAULT '',
`60` varchar(32) NOT NULL DEFAULT '',
`61` varchar(32) NOT NULL DEFAULT '',
`62` varchar(32) NOT NULL DEFAULT '',
`63` varchar(32) NOT NULL DEFAULT '',
`eliminated` BOOL NOT NULL DEFAULT '0' COMMENT 'Equals 1 when eliminated' AFTER `time`,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table end_games
# ------------------------------------------------------------

DROP TABLE IF EXISTS `end_games`;

CREATE TABLE `end_games` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`49` varchar(32) DEFAULT NULL,
`50` varchar(32) DEFAULT NULL,
`51` varchar(32) DEFAULT NULL,
`52` varchar(32) DEFAULT NULL,
`53` varchar(32) DEFAULT NULL,
`54` varchar(32) DEFAULT NULL,
`55` varchar(32) DEFAULT NULL,
`56` varchar(32) DEFAULT NULL,
`57` varchar(32) DEFAULT NULL,
`58` varchar(32) DEFAULT NULL,
`59` varchar(32) DEFAULT NULL,
`60` varchar(32) DEFAULT NULL,
`61` varchar(32) DEFAULT NULL,
`62` varchar(32) DEFAULT NULL,
`63` varchar(32) DEFAULT NULL,
`round` int(11) DEFAULT NULL,
`eliminated` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table master
# ------------------------------------------------------------

DROP TABLE IF EXISTS `master`;

CREATE TABLE `master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`1` varchar(32) NOT NULL DEFAULT '',
`2` varchar(32) NOT NULL DEFAULT '',
`3` varchar(32) NOT NULL DEFAULT '',
`4` varchar(32) NOT NULL DEFAULT '',
`5` varchar(32) NOT NULL DEFAULT '',
`6` varchar(32) NOT NULL DEFAULT '',
`7` varchar(32) NOT NULL DEFAULT '',
`8` varchar(32) NOT NULL DEFAULT '',
`9` varchar(32) NOT NULL DEFAULT '',
`10` varchar(32) NOT NULL DEFAULT '',
`11` varchar(32) NOT NULL DEFAULT '',
`12` varchar(32) NOT NULL DEFAULT '',
`13` varchar(32) NOT NULL DEFAULT '',
`14` varchar(32) NOT NULL DEFAULT '',
`15` varchar(32) NOT NULL DEFAULT '',
`16` varchar(32) NOT NULL DEFAULT '',
`17` varchar(32) NOT NULL DEFAULT '',
`18` varchar(32) NOT NULL DEFAULT '',
`19` varchar(32) NOT NULL DEFAULT '',
`20` varchar(32) NOT NULL DEFAULT '',
`21` varchar(32) NOT NULL DEFAULT '',
`22` varchar(32) NOT NULL DEFAULT '',
`23` varchar(32) NOT NULL DEFAULT '',
`24` varchar(32) NOT NULL DEFAULT '',
`25` varchar(32) NOT NULL DEFAULT '',
`26` varchar(32) NOT NULL DEFAULT '',
`27` varchar(32) NOT NULL DEFAULT '',
`28` varchar(32) NOT NULL DEFAULT '',
`29` varchar(32) NOT NULL DEFAULT '',
`30` varchar(32) NOT NULL DEFAULT '',
`31` varchar(32) NOT NULL DEFAULT '',
`32` varchar(32) NOT NULL DEFAULT '',
`33` varchar(32) NOT NULL DEFAULT '',
`34` varchar(32) NOT NULL DEFAULT '',
`35` varchar(32) NOT NULL DEFAULT '',
`36` varchar(32) NOT NULL DEFAULT '',
`37` varchar(32) NOT NULL DEFAULT '',
`38` varchar(32) NOT NULL DEFAULT '',
`39` varchar(32) NOT NULL DEFAULT '',
`40` varchar(32) NOT NULL DEFAULT '',
`41` varchar(32) NOT NULL DEFAULT '',
`42` varchar(32) NOT NULL DEFAULT '',
`43` varchar(32) NOT NULL DEFAULT '',
`44` varchar(32) NOT NULL DEFAULT '',
`45` varchar(32) NOT NULL DEFAULT '',
`46` varchar(32) NOT NULL DEFAULT '',
`47` varchar(32) NOT NULL DEFAULT '',
`48` varchar(32) NOT NULL DEFAULT '',
`49` varchar(32) NOT NULL DEFAULT '',
`50` varchar(32) NOT NULL DEFAULT '',
`51` varchar(32) NOT NULL DEFAULT '',
`52` varchar(32) NOT NULL DEFAULT '',
`53` varchar(32) NOT NULL DEFAULT '',
`54` varchar(32) NOT NULL DEFAULT '',
`55` varchar(32) NOT NULL DEFAULT '',
`56` varchar(32) NOT NULL DEFAULT '',
`57` varchar(32) NOT NULL DEFAULT '',
`58` varchar(32) NOT NULL DEFAULT '',
`59` varchar(32) NOT NULL DEFAULT '',
`60` varchar(32) NOT NULL DEFAULT '',
`61` varchar(32) NOT NULL DEFAULT '',
`62` varchar(32) NOT NULL DEFAULT '',
`63` varchar(32) NOT NULL DEFAULT '',
`64` varchar(32) NOT NULL DEFAULT '',
`type` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `master` (`id`,`type`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`, `10`, `11`, `12`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `24`, `25`, `26`, `27`, `28`, `29`, `30`, `31`, `32`, `33`, `34`, `35`, `36`, `37`, `38`, `39`, `40`, `41`, `42`, `43`, `44`, `45`, `46`, `47`, `48`, `49`, `50`, `51`, `52`, `53`, `54`, `55`, `56`, `57`, `58`, `59`, `60`, `61`, `62`, `63`, `64`) VALUES
(4, 'seeds','1', '16', '8', '9', '5', '12', '4', '13', '6', '11', '3', '14', '7', '10', '2', '15', '1', '16', '8', '9', '5', '12', '4', '13', '6', '11', '3', '14', '7', '10', '2', '15', '1', '16', '8', '9', '5', '12', '4', '13', '6', '11', '3', '14', '7', '10', '2', '15', '1', '16', '8', '9', '5', '12', '4', '13', '6', '11', '3', '14', '7', '10', '2', '15');



# Dump of table meta
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meta`;

CREATE TABLE `meta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(64) NOT NULL,
`subtitle` varchar(128) NOT NULL,
`name` varchar(128) NOT NULL,
`email` varchar(128) NOT NULL,
`cost` double NOT NULL,
`cut` double NOT NULL,
`cutType` int(1) NOT NULL COMMENT '1=percent, 0=dollars',
`closed` tinyint(1) NOT NULL COMMENT '1=submission is closed',
`sweet16` tinyint(1) NOT NULL COMMENT '1=sweet 16 has started',
`rules` text NOT NULL,
`mail` int(1) NOT NULL,
`tiebreaker` int(3) DEFAULT NULL,
`region1` varchar(64) NOT NULL,
`region2` varchar(64) NOT NULL,
`region3` varchar(64) NOT NULL,
`region4` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table passwords
# ------------------------------------------------------------

DROP TABLE IF EXISTS `passwords`;

CREATE TABLE `passwords` (
`label` varchar(255) CHARACTER SET latin1 NOT NULL,
`value` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
PRIMARY KEY (`label`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used for user login validation';



# Dump of table possible_scores
# ------------------------------------------------------------

DROP TABLE IF EXISTS `possible_scores`;

CREATE TABLE `possible_scores` (
`outcome_id` int(11) DEFAULT NULL,
`bracket_id` int(11) DEFAULT NULL,
`score` double DEFAULT NULL,
`type` char(32) DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
`eliminated` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table possible_scores_eliminated
# ------------------------------------------------------------

DROP TABLE IF EXISTS `possible_scores_eliminated`;

CREATE TABLE `possible_scores_eliminated` (
`outcome_id` int(11) DEFAULT NULL,
`bracket_id` int(11) DEFAULT NULL,
`score` double DEFAULT NULL,
`type` char(32) DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
`eliminated` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table scores
# ------------------------------------------------------------

DROP TABLE IF EXISTS `scores`;

CREATE TABLE `scores` (
`id` int(11) NOT NULL DEFAULT '0',
`name` varchar(128) NOT NULL DEFAULT '',
`score` double NOT NULL DEFAULT '0',
`scoring_type` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`scoring_type`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table scoring
# ------------------------------------------------------------

DROP TABLE IF EXISTS `scoring`;

CREATE TABLE `scoring` (
`seed` int(11) NOT NULL DEFAULT '0',
`1` double DEFAULT NULL,
`2` double DEFAULT NULL,
`3` double DEFAULT NULL,
`4` double DEFAULT NULL,
`5` double DEFAULT NULL,
`6` double DEFAULT NULL,
`type` char(255) DEFAULT NULL,
KEY `system` (`type`,`seed`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table scoring_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `scoring_info`;

CREATE TABLE `scoring_info` (
`type` varchar(255) NOT NULL DEFAULT '',
`display_name` varchar(255) DEFAULT NULL,
`description` blob,
PRIMARY KEY (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `scoring_info` (`type`, `display_name`, `description`) VALUES

//////////我删除了大量随机垃圾/////////////////

DROP TABLE IF EXISTS `comments`;


CREATE TABLE IF NOT EXISTS `comments` (
`id` int(11) NOT NULL auto_increment,
`bracket` int(11) NOT NULL,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`from` tinytext NOT NULL,
`subject` tinytext NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `probability_of_winning`;

CREATE TABLE IF NOT EXISTS `probability_of_winning` (
`id` int(11) DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
`probability_win` double DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

最佳答案

错误在这里:

`eliminated` BOOL NOT NULL DEFAULT '0' COMMENT 'Equals 1 when eliminated' AFTER `time`,

您输入了错误的引号。应该是:

`eliminated` BOOL NOT NULL DEFAULT '0' COMMENT 'Equals 1 when eliminated `AFTER` time',

或者如果“AFTER time”不应该出现:

`eliminated` BOOL NOT NULL DEFAULT '0' COMMENT 'Equals 1 when eliminated',

关于php - 有人可以帮忙解决 MYSQL 错误消息吗?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/22463434/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com