Let us first create a table −mysql> create table DemoTable    -> (    -> MonthNumber int    -> ); Query OK, 0 rows affected (1.68 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.14 sec) mysql> insert into ... Read More

MySQL AND is used in WHERE to fetch a record by filtering using multiple conditions. Let us first create a table−mysql> create table DemoTable    -> (    -> Id int,    -> Name varchar(20)    -> ); Query OK, 0 rows affected (0.70 sec)Insert some records in the table ... Read More

To sort, use ORDER BY SUBSTRING(). Let us first create a table −mysql> create table DemoTable    -> (    -> Value varchar(40)    -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2321/78/54-6')    -> ; Query ... Read More

For this, use ORDER BY clause. Let us first create a table −mysql> create table DemoTable    -> (    -> StudentCode varchar(20)    -> ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('101J'); Query OK, 1 row ... Read More

Let us first create a table −mysql> create table DemoTable    -> (    -> UserName varchar(20),    -> UserType ENUM('New User', 'Registered User')    -> ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 'New User'); Query ... Read More

To round number, use MySQL ROUND(). Let us first create a table −mysql> create table DemoTable    -> (    -> Amount DECIMAL(10, 4)    -> ); Query OK, 0 rows affected (1.18 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100.578); Query OK, 1 ... Read More

You can use ORDER BY STR_TO_DATE(). Let us first create a table −mysql> create table DemoTable    -> (    -> DueTime varchar(20)    -> ); Query OK, 0 rows affected (0.87 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('7:30AM'); Query OK, 1 row ... Read More

The group is a reserved keyword, you can’t use it as table name. Therefore, on using it as table name would lead to an error. To avoid such error, you need to use enclosed backticks symbol around the table name ‘group’.Let us now see an example and create a table ... Read More

To set conditions while adding column values, use MySQL IF(). Let us first create a table −mysql> create table DemoTable    -> (    -> Value1 int,    -> Value2 int,    -> Value3 int    -> ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table ... Read More

To set conditions, use CASE WHEN statement in MySQL. Let us first create a table −mysql> create table DemoTable    -> (    -> Value1 int,    -> Value2 int,    -> Value3 int,    -> Value4 int    -> ); Query OK, 0 rows affected (0.98 sec)Insert some records ... Read More