How to understand MySQL Joins
MySQL Joins
MySQL Joins
To log a query in laravel there are multiple methods available. I am going to share one of the method log query in laravel. Why we have required to log queries? Sometimes we are not getting correct results when we are running our application. Sometime not able to figure out issue. We have requirement to… Read More »
If you have JSON type columns in your database and want to run query on JSON type field. You can use the following query. In the above query <json_column> must be replace by your column name. $.id and $.response contains the JSON key of your columns. You can use for multiple values also. For example… Read More »
If you want to find duplicate rows from your table use the following query. SELECT column1,column2 COUNT(*) users GROUP BY column1, column2 HAVING COUNT(*) > 1SELECT column1,column2 COUNT(*) users GROUP BY column1, column2 HAVING COUNT(*) > 1 Following are steps : To test the above query on sample table Step1 : First of all you need a table (Assuming you have… Read More »