Database is an important way to present reports, interface with applications and store data. For all these purposes, the database would be filled with intensive logic and calculation codes. So a testing unit Is required to make sure that the procedures in the database are doing exactly what they need to. For this purpose, MyTAP is used.
Recently in one of my project I came across with a requirement to merge the multiple records of one field that is returned by a query in to one record.
When you are running a query on a table having millions of records then your query take so much time to get executed and may give you out of memory error.
ERROR 2008: MySQL client ran out of memory