Skip to content
Webner Logo
  • Blog Home
  • Categories
    • Web Development
    • Salesforce
    • Big Data
    • Cloud
    • Database
    • PHP Frameworks
    • eLearning
    • Insurance
    • Java Frameworks
    • Linux, Windows, Mac
    • Mobile
    • Others (General)
    • Others (Technical)
    • Software Testing
    • Zoho
  • About Us
  • Contact Us
  • StudySection

Webner Blogs – eLearning, Salesforce, Web Development & More

Tag: mysql

August 23, 2023 Cloud / Database

Configuring MySQL Master-Slave Replication on Ubuntu

August 23, 2023 Cloud / Database
Post Views: 115
| By Navneet Kashyap

Replication between master and slave MySQL databases involves replicating and copying database files across multiple servers in a network. Using this setup, the master server serves as a redundancy and fault-tolerance mechanism in the event of a failure, the slave

Read More
September 23, 2020 Database / Web Development

Mysql | #1553 – Cannot drop Index

September 23, 2020 Database / Web Development
Post Views: 5,101
| By Webner

Issue: #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

Read More
September 17, 2020 Database / Web Development

How to Run Multiple versions of MySQL on the Same Server?

September 17, 2020 Database / Web Development
Post Views: 2,449
| By Webner

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. Installing Docker To install Docker on your

Read More
December 20, 2019 Database

MySQL: only_full_group_by issue on joins

December 20, 2019 Database
Post Views: 1,622
| By Webner

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

Read More
November 14, 2019 Database

PHP: mysqli_multi_query stops the execution of further MySQL queries.

November 14, 2019 Database
Post Views: 2,209
| By Webner

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

Read More

Google ad

Copyright 2022 - 2023 | Webner Blog by Webner Solutions Pvt Ltd. | All Rights Reserved.
MENU
  • Blog Home
  • Categories
    • Web Development
    • Salesforce
    • Big Data
    • Cloud
    • Database
    • PHP Frameworks
    • eLearning
    • Insurance
    • Java Frameworks
    • Linux, Windows, Mac
    • Mobile
    • Others (General)
    • Others (Technical)
    • Software Testing
    • Zoho
  • About Us
  • Contact Us
  • StudySection