|
|
Posted by Hilarion on 12/08/05 15:49
> What am I doing wrong here:
>
> SELECT *
> FROM `photos`
> UPDATE photos SET codenumber = CONCAT( LEFT( codename, LENGTH(
> codename ) -2 ) , CONCAT( '/', RIGHT( codename, 2 ) ) ) LIMIT 0 ,
> 30
>
> and I get:
>
> #1064 - 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
> 'UPDATE photos SET codenumber = CONCAT( LEFT( codename , LENG
You can't use LIMIT clause in UPDATE statements. It's for limiting
data you retrieve from DB with SELECT statements.
Hilarion
Navigation:
[Reply to this message]
|