phpMyAdmin DB생성이 안됩니다.; 채택완료
$sql = " CREATE TABLE IF NOT EXISTS `synd_table` (
`ma_id` int(11) NOT NULL auto_increment,
`ma_subject` varchar(255) NOT NULL default '',
`ma_content` mediumtext NOT NULL,
`ma_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ma_ip` varchar(255) NOT NULL default '',
`ma_last_option` text NOT NULL,
PRIMARY KEY (`ma_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; ";
sql_query($sql);
오류
SQL 질의:
$sql = " CREATE TABLE IF NOT EXISTS `synd_table` ( `ma_id` int(11) NOT NULL auto_increment, `ma_subject` varchar(255) NOT NULL default '', `ma_content` mediumtext NOT NULL, `ma_time` datetime NOT NULL default '0000-00-00 00:00:00', `ma_ip` varchar(255) NOT NULL default '', `ma_last_option` text NOT NULL, PRIMARY KEY (`ma_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ";
MySQL 메시지: http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html">http://uws64-010.cafe24.com/WebMysql/themes/original/img/b_help.png" class="icon" />
#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 '$sql = " CREATE TABLE IF NOT EXISTS `synd_table` (
`ma_id` int(11) NOT NULL a' at line 1
--------관리자페이지에 생성된 관리자게시판 확인하면 다음오류가 나옵니다.
select count(*) as cnt from synd_table
1146 : Table 's8k2.synd_table' doesn't exist
error file : /adm/synd_list.php
답변 1개
CREATE TABLE IF NOT EXISTS `synd_table` ( `ma_id` int(11) NOT NULL auto_increment, `ma_subject` varchar(255) NOT NULL default '', `ma_content` mediumtext NOT NULL, `ma_time` datetime NOT NULL default '0000-00-00 00:00:00', `ma_ip` varchar(255) NOT NULL default '', `ma_last_option` text NOT NULL, PRIMARY KEY (`ma_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
이렇게 해보세요
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인