To display a single quote text, use double quotes like if you want to write You’ve, then write You've while inserting i.e. with double-quotes. Let us first create a table −mysql> create table DemoTable (    Note text ); Query OK, 0 rows affected (0.57 sec)Insert some records in the ... Read More

To update only blank cells to NULL, use NULLIF() in MySQL. Let us first create a table −mysql> create table DemoTable (    Name varchar(50) ); Query OK, 0 rows affected (1.73 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Mike'); Query OK, 1 row ... Read More

Let us see the first syntax, which uses DISTINCT in MAX() −select max(DISTINCT yourColumnName) from yourTableName;The second syntax is as follows. It isn’t using DISTINCT −select max( yourColumnName) from yourTableName;NOTE − Both the above queries give the same result with or without a DISTINCT keyword. MySQL internally converts MAX(yourColumnName) to ... Read More

For this, use COALESCE(). Let us implement a stored procedure to check if the local variable is null −mysql> DELIMITER // mysql> CREATE PROCEDURE local_VariableDemo()    BEGIN    DECLARE value1 int;    DECLARE value2 int;    select value1, value2;    select    concat('After checking local variable is null the sum ... Read More

For condition based update, use UPDATE and IF(). Let us first create a table −mysql> create table DemoTable (    Value int ); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.08 sec) ... Read More

Let us first create a table −mysql> create table DemoTable (    `Values` varchar(50) ); Query OK, 0 rows affected (1.15 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('23, 45, 78, 56'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('384, ... Read More

Let us first create a table −mysql> create table DemoTable (    EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    EmployeeName varchar(40),    isMarried boolean ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(EmployeeName, isMarried) values('Chris', true); Query OK, ... Read More

Let us first create a table −mysql> create table DemoTable (    ClientId int,    ClientName varchar(50) ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command. Here, we are inserting multiple values using only a single INSERT −mysql> insert into DemoTable values(101, 'Adam'), ... Read More

You can use FIND_IN_SET to structure some data in a database for easier retrieval. Let us first create a table −mysql> create table DemoTable (    CountryName SET('US', 'UK', 'AUS') ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert command −mysql> insert into DemoTable ... Read More

Use MySQL INTERVAL for this. Let us first create a table −mysql> create table DemoTable (    DueDate date ); Query OK, 0 rows affected (1.13 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-07-10'); Query OK, 1 row affected (0.10 sec) mysql> insert into ... Read More