phpMyAdmin: Deprecation Notice
Posted onsudo apt-get remove --purge phpmyadmin php-gettext php-mbstring -y sudo apt-get autoremove -y sudo apt-get update sudo apt-get install phpmyadmin php-gettext php-mbstring -y
Category: MySQL
MySQL: Remove ONLY_FULL_GROUP_BY and make it persistent
Posted onEdit /etc/mysql/mysql.conf.d/mysqld.cnf Add sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" Restart MySQL server sudo systemctl restart mysql
MySQL: Replace Accented Characters
Posted onUPDATE leads_cstm SET linkedin_name_c = REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(linkedin_name_c,'ù','u'),'ú','u'),'û','u'),'ü','u'),'ý','y'),'ë','e'),'à','a'),'á','a'),'â','a'),'ã','a'),'ä','a'),'å','a'),'æ','a'),'ç','c'),'è','e'),'é','e'),'ê','e'),'ë','e'),'ì','i'),'í','i'),'î','i'),'ï','i'),'ð','o'),'ñ','n'),'ò','o'),'ó','o'),'ô','o'),'õ','o'),'ö','o'),'ø','o');
MySQL: Truncate Foreign Key
Posted onSET FOREIGN_KEY_CHECKS = 0; DELETE FROM ip_addresses; SET FOREIGN_KEY_CHECKS = 1;
MySQL: Update with IN Statement
Posted onUPDATE email_addresses SET email_addresses.mautic = 1 WHERE email_address IN ( SELECT email_address FROM a0_custom_mautic_emails )