代碼: 選擇全部
SQL 語法 :
CREATE TABLE `phpbb_topictypes` (
`topic_types` VARCHAR( 10 ) NOT NULL
) ALTER TABLE `phpbb_forums` ADD `forum_topictypes` VARCHAR( 255 ) NOT NULL DEFAULT '' ALTER TABLE `phpbb_forums` ADD `forum_topictypes_force` TINYINT( 2 ) DEFAULT '0' NOT NULL ALTER TABLE `phpbb_topics` ADD `topic_types` VARCHAR( 10 ) NOT NULL INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'topictypes_color', 'brown'
)
MySQL 傳回：
#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 'ALTER TABLE `phpbb_forums` ADD `forum_topictypes` VARCHAR(關於你的問題monthday 寫:我貼上它所提供的SQL碼,真不支倒要怎麼裝代碼: 選擇全部
SQL 語法 : CREATE TABLE `phpbb_topictypes` ( `topic_types` VARCHAR( 10 ) NOT NULL ) ALTER TABLE `phpbb_forums` ADD `forum_topictypes` VARCHAR( 255 ) NOT NULL DEFAULT '' ALTER TABLE `phpbb_forums` ADD `forum_topictypes_force` TINYINT( 2 ) DEFAULT '0' NOT NULL ALTER TABLE `phpbb_topics` ADD `topic_types` VARCHAR( 10 ) NOT NULL INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'topictypes_color', 'brown' ) MySQL 傳回： #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 'ALTER TABLE `phpbb_forums` ADD `forum_topictypes` VARCHAR(
代碼: 選擇全部
CREATE TABLE `phpbb_topictypes` (`topic_types` VARCHAR( 20 ) NOT NULL);
ALTER TABLE `phpbb_forums` ADD `forum_topictypes` VARCHAR( 255 ) NOT NULL DEFAULT '';
ALTER TABLE `phpbb_forums` ADD `forum_topictypes_force` TINYINT( 2 ) DEFAULT '0' NOT NULL;
ALTER TABLE `phpbb_topics` ADD `topic_types` VARCHAR( 20 ) NOT NULL;
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('topictypes_color', 'brown');