#1553 – Cannot drop index ‘index_name’: needed in a foreign key constraint
An issue is generally faced when we are going to drop a unique index from a table. For example, here I have the table articles that have the following structure:
Column
Data type
Specifications
id
int Read more…
Solution:
If your system is having a current version of MySQL installed i.e 5.6 and you also need 5.5 version then follow the below steps.
You can also play with different versions also.
To install Docker on your machine Read more…
#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…
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…
