Fix SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the GROUP BY behavior. So in this and future versions GROUP BY would not work in same way as it used to be before. So to make GROUP BY feature working like before follow these details: Note: First of all to follow these steps you must need to have root access to […]

Best Websites to Learn Programming in Free

https://frontendmasters.com/ https://www.class-central.com http://www.udacity.com http://www.freecodeamp.com https://codecademy.com https://mva.microsoft.com/ https://github.com/open-source-society/computer-science https://www.khanacademy.org https://www.safaribooksonline.com/ ( One Month Free Trial ) http://edx.org http://coursera.org http://udemy.com https://www.skillshare.com/ https://thenewboston.com/videos.php https://angularfirebase.com/ http://w3schools.com https://www.airpair.com/ https://egghead.io http://tutsplus.com https://www.pluralsight.com/browse/software-developmentĀ ( 10 Days Free Trial ) https://hackr.io https://academy.fossbytes.com/ https://www.codeschool.com http://www.learnvern.com/ http://www.lynda.com (10 Days Free Trial) https://www.datacamp.com https://alison.com/ http://programming-motherfucker.com/become.html https://itpro.tv/PAID https://www.cbtnuggets.com https://linuxacademy.comAWS (Amazon Web Services) https://www.youtube.com/watch?v=BDBvHOaaKHo&list=PLv2a_5pNAko0Mijc6mnv04xeOut443Wnk https://linuxacademy.com/ (AWS and other cloud […]

MySQL: How to get latest updated Tables’ list

Following query will show a list of the all latest tables which are changed/updated ( by inserting/deleting/updating rows ) recently. USE information_schema; SELECT TABLE_SCHEMA , TABLE_NAME FROM TABLES WHERE UPDATE_TIME IS NOT NULL AND UPDATE_TIME > NOW() – INTERVAL 1 DAY AND TABLE_SCHEMA = ‘Your_Database_Name’