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
Monday, November 2, 2015
Subscribe to:
Comments (Atom)
Postgress - Read a XML file from a postgress table XML column
SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH ...
-
if more than 65535 files in your temp folder, this error can occurs, To resolve this, remove all temporary files in C:/Windows/Temp ....
-
select upper(substr(CTY_CITY,1,1))|| substr(CTY_CITY,2,length(CTY_CITY)-1) as Ax from AGM_M_COUNTRY_CITY; update AGM_M_COUNTRY_CITY set ...
-
Common text box validation function for all the text boxes within the same form. Using Sender parameter to handle. private void tex...