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
Database Articles
Page 351 of 547
MySQL query to increase item value price for multiple items in a single query?
To increase item value for multiple items in a single query, you can use the CASE statement in MySQL. Let us first create a table −mysql> create table DemoTable -> ( -> ProductName varchar(20), -> ProductPrice int -> ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Product-1', 700); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Product-2', 1000); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Product-3', 3000); Query OK, 1 row affected (0.10 sec)Display all records from ...
Read MoreMySQL Select where value exists more than once
For this, you can use GROUP BY HAVING along with the COUNT(*) function. Let us first create a table −mysql> create table DemoTable -> ( -> Value int -> ); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(20); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable values(30); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable ...
Read MoreImplement MySQL query using multiple OR statements. Any optimal alternative?
It would be good to use IN() instead of multiple OR statements. Let us first create a table −mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> FirstName varchar(20) -> ); Query OK, 0 rows affected (0.83 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(FirstName) values('John'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(FirstName) values('Adam'); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable(FirstName) values('David'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable(FirstName) values('Mike'); Query OK, 1 ...
Read MoreImplement Custom Sort Order in MySQL
To implement custom sort order in MySQL, you need to use ORDER BY FIELD(). Let us first create a table −mysql> create table DemoTable -> ( -> Designation varchar(100) -> ); Query OK, 0 rows affected (1.65 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Software Engineer'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Associate Software Engineer'); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable values('Software Development Engineer'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('Product Manager'); Query OK, 1 row ...
Read MoreCan we select field name in MySQL that contains an asterisk?
No, we cannot. To still work it out, use backticks around the field name. Let us first create a table with column name with asterisk, `Name*` −mysql> create table DemoTable -> ( -> `Name*` varchar(20) -> ); Query OK, 0 rows affected (2.03 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(`Name*`) values('Chris Brown'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable(`Name*`) values('David Miller'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable(`Name*`) values('John Doe'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable(`Name*`) values('John Smith'); ...
Read MoreMySQL query to search a string 'demo' if someone mistakenly types 'deom'?
For this, you can use SOUND along with the LIKE operator. Let us first create a table −mysql> create table DemoTable -> ( -> Name varchar(20) -> ); Query OK, 0 rows affected (0.95 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John'); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable values('Adam'); Query OK, 1 row affected (0.33 sec) mysql> insert into DemoTable values('Johm'); Query OK, 1 row affected (0.29 sec) mysql> insert into DemoTable values('Carol'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('SAMSUNG'); Query ...
Read MoreHow to replace 'Empty set' in a MySQL query?
To replace a record that doesn’t exist, use the COALESCE in MySQL. The COALESCE would help in substituting the NULL values. Let us first create a table −mysql> create table DemoTable -> ( -> Code varchar(20) -> ); Query OK, 0 rows affected (1.64 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('10'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('45'); Query OK, 1 row affected (0.30 sec) mysql> insert into DemoTable values('78'); Query OK, 1 row affected (0.21 sec)Display all records from the table using select statement ...
Read MoreOrder by a single field and display rest of the records in the same order with MySQL
Let us first create a table −mysql> create table DemoTable -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(201, 'Chris Brown'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values(110, 'John Doe'); Query OK, 1 row affected (0.29 sec) mysql> insert into DemoTable values(101, 'Adam Smith'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(345, 'Carol Taylor'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(135, ...
Read MoreFind "greatest" between two columns and display with some records already null in MySql
Let us first create a table −mysql> create table DemoTable -> ( -> Value1 int, -> Value2 int -> ); Query OK, 0 rows affected (0.77 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(78, 89); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values(19, null); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values(null, 0); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable values(null, 95); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql> ...
Read MoreOrder records and delete n rows in MySQL
Let us first create a table −mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> FirstName varchar(20) -> ); Query OK, 0 rows affected (0.65 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(FirstName) values('Chris'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(FirstName) values('Adam'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable(FirstName) values('John'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable(FirstName) values('David'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(FirstName) values('Mike'); Query OK, 1 ...
Read More