MyTAP, the best way to test MySQL stored procedures
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.
Tagged: MySQL , StoredProcedure
How to merge multiple rows into one column
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.
Tagged: MySQL , mysql how to
MySQL client ran out of memory
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
