Re: Select Specific Row Of Data From MySQL using DBI?

hi, Use limit command in select statment Example: select * from TABLE_NAME LIMIT 51,1;

Comment on Re: Select Specific Row Of Data From MySQL using DBI?

Replies are listed 'Best First'.
Re^2: Select Specific Row Of Data From MySQL using DBI? by mje (Curate) on Jan 20, 2009 at 10:51 UTC
If you do something like select from TABLE_NAME LIMIT 51,1* you probably want to add an "order by" to that select.	[reply]
Re^2: Select Specific Row Of Data From MySQL using DBI? by Lawliet (Curate) on Jan 20, 2009 at 23:58 UTC
Would that not be `LIMIT 50, 1` because the table rows start at 0? (Assuming the OP is talking about the row in human terms.) And you didn't even know bears could type.	[reply] [d/l]