Category: MySql
-
mysql full backup all databases
To do a good BD restore without any problem with character sets use these commands (you can change the default-character-set as you need).
-
update to null mysql
NULL is a special value in SQL. So to null a property, do this: The MySQL manual states that if the column does not allow NULL values, setting it to NULL will result in the default value for the data type (e.g. an empty string).
-
meaning of 6 2 in double data type in MySQL
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…
-
group by in MySQL example only date from datetime
MySQL Example Laravel Example with groupByRaw Laravel Example with groupBy
-
mysqli_real_connect(): (HY000/1045): Access denied for user ‘phpmyadmin’@’localhost’ (using password: YES)
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.