php - #1064 - You have an error in your SQL check the manual that corresponds to your MySQL server version for the right syntax - Stack Overflow
to customize your list.
Announcing Stack Overflow Documentation
We started with Q&A. Technical documentation is next, and we need your help.
Whether you're a beginner or an experienced developer, you can contribute.
I want to create a table using the following script:
mysql_query("create table `".$mysql_table_prefix."query_log` (
query varchar(255),
time timestamp(14),
elapsed float(2),
results int,
key query_key(query)
It gives me this error:
#1064 - You have an error in your SQL check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_query("create table `".$mysql_table_prefix."query_log` ( query varchar(25' at line 1
EDIT: I used sql tab in phpMyAdmin
What can I do?
You're using PHP in a place that expects plain SQL (note that the OP stated "I used sql tab in phpMyAdmin").
Cut it down to:
create table `query_log` (
query varchar(255),
time timestamp,
elapsed float(2),
results int,
key query_key(query)
And @Aurelio is right, there's no length parameter to timestamp.
6,79985378
The first error I see is that timestamp does not have a lenght. So this line:
time timestamp(14),
should be like this:
time timestamp,
14.8k73359
Give your error message, you've screwed up the code somehow, such that the PHP mysql_query call is being treated as a string, then passed into mysql_query() directly. Possibly an unbalanced ' on a previous line is causing this.
... syntax to use near 'mysql_query("create table ...
A properly constructed query string would never have a literal PHP function call in it.
If you are passing a PHP script to mysql directly at the command line, e.g.
$ mysql & somescript.php
this will also not work. MySQL will not execute that script. It will attempt to load the raw text of code the literally.
264k23215338
You could declare the whole text before passing it to the function:
$params="create table `".$mysql_table_prefix."query_log` (
query varchar(255),
time timestamp(14),
elapsed float(2),
results int,
key query_key(query)
mysql_query($params);
Your Answer
Sign up or
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Post as a guest
By posting your answer, you agree to the
Not the answer you're looking for?
Browse other questions tagged
Stack Overflow works best with JavaScript enabledMYSQL建表时出现错误#1064 - You have an error in your SQL..._百度知道
MYSQL建表时出现错误#1064 - You have an error in your SQL...
'( &#39,'id'id'uid&#39,PRIMARY KEY ( &#39，第一次建表就出现错误真杯具,&#39,'0' ) ) ENGINE = InnoDB default CHARSET = gbk AUTO_INCREMENT =5, ' check the manual that corresponds to your MySQL server version for the right syntax to use near 'test&#39：CREATE TABLE ' at line 1代码如下;;('
NOT NULL ：#1064 - You have an error in your SQLid'uid'remark'
varchar( 10 )
default 'regdate'tes1&#39：错误提示; varchar(10) not null defau'
AUTO_INCREMENT 刚学MYSQL; int(10) not null auto_increment
提问者采纳
表不用带&#39,uid
varchar( 10 )
default &#39,,还有;,在mysql中,不是在后面加的,正确的代码如下,而是直接在字段后面加;0&#39:CREATE TABLE test(id
PRIMARY KEY
AUTO_INCREMENT ,regdate
NOT NULL ,remark text) ENGINE = InnoDB default CHARSET = gbk AUTO_INCREMENT =5;&#39
相关专业回答
这样写语法不对吧, values后面每一行不能简单用逗号连, 应该这样写
insert into 'pre_common_district' (`id`, `name`, `level`, `usetype`, `upid`, `displayorder`)
select 12599, '河东街道', 4, 0, 1695, 0 union
select 12600, '玉泉镇', 4, 0, 1695, 0 union
或者你为每一行写一个insert into语句也行,如:
insert into 'pre_common...
其他类似问题
8人觉得有用
为您推荐：
mysql的相关知识
其他2条回答
你你程序里面的单引号都取消
按照下面回答的输入怎么会出现error &:No database selected,求帮忙
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁Rate this:
PROCEDURE `FetchSupplierByRequest`(intConferenceId int, intRank int,intTableNo int)
SELECT Distinct
c.CompanyName,
conferencetabletop cp,
companies c,
cp.ConferenceID = intConferenceId
c.ID = m.SupplierID
and m.AgendaID=cp.ConferenceId
and m.Rank=intRank
m.CreatedDate DESC
LIMIT 0, intTableNo;
showing the error when its upload in server .
error: #1064 - You have an error in your SQL check the manual that corresponds to your MySQL server version for the right syntax to use near 'intTableNo' at line 19
Posted 20-Jan-14 19:35pm
Solution 1
According to the information I can find, older versions of MySQL cannot use variables in the LIMIT clause and constants must be used.
Similar issue posted to StackOverflow with some useful information.
Posted 22-Jan-14 11:51am
<button class="toolbar" onclick="InsertText('&l' + 't;');" title="Insert HTML Extended Character Code For &&&
Strip HTML
Encode HTML
Paste as-is
Code block
Quoted Text
Best guess
When answering a question please:
Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad
spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or
edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.
This content, along with any associated source code and files, is licensed under
Last Updated 22 Jan 2014
Copyright & ,
All Rights Reserved.
CodeProject,
503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada
+1 416-849-8900 x 100内蒙古赤峰市敖汉旗委书记 的翻译是：Aohan banner in chifeng city of Inner Mongolia Committee secretaries 中文翻译英文意思，翻译英语
请在下面的文本框内输入文字，然后点击开始翻译按钮进行翻译，如果您看不到结果，请重新翻译！
内蒙古赤峰市敖汉旗委书记
选择语言：从
罗马尼亚语
罗马尼亚语
Appointed secretary of the Chifeng Aohanqi
Aohan banner in chifeng city of Inner Mongolia Committee secretaries
Inner Mongolia Chifeng City and Han-flag Committee Secretary
The Inner Mongolian Chifeng haughty Chinese flag entrusts secretary
相关内容&aThe Mexican peso is nine point thirty-two today 墨西哥比索今天是九点三十二 & a如果我是魔术师 If I am a magician & athe turnover drainage opening 转交排水设备开头 & aв которых предусматриваются совмещение производственных профессий 在哪些他们为生产行业的组合提供 & a我们学习英语是为了跟好的与外国人交流 正在翻译，请等待...
& a妻子你说我的英语水平很高了？ The wife you said my English proficiency was very high? & a物资局 Oficina de la materia & a推力 Thrust force & apain pass quickly 正在翻译，请等待... & a一个被遗忘的女人 The woman who forgets & a河南省洛阳市南兆域地区是洛阳市统筹城乡改革发展试验区、城乡一体化示范区。 South the Henan Province Luoyang the boundary of a burial mound area is Luoyang plans the city and countryside reform development pilot area, the city and countryside integration model district. & aa poem 一首诗 & a希望得到面试机会 The hope obtains interviews the opportunity & a请你出示工作证 Asks you to show the work identification & a可是我们现在不在同一所大学了 But we now not in identical university & a你是我这辈子唯一爱过的人 You are my this whole life has only loved the human & aEtihad Airways EY Etihad Airways EY & aＭemory abstruse eyes. Memory abstruse eyes. & apressing is as important to the prfessional look as any sewing operation 按是一样重要对prfessional神色象所有缝合的操作 & a祝你步步高升 Wishes you to make steady progress & aNotarization: photocopy conforming to the original
& a请输入您需要翻译的文本！don't break my heart don't break my heart & a我在用电脑翻译一句给你回一句，因为我不太会英语 I am using computer translation one to return to one to you, because I not too speak English & aMy star sign is Scorpius 我的星标志是Scorpius & awhat are you doing today? 您今天做着什么？ & a总结探讨和一些建议 正在翻译，请等待... & aBase Ports 基本的口岸 & a有句俗话说的好 Has good which a slang said & aWell, Mary, how are you?
I’m fine 很好，玛丽，你好吗? 我优良是 & a艾菲努尔 正在翻译，请等待... & a由他制定的计划很容易实施 The plan formulates which by him is very easy to implement & a她十七岁就成为一名滑冰冠军 正在翻译，请等待... & a就职单位 Takes office the unit & aSami，I love you.you,If I come back,I want to marry you Sami，我爱you.you，如果我回来，我想要与您结婚 & aQLogic QLogic & a难道你是外国人？ Are you the foreigner? & aPromo code "Enter promo code" is invalid. 电视节目预告代码“键入电视节目预告代码”是无效的。 & a1976年，唐山发生大地震 In 1976, Tangshan had the big earthquake & ais the largest country in the Indian Subcontinent and shares borders with Pakistan to the west, China and Nepal to the north, Bhutan to the north-east, and Bangladesh and Myanmar to the east. Sri Lanka, the Maldives and Indonesia lie to the south-east in the Indian Ocean. It is the seventh largest country in the world
是最大的国家在印第安次大陆并且与巴基斯坦分享边界到西部、中国和尼泊尔到北部，不丹到东北部和孟加拉国和缅甸到东部。 斯里南卡、马尔代夫和印度尼西亚对东南部在印度洋在。 它是第七大国家在世界由区域，并且，与在十亿个人，其次仅是对中国在人口。 它是一个极端不同的国家，以在地理、气候、文化、语言和种族上的浩大的区别横跨它的浩瀚，并且自傲在是最大的民主在地球上。 & a不要坐在沙发上，坐到阳台上。 正在翻译，请等待... & a你知道吗我很在乎你 你知道吗我很在乎你 & a那位知情者坚持要打110 That insider persisted must hit 110 & a假如我们之间的距离是一百步，只要你迈出第一步，我就会走完剩余的九十九步 If between us the distance is 100 steps, so long as you step out first step, I can walk the surplus 99 steps & a神话哥 Myth elder brother & aJoe went into the room behind his shop,put the piece of meat into the fridge 乔进入屋子在他的商店之后，放肉片入冰箱 & aThere is a kind of concern which is the distant appreciation 有是遥远的欣赏的一关心 & aLEEKAY LEEKAY & a橄榄菜炒豆角 Chinese olive vegetable parched beans angle & aDoesn't matter I am used to, but not really don't care about anything ... 不事关我用于，但对任何东西不真正地不关心… & aI don't know what I want is just ordinary, simple, is enough. 我不知道什么我想要是公正普通的，简单，是足够。 & aI will find my way
I want a different way 我将寻找我想要一个不同的方式的我的道路 & amysql#1064 - You have an error in your SQL check the manual that correspo mysql#1064 -您有一个错误在您的SQL句法; 检查correspo的指南 & aJoe went into the room behind his shop,put the piece of meat into the fridge,took it out again and closed the door with lost of noise 乔进入屋子在他的商店之后，放肉片入冰箱，再采取了它并且关闭了门与失去噪声 & aNever be dependent anyone in this world . Because even your shadow leaves you when you’re in the dark 不要是依赖任何人于这个世界。 由于甚而您的阴影离开您，当您是在黑暗 & a内蒙古赤峰市敖汉旗委书记 The Inner Mongolian Chifeng haughty Chinese flag entrusts secretary &