MySQL Stored procedure to Generate-Extract Insert Statement
A lot of places I saw people asking for ways to generate Insert statements. We do have GUI Tools which can extract insert statements for us readily. of the time I choose the MySQLDump way to generate insert statements. mysqldump -uroot -ppassword –complete-insert –no-create-info DATABASE TABLENAME > TABLENAME.sql But mind is very unstable and hungry, we don’t stop at one solution. So to remove my mind’s starvation for the Stored Procedure way to extract Insert statement I created following routine. As you can see this is really a simple procedure revolves around Information_schema mainly to get details of any table...