MYSQL
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tbl.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Create INDEX in SQL
How To Update Rows With Different Values In One Query
I am going to share how to update rows with different values in One Query. I have user data table. I have more then 100 user data. The user's gender has changed by mistake. So I want to change Gender mail to female and female to male.
How to Count More Than One Row
I am going to share how to count more than one row in SQL. Suppose You have list of user details and you want count more then one row. In bellow example you can use sql query to get data.