Assuming you mean that the database type is decimal(6, 2), then this means that your column is set up to store 6 places (scale), with 2 to the right of the decimal (precision). You should treat this as a decimal CLR type. A sample would be 1234.56 . The syntax for the double data type is DOUBLE […]
Have you recently changed your MySQL Server root password? If answer is YES, than this is the cause of the error / warning inside phpMyAdmin console. To fix the problem, simply edit your phpMyAdmin’s config-db.php file and setup the proper database password.
For ubuntu (i used ubuntu 12.04), the default phpmyadmin apache configuration can be found at /etc/phpmyadmin/apache.conf You can open it by type sudo nano /etc/phpmyadmin/apache.conf and change the third To restart apache service
Xampp Users Go to xampp\phpMyAdmin\ Open config.inc.php Search for $cfg[‘ExecTimeLimit’] = 300; Set a larger value or change to 0 for unlimited If not found add $cfg[‘ExecTimeLimit’] = 900; (or 0 for unlimited) Save the file and restart the server Important: setting the execution time limit to unlimited is not recommended.