Page 1 of 1

row_id

Posted: Mon Dec 08, 2003 1:10 pm
by ericsodt
I know in Oracle you can update date by selecting the rowID along with what your selecting, does anyone know if you can do that with MySQL and better yet, how about Access... Microsoft has <span style='color:blue' title='I&#39;m naughty, are you naughty?'>smurf</span> as far as documentation goes for Access...

Thanks guys

Posted: Tue Dec 09, 2003 3:45 am
by Pyrite
Why not see if something like ADOdb could help you? I assume you're using php right?

Google "adodb"

Re: row_id

Posted: Tue Dec 09, 2003 8:27 am
by hedge
ericsodt wrote:I know in Oracle you can update date by selecting the rowID along with what your selecting, does anyone know if you can do that with MySQL and better yet, how about Access... Microsoft has s**t as far as documentation goes for Access...

Thanks guys
Access doesn't, don't know about MySQL

Posted: Tue Dec 09, 2003 9:23 am
by microthick
The LIMIT clause is sorta similar to rowid I think.

Posted: Wed Dec 10, 2003 6:21 pm
by JAM
microthick wrote:The LIMIT clause is sorta similar to rowid I think.
No, LIMIT is purely for selecting the amount of rows you want to retrieve,, and if used in a UPDATE query, you will update LIMIT rows LIMIT as in amount of rows updated.

Code: Select all

update table set foo='bar' LIMIT 14
... will update 14 rows of the 9288 (just an example) ones stored.

ericsodt, can you give us an example? As of today, there are no such update in select function in mysql however.

Posted: Wed Dec 10, 2003 7:36 pm
by microthick
With LIMIT you can go:

LIMIT 10, 30

and this will select rows 10 through 40.

This feature is similar to the rowid function he's describing.