Use GROUP_CONCAT() to perform group concatenation and set a condition. Let us first create a table −mysql> create table DemoTable813(    UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    UserFirstName varchar(100),    UserLastName varchar(100) ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert command ... Read More

To display results on the basis of keyword, use the LIKE operator as in the following syntax −select *from yourTableName where yourColumnName LIKE '%yourValue%';Let us first create a table −mysql> create table DemoTable812(Comments text); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> ... Read More

Yes, it is enabled by default from MySQL version 4.0. Here, we are using MySQL version 8.0.1 −mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12    | +-----------+ 1 row in set (0.00 sec)Let us now check the my.ini wherein the default engine type InnoDB is visible ... Read More

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 ); ... 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> ... 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, ... 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 ... 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 ... 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 ... 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, ... Read More