創(chuàng)建數(shù)據(jù)表出錯(cuò)，錯(cuò)誤號(hào)：1064 錯(cuò)誤原因：You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' varchar(255),LATITUDE varchar(255),DATE varchar(255),FREQUENCY ' at line 1。我寫的sql語句在數(shù)據(jù)庫中使用可以建表，但是用mysql_query執(zhí)行就報(bào)錯(cuò)了，程序如下：if($id==0){// $str0表示創(chuàng)建數(shù)據(jù)表的語句，$str表示插入時(shí)數(shù)據(jù)表的字段$str = "";$str0 = "id int unsigned not null auto_increment primary key,";$title = array();$length = sizeof($v_1);$length1 = $length-1;for ($k=0; $k <$length ; $k++) {?$title[$k] = $v_1[$k];if($k==$length1){$str .=$title[$k];$str0 .= $v_1[$k]."?"."varchar(255)";}else{$str .=$title[$k].",";$str0.=$v_1[$k]."?"."varchar(255)".",";}}$sqlTable="create table $tablename ($str0)";echo $sqlTable;$query=mysql_query($sqlTable);if($query){echo "數(shù)據(jù)表創(chuàng)建成功";}else{echo "創(chuàng)建數(shù)據(jù)表出錯(cuò)，錯(cuò)誤號(hào)：".mysql_errno()." 錯(cuò)誤原因：".mysql_error();}}
2 回答
-
mini_puff我輸出的sqlTable語句是這個(gè)：create table markdata (id int(11) unsigned not null auto_increment primary key,LONGITUDE varchar(255),LATITUDE varchar(255),DATE varchar(255),FREQUENCY varchar(255)) 在數(shù)據(jù)庫中執(zhí)行是可以的，但是放在程序中就有錯(cuò)，實(shí)在看不出是哪里有錯(cuò)
添加回答
舉報(bào)
0/150
提交
取消