Let’s say the current date is 2019-07-25. We will now see an example and create a table where ShippingDate is added in the table.Let us first create a table −mysql> create table DemoTable667(ShippingDate datetime); Query OK, 0 rows affected (0.46 sec)Insert some records in the table using insert command −mysql> ... Read More

To grant replication privilege, use GRANT REPLICATION SLAVE ON.First list all the user names along with host from MySQL.user table −mysql> select user, host from mysql.user;This will produce the following output −+------------------+-----------+ | user             | host | +------------------+-----------+ | ... Read More

Let us first create a table −mysql> create table DemoTable666(AdmissionDate varchar(200)); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable666 values('Sat, 20 Jul 2019 04:29:35'); Query OK, 1 row affected (1.12 sec) mysql> insert into DemoTable666 values('Fri, 02 Oct 2018 ... Read More

The TIMESTAMPDIFF() calculates the difference between two dates or datetime expressions. Let us first create a table −mysql> create table DemoTable665(    PunchInTime datetime,    PunchOutTime datetime,    Details INT(11) AS (ABS(TIMESTAMPDIFF(second, PunchInTime, PunchOutTime))) )ENGINE=MyISAM; Query OK, 0 rows affected (0.23 sec)Insert some records in the table using insert command ... Read More

The TIMESTAMP data type is used for values containing both date and time parts. Let us first create a table −mysql> create table DemoTable662(    UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY, UserName varchar(100), UserPostDate datetime ); Query OK, 0 rows affected (0.50 sec)Following is the query for valid default ... Read More

The OR operator gives true result when any one operand is true. Let us now see an example and create a table −mysql> create table DemoTable663(ClientId int, ClientName varchar(100), ClientAge int); Query OK, 0 rows affected (0.55 sec)Insert some records in the table using insert command −mysql> insert into DemoTable663 ... Read More

Let us first create a table and set default values −mysql> create table DemoTable803(UserId int DEFAULT 101, UserName varchar(100) DEFAULT 'Chris'); Query OK, 0 rows affected (1.18 sec)Insert some records in the table using insert command. For the values we are not inserting, the default values will get set automatically ... Read More

To extract from datetime column, you can use date() along with trim(). Here, trim() is used to remove whitespace while comparing. Let us first create a table −mysql> create table DemoTable661(Duedate datetime); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into ... Read More

Yes, you can use date_sub() to subtract number of days from a date. Following is the syntax −select date_sub(yourColumnName, Interval yourAmountOfDays day) from yourTableName;Let us first create a table −mysql> create table DemoTable660(AdmissionDate datetime); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> ... Read More

To fetch a specific row when values are the same, use GROUP BY. Let us first create a table −mysql> create table DemoTable659(Id int, Name varchar(100), Score int); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable659 values(11, 'John', 45); ... Read More