469,603 Members | 2,069 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

MySql Syntax error

The follow SQL expressions don't work in MySQL:

UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29' AND
Done = 0
UPDATE calendar SET Date = '2004-01-29' WHERE ((Date < '2004-01-29') AND
(Done = 0))
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29') AND
(Done = 0)
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29' AND
Done = 0)

does not work. (I get error "1030 - got error 134 from table handler").

yet
UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29'
and
UPDATE calendar SET Date = '2004-01-29' WHERE Done = 0
do work.

Any ideas on what might be wrong?

What we are trying to do is update a task list so that all uncompleted
tasks are set to the current date. Done is a tinyint and Date is a Date
field.

Thanks.
Jul 19 '05 #1
6 1786
ch*****@nospaamteamlit.com wrote:
The follow SQL expressions don't work in MySQL:

UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29' AND
Done = 0
UPDATE calendar SET Date = '2004-01-29' WHERE ((Date < '2004-01-29') AND
(Done = 0))
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29') AND
(Done = 0)
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29' AND
Done = 0)

does not work. (I get error "1030 - got error 134 from table handler").


this kind of error does not indicate a syntax error.
more likely, your table has errors. you can test this and repair the
table if necessary. i suggest you read about this topic in the manual
(seems to be section 5.5).

steven.
Jul 19 '05 #2
ch*****@nospaamteamlit.com wrote:
The follow SQL expressions don't work in MySQL:

UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29' AND
Done = 0
UPDATE calendar SET Date = '2004-01-29' WHERE ((Date < '2004-01-29') AND
(Done = 0))
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29') AND
(Done = 0)
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29' AND
Done = 0)

does not work. (I get error "1030 - got error 134 from table handler").


this kind of error does not indicate a syntax error.
more likely, your table has errors. you can test this and repair the
table if necessary. i suggest you read about this topic in the manual
(seems to be section 5.5).

steven.
Jul 19 '05 #3
ch*****@nospaamteamlit.com wrote:
The follow SQL expressions don't work in MySQL:

UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29' AND
Done = 0
UPDATE calendar SET Date = '2004-01-29' WHERE ((Date < '2004-01-29') AND
(Done = 0))
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29') AND
(Done = 0)
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29' AND
Done = 0)

does not work. (I get error "1030 - got error 134 from table handler").


this kind of error does not indicate a syntax error.
more likely, your table has errors. you can test this and repair the
table if necessary. i suggest you read about this topic in the manual
(seems to be section 5.5).

steven.
Jul 19 '05 #4
Thanks! That was the problem.

The manual could use some documentation describing what the results of the
'Check Table' command mean, but 'Repair Table' worked!

steven mestdagh <st*************@esat.kuleuvenREMOVE-THIS.ac.be> wrote:
ch*****@nospaamteamlit.com wrote:
The follow SQL expressions don't work in MySQL:

UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29' AND
Done = 0
UPDATE calendar SET Date = '2004-01-29' WHERE ((Date < '2004-01-29') AND
(Done = 0))
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29') AND
(Done = 0)
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29' AND
Done = 0)

does not work. (I get error "1030 - got error 134 from table handler").


this kind of error does not indicate a syntax error.
more likely, your table has errors. you can test this and repair the
table if necessary. i suggest you read about this topic in the manual
(seems to be section 5.5).

steven.


Jul 19 '05 #5
Thanks! That was the problem.

The manual could use some documentation describing what the results of the
'Check Table' command mean, but 'Repair Table' worked!

steven mestdagh <st*************@esat.kuleuvenREMOVE-THIS.ac.be> wrote:
ch*****@nospaamteamlit.com wrote:
The follow SQL expressions don't work in MySQL:

UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29' AND
Done = 0
UPDATE calendar SET Date = '2004-01-29' WHERE ((Date < '2004-01-29') AND
(Done = 0))
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29') AND
(Done = 0)
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29' AND
Done = 0)

does not work. (I get error "1030 - got error 134 from table handler").


this kind of error does not indicate a syntax error.
more likely, your table has errors. you can test this and repair the
table if necessary. i suggest you read about this topic in the manual
(seems to be section 5.5).

steven.


Jul 19 '05 #6
Thanks! That was the problem.

The manual could use some documentation describing what the results of the
'Check Table' command mean, but 'Repair Table' worked!

steven mestdagh <st*************@esat.kuleuvenREMOVE-THIS.ac.be> wrote:
ch*****@nospaamteamlit.com wrote:
The follow SQL expressions don't work in MySQL:

UPDATE calendar SET Date = '2004-01-29' WHERE Date < '2004-01-29' AND
Done = 0
UPDATE calendar SET Date = '2004-01-29' WHERE ((Date < '2004-01-29') AND
(Done = 0))
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29') AND
(Done = 0)
UPDATE calendar SET Date = '2004-01-29' WHERE (Date < '2004-01-29' AND
Done = 0)

does not work. (I get error "1030 - got error 134 from table handler").


this kind of error does not indicate a syntax error.
more likely, your table has errors. you can test this and repair the
table if necessary. i suggest you read about this topic in the manual
(seems to be section 5.5).

steven.


Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Mario Ohnewald | last post: by
reply views Thread by google account | last post: by
13 posts views Thread by wideangle | last post: by
1 post views Thread by Ike | last post: by
5 posts views Thread by gsaray101 | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.