Select Specific Row Of Data From MySQL using DBI?

jdlev has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Select Specific Row Of Data From MySQL using DBI? by jethro (Monsignor) on Jan 20, 2009 at 00:55 UTC
See DBI recipes for some nice dbi recipes	[reply]
Re: Select Specific Row Of Data From MySQL using DBI? by Joost (Canon) on Jan 20, 2009 at 01:39 UTC
Select the row with the unique id that you want. If the row doesn't have a unique id, and no unique combined key, you're doing it wrong. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re: Select Specific Row Of Data From MySQL using DBI? by meraxes (Friar) on Jan 20, 2009 at 00:58 UTC
You may wish to read: How do I post a question effectively? Uhhh... kinda vague. This isn't necessarily a Perl question. What have you done? Do you mean you've run a query that returns 100 rows or that you have a table that has 100 rows and you only want one? If it's the former, where is the data? In an array? Then you need only reference that element in the array: `$rows[50]`. If it's the latter you need to adjust your SQL's `WHERE` or `LIMIT` to get only the needed row... not a Perl problem at all. -- meraxes	[reply] [d/l] [select]
Re: Select Specific Row Of Data From MySQL using DBI? by sanku (Beadle) on Jan 20, 2009 at 05:08 UTC
hi, Use limit command in select statment Example: select * from TABLE_NAME LIMIT 51,1;	[reply]
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]