Yes, we can insert two or more rows in a table at once. Following is the syntax −insert into yourTableName(yourColumnName1, yourColumnName2) values(yourValue1, yourValue2), (yourValue1, yourValue2), .........N;Let us first create a table −mysql> create table DemoTable811(    StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    StudentName varchar(100),    StudentAge int ); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable811(StudentName, StudentAge) values('Chris', 21), ('Robert', 22), ('David', 20), ('Bob', 19), ('Carol', 23); Query OK, 5 rows affected (0.14 sec) Records: 5 Duplicates: 0 Warnings: 0Display all records from the table using select ... Read More

Let us first create a table −mysql> create table DemoTable841(    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Value varchar(100) ); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command −mysql> insert into DemoTable841(Value) values('X'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable841(Value) values('Y'); Query OK, 1 row affected (0.39 sec) mysql> insert into DemoTable841(Value) values('Y'); Query OK, 1 row affected (1.62 sec) mysql> insert into DemoTable841(Value) values('Z'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable841(Value) values('X'); Query OK, 1 row affected (0.81 sec) mysql> insert into ... Read More

Let us first create a table −mysql> create table DemoTable810(    First int,    Second int ); Query OK, 0 rows affected (0.73 sec)Insert some records in the table using insert command −mysql> insert into DemoTable810 values(20, 40); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable810 values(70, 90); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable810 values(120, 150); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable810 values(78, 128); Query OK, 1 row affected (0.32 sec)Display all records from the table using select statement −mysql> select *from DemoTable810 ;This will produce the ... Read More

For this, you can use a session variable. Let us first create a table −mysql> create table DemoTable809(Price int); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable809 values(40); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable809 values(50); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable809 values(60); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable809;This will produce the following output −+-------+ | Price | +-------+ |    40 | |    50 | ... Read More

Let’s say the current date is 2019-08-03. Now, we will see an example and create a table −mysql> create table DemoTable840(DueDate datetime); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into DemoTable840 values('2019-08-9'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable840 values('2019-07-5'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable840 values('2019-08-10'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable840 values('2019-07-13'); Query OK, 1 row affected (0.10 sec)Display all records from the table using select statement −mysql> select *from DemoTable840;This will produce the ... Read More

To set specific record ordering, use ORDER BY LIKE. Let us first create a table−mysql> create table DemoTable808(Value varchar(100)); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable808 values('smith'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable808 values('Adamsmith'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable808 values('Carolsmith'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable808 values('smithJohn'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable808;This will produce the following output −+------------+ ... Read More

Let us first create a table −mysql> create table DemoTable807(    ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    ClientName varchar(100),    ClientCountryName varchar(100) ); Query OK, 0 rows affected (0.64 sec) Insert some records in the table using insert command −mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Chris', 'UK'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('David', 'AUS'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Robert', 'US'); Query OK, 1 row affected (0.74 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Mike', 'ENG'); Query OK, 1 row affected (0.14 sec)Display all records ... Read More

To match partially, use LIKE operator. Let us first create a table −mysql> create table DemoTable806(    StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    StudentName varchar(100),    StudentSubject varchar(100) ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable806(StudentName, StudentSubject) values('Chris', 'Java in Depth With Data Structure'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable806(StudentName, StudentSubject) values('Robert', 'Introduction to MySQL'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable806(StudentName, StudentSubject) values('Bob', 'C++ in Depth With Data Structure And Algorithm'); Query OK, 1 row affected ... Read More

Let us first create a table −mysql> create table DemoTable805(LoginDate datetime); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable805 values('2019-01-31 12:45:20'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable805 values('2017-11-01 10:20:30'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable805 values('2016-03-12 04:10:00'); Query OK, 1 row affected (0.35 sec) mysql> insert into DemoTable805 values('2018-12-24 05:01:00'); Query OK, 1 row affected (0.13 sec)Display all records from the table using select statement −mysql> select *from DemoTable805;This will produce the following output −+---------------------+ | LoginDate     ... Read More

For this, you need to use ORDER BY to order records. With that use RAND() to get random records and LIMIT 5 since we want to display only 5 random records.Let us first create a table −mysql> create table DemoTable773 (StudentId int); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable773 values(100); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable773 values(200); Query OK, 1 row affected (0.87 sec) mysql> insert into DemoTable773 values(300); Query OK, 1 row affected (1.59 sec) mysql> insert into DemoTable773 values(400); Query OK, ... Read More