Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by AmitDiwan
Page 822 of 840
Implement MySQL IN for 2 columns to display only selected records
Let us first create a table −mysql> create table DemoTable810( First int, Second int ); Query OK, 0 rows affected (0.73 sec)Insert some records in the table using insert command −mysql> insert into DemoTable810 values(20, 40); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable810 values(70, 90); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable810 values(120, 150); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable810 values(78, 128); Query OK, 1 row affected (0.32 sec)Display all records from the table using select statement −mysql> select *from DemoTable810 ;This will produce the ...
Read MoreMySQL SELECT to sum a column value with previous value
For this, you can use a session variable. Let us first create a table −mysql> create table DemoTable809(Price int); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable809 values(40); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable809 values(50); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable809 values(60); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable809;This will produce the following output −+-------+ | Price | +-------+ | 40 | | 50 | ...
Read MoreImplement specific record ordering with MySQL
To set specific record ordering, use ORDER BY LIKE. Let us first create a table−mysql> create table DemoTable808(Value varchar(100)); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable808 values('smith'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable808 values('Adamsmith'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable808 values('Carolsmith'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable808 values('smithJohn'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable808;This will produce the following output −+------------+ ...
Read MoreCheck if a value exists in a column in a MySQL table?
Let us first create a table −mysql> create table DemoTable807( ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientName varchar(100), ClientCountryName varchar(100) ); Query OK, 0 rows affected (0.64 sec) Insert some records in the table using insert command −mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Chris', 'UK'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('David', 'AUS'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Robert', 'US'); Query OK, 1 row affected (0.74 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Mike', 'ENG'); Query OK, 1 row affected (0.14 sec)Display all records ...
Read MoreIs there a way to select a value which matches partially in MySQL?
To match partially, use LIKE operator. Let us first create a table −mysql> create table DemoTable806( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentName varchar(100), StudentSubject varchar(100) ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable806(StudentName, StudentSubject) values('Chris', 'Java in Depth With Data Structure'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable806(StudentName, StudentSubject) values('Robert', 'Introduction to MySQL'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable806(StudentName, StudentSubject) values('Bob', 'C++ in Depth With Data Structure And Algorithm'); Query OK, 1 row affected ...
Read MoreHow to split the datetime column into date and time and compare individually in MySQL?
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 MoreMatch column values on the basis of the other two column values in MySQL
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 MoreMySQL query to find alternative records from a table
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 MoreMySQL query to find the date records wherein the current date and time is in between the JoiningDate and RelievingDate
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 MoreUpdating only a single column value in MySQL?
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