Year: 2018

This is a common thing that usually required for back end programming.  Sometimes we need all rows of a table as an query statement just like – INSERT INTO MyTable(ID,Col1,Col2,Col3) VALUES (100,’some vlaue’,’some value’,’2018-10-20′); So the question is “How do we get the insert query statement for this easily ?” Here I am gonna write a simple PHP function by that you can get the insert query statement for all rows in a table :- <?php function makeInsertQuery($mysqli,$table, $where=null) { $sql=”SELECT * FROM `{$table}`”.(is_null($where) ? “” : ” WHERE “.$where).”;”;…

Most frequently occurred problem that is faced by developers.  Here I am gonna explain you for the query Group by Day, Month or Year in MySQL. Using the DATE_FORMAT operator, you can easily group the timestamp, date or datetime column using any format you want. For example, I needed to group rows that were added on the same day. Here is my query: select count(*), DATE_FORMAT(created_at,”%Y-%m-%d”) as created_day FROM widgets GROUP BY DATE_FORMAT(created_at,”%Y-%m-%d”) This query will give you result like this : count(*) | created_day 126 | 2012-04-12 168 |…