mysql Archives

MySQL: only_full_group_by issue on joins

Author - Ishpreet Kaur
December 20, 2019
|
0 Comments
|
Database
Post Views: 350

Issue

#1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After upgrading ubuntu 14.04 to 18.04 and MySQL 5.5 to Read more…

PHP: mysqli_multi_query stops the execution of further MySQL queries.

Author - Ishpreet Kaur
November 14, 2019
|
0 Comments
|
Database
Post Views: 439

The mysqli_query statement

Generally, we use mysqli_query to execute Mysql queries in PHP. We can use multiple mysqli_query statements to execute multiple operations like insert, update, and select. Sometimes, we store records in more than one table during save operation at the backend, but it is Read more…