This error comes whenever we add a foreign key constraint between tables and insert records into the child table. Let us see an example. Creating the child table. mysql> create table ChildDemo -> ( -> id int, -> FKPK int ... Read More

Binary is the simplest kind of number system that uses only two digits of 0 and 1 (i.e. value of base 2). Since digital electronics have only these two states (either 0 or 1), so binary number is most preferred in modern computer engineer, networking and communication specialists, and other ... Read More

Protocols in the data link layer are designed so that this layer can perform its basic functions: framing, error control and flow control. Framing is the process of dividing bit - streams from physical layer into data frames whose size ranges from a few hundred to a few thousand bytes. ... Read More

To select last 10 rows from MySQL, we can use a subquery with SELECT statement and Limit concept. The following is an example. Creating a table. mysql> create table Last10RecordsDemo -> ( -> id int, -> name varchar(100) ... Read More

To select first 10 elements from a database using SQL ORDER BY clause with LIMIT 10.The syntax is as followsSELECT *FROM yourTableName ORDER BY yourIdColumnName LIMIT 10;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table Clients    - ... Read More

To insert only date value, use curdate() in MySQL. With that, if you want to get the entire datetime, then you can use now() method.Let us first create a table −mysql> create table CurDateDemo -> ( -> ArrivalDate datetime -> ); ... Read More

To select the last row, we can use ORDER BY clause with desc (descending) property and Limit 1. Let us first create a table and insert some records with the help of INSERT command. The query is as follows. mysql> create table getLastRecord -> ( ... Read More

Let’s assume that, you want to promote your dance academy. As the owner of the institution, you want more people to know about the types of dance forms being taught in your institute and the other facilities you are providing. The more people know about your academy, the more students ... Read More

Either you want a growth in the current role or kick off a new business, a good mentor can pave the way for you. At your workplace, you might find many individuals who hold a treasure of leadership experiences and people just fall for their intelligence. You can make such ... Read More

To create three equal columns layout with Bootstrap Grid Layout, you can try to run the following code −Example           Bootstrap Example                              Bootstrap Grid                       Column One             Column Two             Column Three                     Output