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
Monthly Archives: August, 2022
MySQL: How to Strip HTML Tags
The following regular expression function can be used to strip HTML tags: SELECT REGEXP_REPLACE(field, ‘<[^>]*>+’, ”) FROM table It is very simple.
Kdenlive: How to Fix Audio Record Device
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: How to Open Phpmyadmin Access
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…
Ubuntu: How to Install RTL8192EU Driver
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…