MySQL v SQL 1

[vlitim]

I have been asked to create a dbase in mysql. I have used SQL for my previous projects and the one thing that I don't quite understand about MySQL is the Stored procedures. Is there an equivalent in mysql?

 

[danielhozac]

No, MySQL doesn't have stored procedures. //Daniel

 

[vlitim]

so is there nothing that can be done server side. ie I have dbase in SQL that has 10000 records, and a search that uses a stored procedure to return 10 rows at a time to the asp page. If the asp pages has to deal with the 10000 results itself it will take forever. How would you go about doing this in MySQL??

Cheers
Tim

 

[piti]

there's the LIMIT clause in mysql

if you want to return only 10 records, you issue a query like select ..... LIMIT 10

this will return first 10 rows

if you need next 10 rows
select ...... limit 10, 10