出现MysqlError:MySQL Query Error的处理方法

meng

xinge1984

请问官方的大大：

出现：
query:SHOW CREATE TABLE tongxunquan.net.job_ad|errno:1064|error: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 \'.job_ad\' at line 1|errmsg:MySQL Query Error  

怎么解决？

cnawe

CREATE TABLE `job_service_log` (`s_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,`s_gname` VARCHAR( 200 ) NOT NULL ,`s_startdate` DATE NOT NULL ,`s_enddate` DATE NOT NULL ,`s_mid` INT NOT NULL ,`s_operator` VARCHAR( 50 ) NOT NULL ,`s_adddate` DATETIME NOT NULL ,`s_type` TINYINT( 1 ) NOT NULL ,`s_ip` VARCHAR( 20 ) NOT NULL ,`s_money` SMALLINT NOT NULL ,PRIMARY KEY ( `s_id` ) ) ENGINE = MYISAM DEFAULT CHARSET=gbk|errno:1050|error:Table \'job_service_log\' already exists|errmsg:MySQL Query Error  

这如何解决。

不下雨的星期天

query:|errno:0|error:|errmsg:Can not connect to MySQL server   什么原因

不下雨的星期天

query:SELECT COUNT(*) as num FROM `job_hire` INNER JOIN `job_member` on `h_comid`=`m_id` WHERE `m_flag`=1 and DATEDIFF(`m_startdate`,\'2012-04-03\')<=0 AND DATEDIFF(`m_enddate`,\'2012-04-03\')>=0 AND DATEDIFF(`h_enddate`,\'2012-04-03\')>=0 AND `h_status`=1 AND (`h_position` LIKE \'%教师*中等教育（语文）%\') AND (`h_workadd` like \'%山西省*临汾市*隰县%\')|errno:1030|error:Got error 22 from storage engine|errmsg:MySQL Query Error

1457982904

query:INSERT INTO job_member ( )
VALUES( )
errno:1064
error: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 \'\'admin)\' at line 1
errmsg:MySQL Query Error

rstar

支持个。 。。

lianjiangdai

safe error 1001不能发布资讯  求解决

lianjiangdai

qq11660235

query:INSERT INTO job_member (m_login,m_pwd,m_email,m_typeid,m_groupid,m_name,m_licence,m_trade,m_seat,m_ecoclass,m_fund,m_founddate,m_workers,m_introduce,m_contact,m_tel,m_fax,m_mobile,m_chat,m_url,m_address,m_post,m_regdate,m_logindate,m_loginip,m_loginnum,m_integral,m_flag,m_startdate,m_enddate,m_hirenum,m_expertnum,m_myinterviewnum,m_recyclenum,m_contactnum,m_smsnum,m_site,m_operator) VALUES(\'dsad\',\'81dc9bdb52d04dc20036dbd8313ed055\',\'1114521@qq.com\',\'2\',\'4\',\'15156156\',\'\',\'计算机软件\',\'北京*北京市*西城区\',\'集体企业\',\'\',\'2012-06-21\',\'少于50人\',\' dasdsadsadsadsa\',\'sadsadsa\',\'4325423543\',\'\',\'\',\'\',\'\',\'\',\'\',\'2012-06-12 09:46:49\',\'2012-06-12 09:46:49\',\'61.145.71.122\',\'1\',\'5\',\'1\',\'2012-06-12\',\'2020-06-12\',\'15\',\'15\',\'25\',\'50\',\'25\',\'25\',\'0\',\'admin)|errno:1064|error: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 \'\'admin)\' at line 1|errmsg:MySQL Query Error