To get only the date from DateTime, use the date format specifiers −%d for day %m for month %Y for yearLet us first create a table −mysql> create table DemoTable (    AdmissionDate datetime ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-07-21 12:34:56'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('2016-08-18 10:00:02'); Query OK, 1 row affected (0.51 sec) mysql> insert into DemoTable values('2018-01-03 11:02:20'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from ... Read More

To replace, use the REPLACE() MySQL function. Since you need to update the table for this, use the UPDATE() function with the SET clause.Following is the syntax −update yourTableName set yourColumnName=replace(yourColumnName, yourOldValue, yourNewValue);Let us first create a table −mysql> create table DemoTable (    FirstName varchar(100),    CountryName varchar(100) ); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John', 'AUS'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Bob', 'AUS'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('Chris', 'US'); Query OK, 1 ... Read More

For this, you can use the ORDER BY CASE statement. Let us first create a table −mysql> create table DemoTable (    StudentName varchar(100),    StudentMarks int ); Query OK, 0 rows affected (0.97 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 45); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable values('John', 67); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('David', 89); Query OK, 1 row affected (0.46 sec) mysql> insert into DemoTable values('John', 98); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Mike', ... Read More

To order by the first number in a set of numbers, use ORDER BY SUBSTRING_INDEX(). Let us first create a table −mysql> create table DemoTable (    SetOfNumbers text ); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('245, 654, 76, 89, 98'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('2000, 567, 9090, 6789'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('1001, 90595, 657, 99'); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> ... Read More

Yes, but you need to add a backtick symbol to the reserved word (index) to avoid error while using it as a column name.Let us first create a table −mysql> create table DemoTable (    `index` int ); Query OK, 0 rows affected (0.48 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(1000); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values(1020); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(967); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values(567); Query OK, 1 row affected (0.12 ... Read More

Let us first create a table −mysql> create table DemoTable (    FirstName varchar(100),    Score int ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('David', 59); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values('Chris', 97); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable values('Bob', 98); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Carol', 91); Query OK, 1 row affected (0.11 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the ... Read More

For this, use IF() along with IS NULL property. Let us first create a table −mysql> create table DemoTable (    Name varchar(100),    CountryName varchar(100) ); Query OK, 0 rows affected (0.70 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 'US'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Mike', NULL); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(Name) values('David'); Query OK, 1 row affected (0.38 sec) mysql> insert into DemoTable values('Bob', 'AUS'); Query OK, 1 row affected (0.45 sec)Display all records from the table using select ... Read More

Let us first create a table −mysql> create table DemoTable (    UserId int,    UserName varchar(100) ); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 'Chris'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values(101, 'Bob'); Query OK, 1 row affected (0.07 sec) mysql> insert into DemoTable values(102, 'David'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(103, 'Mike'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(104, 'Sam'); Query OK, 1 row affected (0.16 sec)Display all records ... Read More

Let us first create a table −mysql> create table DemoTable (    StudentId int,    StudentFirstName varchar(100) ); Query OK, 0 rows affected (0.88 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 'John'); Query OK, 1 row affected (0.32 sec) mysql> insert into DemoTable values(101, 'Chris'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(102, 'John'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values(103, 'Sam'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(104, 'Sam'); Query OK, 1 row affected (0.13 sec)Display all records ... Read More

You can easily insert DateTime with the MySQL command line. Following is the syntax − insert into yourTableName values(‘yourDateTimeValue’); Let us first create a table − mysql> create table DemoTable (    DateOfBirth datetime ); Query OK, 0 rows affected (0.97 sec) Insert some records in the table using insert command − mysql> insert into DemoTable values('1998-01-23 12:45:56'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable values('2010-12-31 01:15:00'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values('2015-04-03 14:00:45'); Query OK, 1 row affected (0.10 sec) Display all records from the table using select statement ... Read More