0

How can one select a row from an SQL table in n-times?

Using two tables in the same database

13th Apr 2017, 9:47 PM
Temitope Olamilere
Temitope Olamilere - avatar
3 Answers
+ 2
What you mean exactly? You can select a row with usual query like: SELECT * FROM tablename WHERE id=1 Or you need something else?
14th Apr 2017, 5:18 AM
Jeth
Jeth - avatar
+ 1
Why you need 10 similar selects? You can select and store data in variable if you need 1 row or select multiple rows with one query and store it in array. Lot of consequent small queries is not proper way when working with SQL.
14th Apr 2017, 6:22 AM
Jeth
Jeth - avatar
0
I meant; selecting a row in 10times and proceed executing same query to another row. thanks Jeth.
14th Apr 2017, 6:16 AM
Temitope Olamilere
Temitope Olamilere - avatar