#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…
Many browsers now have the power to access video and audio input from the user. However, counting on the browser, it’d be a full dynamic and inline experience, or it might be delegated to a different app on the user’s device. Here we will learn 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…
RabbitMQ is an open-source message broker. It supports multiple messaging protocols. It was originally developed to support AMQP 0-9-1 protocol ( Advanced Message Queuing Protocol which is a messaging protocol that enables conforming client applications to communicate with conforming messaging middleware brokers ). This Read more…
VScode was introduced on April 29, 2015. VScode is a source-code editor undertaken by Microsoft for Windows, Linux and macOS. It includes embedded Git and support for debugging, syntax highlighting, intelligent code completion and snippets. it’s extremely customizable, allowing users to change the theme, keyboard Read more…
Many times when you need to change the access control list (ACL) of a key on the S3 to make it public to private or private to public. This is easy as we provide this control at the time when we Read more…
Editing is one of the most important features of Devextreme Datagrid. Every developer needs Editor feature for editing the record. Many types of editing modes are provided by the Devextreme Datagrid like ‘cell’, ‘row’, ‘form’, and Read more…
EML file extension is created by Microsoft Corporations for Email files. It is also known as RFC 822. In these files, email messages are stored in plain text formats. Microsoft’s Outlook Express uses this file extension to save Mail Read more…
Accessor and Mutators are allowed to alter the data before saving and fetching from the database. An accessor is used to change the format while fetching the data from the database and mutators set the format attributes before retrieving the data from the database.
Wireshark is an open-source network protocol that is responsible to investigate the network traffic and for visual understanding of packet loss. It is used to troubleshoot the network connectivity and review the TCP (Transmission Control Protocol) transmission between the source and destination endpoints. WireShark is also Read more…
When working with sets in apex sometimes we need to create a string from the set’s values but there is no function that can convert a set into a string as we have for lists. To convert set into a string we can use these two Read more…
Devextreme is a powerful component suite for developing highly responsive web applications. It has many built-in Widgets for the web developer to use and customize as per the need of the application. Among all the Widgets there is one widget with name DateBox. To display custom Read more…
Moodle is a modular system. Totara extends the core structure of Moodle. The LMS is meant to handle the core necessities expected of a high-end company LMS. This means that Moodle and Totara both were built to be able to include additional Read more…
Whenever a data model changes during development it gets out of sync with the current database in code first approach. The database initialization strategies that we used in our project result in loss of data whenever there are changes in model classes. The solution to this problem is migrations. By Read more…
In Internet Explorer, many times you might have faced issues of invalid date from Date Conversion methods or might have worked with Javascript methods for operations on data. In my case, I used some conversion operation on a date in IE, after that I had to use Read more…
RxJS is a popular library among web developers. It provides some features like functional and reactive programming patterns that support working with events and streams. Rxjs provides the functionality to write asynchronous code. The current stable version is Rxjs v6.
RxJS 6 has many advantages Read more…
In the manual testing process, it is easy validating that the file is downloaded or not because the human mind is fully involved in the testing process. But in the case of automation testing, it is important to verify that the file Read more…
In the early version of PHP, one would use define() function to set constants. But with new updates in PHP gained one more way to declare constants as “const”. They both Read more…
Bootstrap is a popular HTML, CSS, and JavaScript framework for developing a responsive and mobile-friendly website. It includes jumbotron, table, button, grid, form, image, alert, wells, container, carousel, panels, glyph icon, badges, labels, progress bar, pagination, pager, list group, dropdown, collapse, tabs, pills, navbar, inputs, modals Read more…
