附上数据库信息:
CREATE TABLE IF NOT EXISTS `customer` ( `id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `solutation` varchar(40) NOT NULL, `phone` varchar(50) NOT NULL, `company` varchar(100) NOT NULL, `mobile` varchar(50) NOT NULL, `source` varchar(50) NOT NULL, `sdate` date NOT NULL, `job` varchar(50) NOT NULL, `web` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `createtime` datetime NOT NULL, `modifiedtime` datetime DEFAULT NULL, `note` varchar(500) NOT NULL ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;