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 )
Category: MySQL
MySQL: Table size query
Posted onSELECT TABLE_NAME, table_rows, data_length, index_length, ROUND(((data_length + index_length) / 1024 / 1024),2) ‘Size in MB’ FROM information_schema.TABLES WHERE table_schema = ‘mallagroup_mautic’ ORDER BY ROUND(((data_length + index_length) / 1024 / 1024),2) DESC ;
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
phpMyAdmin: Securing web console
Posted onI installed PHPMyadmin to check my help manage my database, eventhough I also use the desktop program MySQL Workbench, I fell sometimes its important to use the webconsole. Recently, upon checking my MySQL Logs (/var/logs/mysql/error.log) I encountered that everyday I had thousands of failed logins to the PHPMyAdmin. I sure enough have a very strong […]
Import CSV to DB
Posted onhttp://stackoverflow.com/questions/11448307/importing-csv-data-using-php-mysql