表结构为:
CREATE TABLE IF NOT EXISTS `zh_contact` (
`id` int(4) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(250) COLLATE utf8_bin NOT NULL,
`sex` int(4) NOT NULL,
`email` varchar(250) COLLATE utf8_bin NOT NULL,
`tel` varchar(250) COLLATE utf8_bin NOT NULL,
`job` varchar(250) COLLATE utf8_bin NOT NULL,
`department` varchar(250) COLLATE utf8_bin NOT NULL,
`company` varchar(250) COLLATE utf8_bin NOT NULL,
`http` varchar(250) COLLATE utf8_bin NOT NULL,
`calling` varchar(250) COLLATE utf8_bin NOT NULL,
`country` varchar(250) COLLATE utf8_bin NOT NULL,
`city` varchar(250) COLLATE utf8_bin NOT NULL,
`address` varchar(250) COLLATE utf8_bin NOT NULL,
`phone` varchar(250) COLLATE utf8_bin NOT NULL,
`fax` varchar(250) COLLATE utf8_bin NOT NULL,
`content` text COLLATE utf8_bin NOT NULL,
`addtime` datetime NOT NULL,
`check` int(4) NOT NULL,
`checkman` varchar(250) COLLATE utf8_bin NOT NULL,
`checktime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT AUTO_INCREMENT=3 ;插入数据的语句为:
INSERT INTO zh_contact (name, sex, email, tel, job, department, company, http, calling, country, city, address, phone, fax, content, addtime, check, checkman, checktime) VALUES( 'gfddf', 1, 'fshh', 'hgfd', 'hfd', 'hfgd', 'gfd', '', '', '', '', '', '', '', 0x6766647368646873, '2009-11-20 14:58:42', 0, '', '2009-11-20 14:58:53')请问是哪里出了错误啊!
CREATE TABLE IF NOT EXISTS `zh_contact` (
`id` int(4) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(250) COLLATE utf8_bin NOT NULL,
`sex` int(4) NOT NULL,
`email` varchar(250) COLLATE utf8_bin NOT NULL,
`tel` varchar(250) COLLATE utf8_bin NOT NULL,
`job` varchar(250) COLLATE utf8_bin NOT NULL,
`department` varchar(250) COLLATE utf8_bin NOT NULL,
`company` varchar(250) COLLATE utf8_bin NOT NULL,
`http` varchar(250) COLLATE utf8_bin NOT NULL,
`calling` varchar(250) COLLATE utf8_bin NOT NULL,
`country` varchar(250) COLLATE utf8_bin NOT NULL,
`city` varchar(250) COLLATE utf8_bin NOT NULL,
`address` varchar(250) COLLATE utf8_bin NOT NULL,
`phone` varchar(250) COLLATE utf8_bin NOT NULL,
`fax` varchar(250) COLLATE utf8_bin NOT NULL,
`content` text COLLATE utf8_bin NOT NULL,
`addtime` datetime NOT NULL,
`check` int(4) NOT NULL,
`checkman` varchar(250) COLLATE utf8_bin NOT NULL,
`checktime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT AUTO_INCREMENT=3 ;插入数据的语句为:
INSERT INTO zh_contact (name, sex, email, tel, job, department, company, http, calling, country, city, address, phone, fax, content, addtime, check, checkman, checktime) VALUES( 'gfddf', 1, 'fshh', 'hgfd', 'hfd', 'hfgd', 'gfd', '', '', '', '', '', '', '', 0x6766647368646873, '2009-11-20 14:58:42', 0, '', '2009-11-20 14:58:53')请问是哪里出了错误啊!
解决方案 »
- 【SQL注入】关于MySql数据库order by后注入点的疑问
- 【求助】 php 怎么截取字符串中指定内容
- PHP采集代码求助
- PHP的一个错误,请帮帮忙,在等!
- 请教关于文件列表
- 请帮忙看下下面这段利用php创建mysql数据表的源程序
- 初学者疑惑。请问在MySQL的MyISAM下,如何选用char varchar text?
- 跪求高人指点:在php中如何用什么函数可以获得远程用户IP及系统时间哈?
- 如何让留言本不支持html?
- 有那位高手跟我介绍一些php常量的用法,如HTTP_USER_AGENT,_SEESION....什么的越多越好,100分不够再加,加强货币流通
- 请大家分享一个字符串转成JS的方法……多谢了!
- 如果 控制 html编辑器把页面搞变形。
O(∩_∩)O~!