DatabaseCategory

Date Posted: 05-04-2018 In this we will explain MySql replace NULL values with empty string. Step1: You can create two different tables. using the following query. CREATE TABLE `users` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(16) NOT NULL, `name` varchar(40) DEFAULT NULL, `last_name` varchar(60) DEFAULT NULL, PRIMARY KEY… Continue Reading MySql replace NULL values with empty string

Error debconf: unable to initialize frontend: Dialog Date Posted: 06-10-2017 Issue:- When got this error while installing mysql via bash script. Its because debconf is trying to control dialog prompt in background. But it doesn’t exist on your server. Fix:- So install dialog and apt-utils apt-get install dialog apt-utils  

ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci” Date Posted: 04-10-2017 Recently, when we tried to resource the dump which we had taken on one server and tried to restore it on another server. The restore failed with an error: ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci”… Continue Reading Unknown collation: utf8mb4_unicode_520_ci