php - mysql - 创建更长的内容表

Question

我想为页面内容创建一个大存储空间。这是我尝试过的:

CREATE TABLE `pages` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`content` varchar(65) NOT NULL default '',
`author` MEDIUMBLOB() NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- 
-- Dumping data for table `pages`
--
INSERT INTO `members` VALUES (1, 'test', 'TEST_TEST_TEST');

我得到错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server           version for the right syntax to use near '() NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2' at line 5 

有什么建议吗？

Answer 1

试试这个:

CREATE TABLE `pages` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(65) NOT NULL,
    `content` LONGTEXT NOT NULL,
    `author` MEDIUMBLOB NOT NULL,
    PRIMARY KEY (`id`)
)
ENGINE=MyISAM;