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'm naughty, are you naughty?'>smurf</span> as far as documentation goes for Access...
Thanks guys
row_id
Moderator: General Moderators
Re: row_id
Access doesn't, don't know about MySQLericsodt 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
-
microthick
- Forum Regular
- Posts: 543
- Joined: Wed Sep 24, 2003 2:15 pm
- Location: Vancouver, BC
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.microthick wrote:The LIMIT clause is sorta similar to rowid I think.
Code: Select all
update table set foo='bar' LIMIT 14ericsodt, can you give us an example? As of today, there are no such update in select function in mysql however.
-
microthick
- Forum Regular
- Posts: 543
- Joined: Wed Sep 24, 2003 2:15 pm
- Location: Vancouver, BC