Monday, November 2, 2015

Cannot load from mysql.proc. The table is probably corrupted

If you cannot create a function/ Stored procedure (SP), and show a error message as
"Cannot load from mysql.proc. The table is probably corrupted"

it is something wrong in your MySQL server. To correct do as follows

In command prompt
go to mysql bin folder
run the command (Exe) : mysql_upgrade

or else required

mysql_upgrade.exe -uroot -p 

Postgress - Read a XML file from a postgress table XML column

SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH ...