hello, guys I am having a problem with MySQL when retrieving row accounts. I want to ask for help. I have hundreds of accounts in my database and I want to retrieve information from a specific row to down. for example: I want to retrieve row 10 down to the last row. what is the query shout I use? I'm sorry for bothering but I am new to database
Use LIMIT. Read about in in the docs: http://dev.mysql.com/doc/refman/5.0/en/select.html You query should look like this: * considering 1000000 is big enough. It should be bigger that the number of records in the table.