MySQL: How to Count Duplicated Records
The following query can be used to count duplicated records in MySQL: SELECT count(*) AS duplicate_count FROM ( SELECT column_name FROM table GROUP BY column_name HAVING COUNT(column_name) > 1 ) AS t
The following query can be used to count duplicated records in MySQL: SELECT count(*) AS duplicate_count FROM ( SELECT column_name FROM table GROUP BY column_name HAVING COUNT(column_name) > 1 ) AS t
The following regular expression function can be used to strip HTML tags: SELECT REGEXP_REPLACE(field, ‘<[^>]*>+’, ”) FROM table It is very simple.
I unable to do audio recording in Kdenlive. Audio device does not show in Settings => Configure Kdenlive => Capture => Audio tab. To fix this issue, install libqt5multimedia5-plugins. $ sudo apt install libqt5multimedia5-plugins Restart Kdenlive and go to Settings => Configure Kdenlive => Capture => Audio tab. Audio device list will be shown and…
XAMPP’s Phpmyadmin folder is forbidden as default if accessed from internet. To open access this folder we have to edit /xampp/apache/conf/extra/httpd-xampp.conf file in Windows or /opt/lampp/etc/extra/httpd-xampp.conf file in Linux. Open httpd-xampp.conf file in text editorFind the following line: # Windows Alias /phpmyadmin “C:/xampp/phpMyAdmin/” <Directory “C:/xampp/phpMyAdmin”> AllowOverride AuthConfig Require local ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var </Directory> # Linux…
First, we install all packages required for the installation of the driver using this command: sudo apt-get install linux-headers-generic build-essential dkms git Now clone the git repository: git clone https://github.com/clnhub/rtl8192eu-linux.git Move to the new folder created: cd rtl8192eu-linux Remove current drivers (check with dkms status or sudo lshw -C network what drivers are available): sudo rmmod rtl8xxxu Blacklist the…
To resolve this issue, we have to export GPG key from deprecated keyring. Get list of existing keys $ sudo apt-key list Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)). /etc/apt/trusted.gpg ——————– pub rsa4096 2017-05-08 [SCEA] 1EDD E2CD FC02 5D17 F6DA 9EC0 ADAE 6AD2 8A8F 901A uid [ unknown] Sublime HQ…
Cloning into ‘<repo>’… error: chmod on /mnt/c/<repo>/.git/config.lock failed: Operation not permitted fatal: could not set ‘core.filemode’ to ‘false’ Above error message shown when Git tried to clone repository in mounting file system in Linux. To solve this issue, we have to edit /etc/fstab file and change uid and guid options. My uid and guid is…
For Windows user, it is very easy to create shortcut of file. Right click on the file, and choose Create Shortcut menu. For Ubuntu, we have to do a little bit effort. For example we want to create shortcut of file and put into Desktop. Open two windows of File Manager / Nautilus. One window…
Let’s Encrypt is popular free SSL service. My VPS which is using Virtualmin was unable to use Let’s Encrypt and throw an error “ACME v1 disabled”. To fix this problem, execute the following line in terminal: apt-get install socat certbot certbot register After that, complete the register with a valid e-mail address and try to…
We need Windows 7 installer on USB thumbrive for laptop which doesn’t have DVD Drive. Below are steps on how to create Windows 7 installer on USB Thumbdrive. 1. Prepare a USB Thumbdrive with minimum 8GB size and a Windows 7 DVD installer. 2. Plug the thumbdrive and insert Windows 7 DVD into tray. 3.…