trying to create a view on mysql but it wouldnt create more than 30 rows and gives me a message saying..... 1 This view has at least this number of rows. Please refer to documentation.

I did refer to the documentation but in vain... any pointers