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
MySQLi Articles
Page 211 of 341
How to get the top 3 salaries from a MySQL table with record of Employee Salaries?
For this, use LIMIT and OFFSET. Let us first create a table −mysql> create table DemoTable867(EmployeeSalary int); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command −mysql> insert into DemoTable867 values(63737); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable867 values(899833); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable867 values(23644); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable867 values(89393); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable867 values(534333); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable867 values(889322); Query OK, 1 ...
Read MorePerform SUM and SUBTRACTION on the basis of a condition in a single MySQL query?
For this, use CASE statement and set for both SUM and SUBTRACTION. Let us first create a table −mysql> create table DemoTable866( Status varchar(100), Amount int ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable866 values('ACTIVE', 50); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable866 values('INACTIVE', 70); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable866 values('INACTIVE', 20); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable866 values('ACTIVE', 100); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable866 ...
Read MoreWhat does parenthesis mean in MySQL SELECT (COLNAME)?
The SELECT(COLNAME) means, we are creating an alias for that column. Let us see an example and create a table −mysql> create table DemoTable865( FirstName varchar(100), LastName varchar(100) ); Query OK, 0 rows affected (0.77 sec)Insert some records in the table using insert command −mysql> insert into DemoTable865 values('Chris', 'Brown'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable865 values('Adam', 'Smith'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable865 values('David', 'Miller'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable865 values('Carol', 'Taylor'); Query OK, 1 row affected (0.15 sec)Display all records ...
Read MoreReturn only the non-empty and non-null values from a table and fill the empty and NULL values with the corresponding column values in MySQL?
Let us first create a table −mysql> create table DemoTable839( StudentFirstName varchar(100), StudentLastName varchar(100) ); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable839 values('Chris', 'Brown'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable839 values('', 'Taylor'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable839 values(NULL, 'Taylor'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable839 values('Adam', 'Smith'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable839;This will produce the following ...
Read MoreHow can I create a MySQL table with a column with only 3 possible given values?
For this, use the ENUM data type. Let us first create a table −mysql> create table DemoTable838(Color ENUM('RED','GREEN','BLUE')); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command −mysql> insert into DemoTable838 values('RED'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable838 values('Green'); Query OK, 1 row affected (0.64 sec) mysql> insert into DemoTable838 values('Blue'); Query OK, 1 row affected (0.88 sec)Display all records from the table using select statement −mysql> select *from DemoTable838;This will produce the following output −+-------+ | Color | +-------+ | RED | | GREEN | | BLUE | +-------+ 3 rows in set (0.00 sec)
Read MoreHow to compare Year, Month and Day in a MySQL query and display matching records
For this, you can use DATE(). Let us first create a table −mysql> create table DemoTable864(DueDateTime timestamp); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable864 values('2019-01-10 12 −34 −55'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable864 values('2016-12-11 11 −12 −00'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable864 values('2015-04-01 10 −00 −00'); Query OK, 1 row affected (0.28 sec) mysql> insert into DemoTable864 values('2017-05-20 04 −40 −10'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement ...
Read MoreReplace the empty values from a MySQL table with a specific value
Let us first create a table −mysql> create table DemoTable837(Name varchar(100)); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable837 values('Chris'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable837 values(''); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable837 values('Robert'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable837 values(''); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable837 values('David'); Query OK, 1 row affected (1.13 sec)Display all records from the table using select statement −mysql> select *from DemoTable837;This will produce ...
Read MoreMySQL query to get the dates between range of records displaying student's Date of Birth?
For fetching records between dates, use BETWEEN. Let us first create a table −mysql> create table DemoTable863(StudentDateOfBirth date); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable863 values('1998-01-10'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable863 values('2000-10-15'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable863 values('2003-04-20'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable863 values('2005-12-31'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable863 values('1999-07-01'); Query OK, 1 row affected (0.27 sec)Display all records from the table using select ...
Read MoreRemove specific word in a comma separated string with MySQL
Let us first create a table −mysql> create table DemoTable836(FirstName SET('John', 'Chris', 'Adam')); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable836 values('John, Chris'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable836 values('John, Chris, Adam'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable836 values('Chris, Adam'); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable836 values('John, Adam'); Query OK, 1 row affected (0.37 sec)Display all records from the table using select statement −mysql> select *from DemoTable836;This will produce the following output −+-----------------+ | ...
Read MoreMySQL query to update only month in date?
To update only month in date, use MONTH(). Let us first create a table −mysql> create table DemoTable861(AdmissionDate date); Query OK, 0 rows affected (1.22 sec)Insert some records in the table using insert command −mysql> insert into DemoTable861 values('2019-01-21'); Query OK, 1 row affected (0.31 sec) mysql> insert into DemoTable861 values('2018-01-01'); Query OK, 1 row affected (0.49 sec) mysql> insert into DemoTable861 values('2016-01-02'); Query OK, 1 row affected (1.27 sec) mysql> insert into DemoTable861 values('2018-01-14'); Query OK, 1 row affected (0.47 sec)Display all records from the table using select statement −mysql> select *from DemoTable861;This will produce the following output −+---------------+ ...
Read More