469,949 Members | 2,186 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

InnoDB lock in share mode problems


Hi all

I'm new tot PHP/mySQL but have many years programming experience.

We've just setup a new webspace account with Demon Internet in the UK and
it has PHP/mySQL services

I'm just testing the InnoDB an am having a problem with the following
statement

SELECT * FROM invtest LOCK IN SHARE MODE

Which gives the following error:-

Error

SQL-query :

SELECT *
FROM invtest
LOCK IN SHARE MODE LIMIT 0 , 30

MySQL said:

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 'LIMIT 0,
30' at line 1
I can't seem to find anything about this limit clause/parameter in any of
the help files. Demon say 'Dunno mate we just provide the service !!!'

Any help with this would be most appreciated as I really need 'proper'
transactions for the project I'm about to start.

Thanks in advance

Andrew Kennard

PS the mySQL version they are running seems to be 4.0.9-gamma-log

##-----------------------------------------------#
Article posted from PHP Freaks NewsGroup
http://www.phpfreaks.com/newsgroup
Get Addicted: mailing.database.mysq
##-----------------------------------------------##
Jul 19 '05 #1
2 3972
Please look at my reply from http://lists.mysql.com/
"Andrew Kennard" <an*********************************@foo.com> kirjoitti
viestissä news:6t********************@giganews.com...

Hi all

I'm new tot PHP/mySQL but have many years programming experience.

We've just setup a new webspace account with Demon Internet in the UK and
it has PHP/mySQL services

I'm just testing the InnoDB an am having a problem with the following
statement

SELECT * FROM invtest LOCK IN SHARE MODE

Which gives the following error:-

Error

SQL-query :

SELECT *
FROM invtest
LOCK IN SHARE MODE LIMIT 0 , 30

MySQL said:

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 'LIMIT 0,
30' at line 1
I can't seem to find anything about this limit clause/parameter in any of
the help files. Demon say 'Dunno mate we just provide the service !!!'

Any help with this would be most appreciated as I really need 'proper'
transactions for the project I'm about to start.

Thanks in advance

Andrew Kennard

PS the mySQL version they are running seems to be 4.0.9-gamma-log
##-----------------------------------------------##
Article posted from PHP Freaks NewsGroups
http://www.phpfreaks.com/newsgroups
Get Addicted: mailing.database.mysql
##-----------------------------------------------##

Jul 19 '05 #2
Please look at my reply from http://lists.mysql.com/
"Andrew Kennard" <an*********************************@foo.com> kirjoitti
viestissä news:6t********************@giganews.com...

Hi all

I'm new tot PHP/mySQL but have many years programming experience.

We've just setup a new webspace account with Demon Internet in the UK and
it has PHP/mySQL services

I'm just testing the InnoDB an am having a problem with the following
statement

SELECT * FROM invtest LOCK IN SHARE MODE

Which gives the following error:-

Error

SQL-query :

SELECT *
FROM invtest
LOCK IN SHARE MODE LIMIT 0 , 30

MySQL said:

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 'LIMIT 0,
30' at line 1
I can't seem to find anything about this limit clause/parameter in any of
the help files. Demon say 'Dunno mate we just provide the service !!!'

Any help with this would be most appreciated as I really need 'proper'
transactions for the project I'm about to start.

Thanks in advance

Andrew Kennard

PS the mySQL version they are running seems to be 4.0.9-gamma-log
##-----------------------------------------------##
Article posted from PHP Freaks NewsGroups
http://www.phpfreaks.com/newsgroups
Get Addicted: mailing.database.mysql
##-----------------------------------------------##

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Marcus | last post: by
reply views Thread by Marc Slemko | last post: by
reply views Thread by Andrew Kennard | last post: by
3 posts views Thread by Andy Tran | last post: by
reply views Thread by Rajesh Kapur | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.