Let us first create a table −mysql> create table DemoTable (    StudentId int,    StudentName varchar(20),    StudentSubject varchar(20) ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(10, 'Chris', 'MongoDB'); Query OK, 1 row affected (0.21 sec) ... Read More

Let us first create a table −mysql> create table DemoTable (    Name varchar(40) ) ; Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John.Smith'); Query OK, 1 row affected (0.30 sec) mysql> insert into DemoTable values('Chris Brown'); Query ... Read More

Fir this, you can concatenate 0 with string field with the help of + operator. The scenario here is like we need to fetch numeric “9844” from a string field “9844Bob”.Let us first create a table −mysql> create table DemoTable (    StudentId varchar(100) ); Query OK, 0 rows affected ... Read More

Let us first create a table −mysql> create table DemoTable (    Value float ); Query OK, 0 rows affected (0.95 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(12.4567); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(124.7884); Query OK, 1 ... Read More

For this, the syntax is as follows −DELIMITER // create trigger yourTriggerName before insert on yourTableName1    for each row    begin          insert into yourTableName2 values (yourValue1, yourValue2, ...N); end ; // DELIMITER ;Let us first create a table −mysql> create table DemoTable1 (    StudentId ... Read More

Let’s say the current date is 2019-09-14 8 :50 :10. Now, we want records from 00 :00 to 2019-09-14 8 :50 :10. Let us now see an example and create a table −mysql> create table DemoTable (    DueDate datetime ); Query OK, 0 rows affected (0.66 sec)Insert some records ... Read More

To exclude records, use MySQL NOT IN(). Let us first create a table −mysql> create table DemoTable (    Id int ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(1); Query OK, 1 row affected (0.16 sec) mysql> ... Read More

Let us first create a table −mysql> create table DemoTable (    Name varchar(40),    Position int ); Query OK, 0 rows affected (1.17 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 90); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable ... Read More

For this, use aggregate function COUNT() and GROUP BY to group those specific records for occurrences. Let us first create a table −mysql> create table DemoTable (    StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    StudentSubject varchar(40) ); Query OK, 0 rows affected (5.03 sec)Insert some records in the ... Read More

To find a match from records, use MySQL IN(). Let us first create a table −mysql> create table DemoTable (    Id int,    FirstName varchar(20),    Gender ENUM('Male', 'Female') ); Query OK, 0 rows affected (1.73 sec)Insert some records in the table using insert command −mysql> insert into DemoTable ... Read More