Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Let us first create a table −mysql> create table DemoTable805(LoginDate datetime); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable805 values('2019-01-31 12:45:20'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable805 values('2017-11-01 10:20:30'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable805 values('2016-03-12 04:10:00'); Query OK, 1 row affected (0.35 sec) mysql> insert into DemoTable805 values('2018-12-24 05:01:00'); Query OK, 1 row affected (0.13 sec)Display all records from the table using select statement −mysql> select *from DemoTable805;This will produce the following output −+---------------------+ | LoginDate ... Read More
Let us first create a table −mysql> create table DemoTable774 ( Id int, FirstName varchar(100), MatchId int ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable774 values(101, 'Chris', 104); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable774 values(102, 'Adam', 103); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable774 values(103, 'Carol', 102); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable774 values(104, 'Bob', 101); Query OK, 1 row affected (0.16 sec)Display all records ... Read More
For this, you need to use ORDER BY to order records. With that use RAND() to get random records and LIMIT 5 since we want to display only 5 random records.Let us first create a table −mysql> create table DemoTable773 (StudentId int); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable773 values(100); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable773 values(200); Query OK, 1 row affected (0.87 sec) mysql> insert into DemoTable773 values(300); Query OK, 1 row affected (1.59 sec) mysql> insert into DemoTable773 values(400); Query OK, ... Read More
To find alternative records from a table, you need to use the OR condition as in the below syntax −select *from yourTableName where yourColumnName=yourValue1 OR yourColumnName=yourValue2…...N;Let us first create a table −mysql> create table DemoTable772 ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(100), Age int ); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command −mysql> insert into DemoTable772(Name, Age) values('Chris', 21); Query OK, 1 row affected (0.28 sec) mysql> insert into DemoTable772(Name, Age) values('Robert', 26); Query OK, 1 row affected (0.19 sec) ... Read More
Use BETWEEN to find the date and time between joining and relieving date. NOW() is used to get the current date and time for comparison.Let us first create a table −mysql> create table DemoTable771 ( Joiningdate datetime, Relievingdate datetime ); Query OK, 0 rows affected (1.15 sec)Insert some records in the table using insert command −mysql> insert into DemoTable771 values('2016-01-21', '2016-09-23'); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable771 values('2019-01-21', '2019-09-23'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable771 values('2017-04-01', '2018-12-31'); Query OK, 1 row affected (0.20 sec) ... Read More
Let us first create a table −mysql> create table DemoTable770 ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value int ); Query OK, 0 rows affected (0.65 sec)Insert some records in the table using insert command −mysql> insert into DemoTable770(Value) values(10); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable770(Value) values(90); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable770(Value) values(160); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable770(Value) values(450); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable770(Value) values(560); Query OK, 1 row affected ... Read More
To set country code to phone numbers would mean to concatenate. You can use CONCAT() for this.Let us first create a table −mysql> create table DemoTable769 (MobileNumber varchar(100)); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable769 values('8799432434'); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable769 values('9899996778'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable769 values('7890908989'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable769 values('9090898987'); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> ... Read More
Find NULL values using the IS NULL and update the new values using MySQL UPDATE and SET −update yourTableName set yourColumnName=yourValue where yourColumnName IS NULL;Let us first create a table −mysql> create table DemoTable768 ( Clientid int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientName varchar(100), ClientAge int ); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable768(ClientName, ClientAge) values('John', 23); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable768(ClientName, ClientAge) values(NULL, 26); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable768(ClientName, ClientAge) values('Carol', 28); ... Read More
For this, you can use LPAD() and pad a value on the left.Let us first create a table −mysql> create table DemoTable767 (Value varchar(100)); Query OK, 0 rows affected (1.40 sec)Insert some records in the table using insert command −mysql> insert into DemoTable767 values('4'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable767 values('5'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable767 values('6'); Query OK, 1 row affected (0.39 sec) mysql> insert into DemoTable767 values('1'); Query OK, 1 row affected (0.10 sec)Display all records from the table using select statement −mysql> select *from DemoTable767;This will ... Read More
For this, you need to perform concatenation using CONCAT().Let us first create a table −mysql> create table DemoTable766 (Name varchar(100)); Query OK, 0 rows affected (0.65 sec)Insert some records in the table using insert command −mysql> insert into DemoTable766 values('John'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable766 values('Sam'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable766 values('Carol'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable766 values('David'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable766 values('Bob'); Query OK, 1 row affected (0.12 sec)Display all records from the table ... Read More