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 819 of 840
Display substrings of different length with a single MySQL query and combine the result
Let us first create a table −mysql> create table DemoTable856(Title text); Query OK, 0 rows affected (0.89 sec)Insert some records in the table using insert command −mysql> insert into DemoTable856 values('Introduction to MySQL'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable856 values('Java in depth'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable856 values('C++ with Data Structure'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement −mysql> select *from DemoTable856;This will produce the following output −+-------------------------+ | Title | +-------------------------+ ...
Read MoreRemove only the percentage sign from values in a MySQL table?
Let us first create a table −mysql> create table DemoTable828( CustomerName varchar(100), InterestRate varchar(100) ); Query OK, 0 rows affected (0.50 sec)Insert some records in the table using insert command −mysql> insert into DemoTable828 values('Chris', '10%'); Query OK, 1 row affected (0.60 sec) mysql> insert into DemoTable828 values('Robert', '11.5%'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable828 values('David', '15.90%'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable828 values('Bob', '20%'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable828;This will produce the following ...
Read MoreHow to check if a timestamp is set in MySQL?
Let us first create a table −mysql> create table DemoTable855(DueDate timestamp); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable855 values('2019-08-07'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable855 values('0000-00-00'); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable855 values('2019-07-06'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable855 values('2016-04-10'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable855;This will produce the following output −+----------------------+ | DueDate ...
Read MoreMySQL query to replace only the backslashes from folder path?
To replace backslashes with any other special character, use the REPLACE() method. Let us first create a table −mysql> create table DemoTable827(Path text); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable827 values('C\MySQL'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable827 values('D\NewFolder'); Query OK, 1 row affected (0.47 sec) mysql> insert into DemoTable827 values('E:\myFolder\MyDocument'); Query OK, 1 row affected (0.11 sec)Display all records from the table using select statement −mysql> select *from DemoTable827;This will produce the following output −+------------------------+ | Path ...
Read MoreHow to do a sum of previous row value with the current row and display the result in another row with MySQL cross join?
Let us first create a table −mysql> create table DemoTable(Value int); Query OK, 0 rows affected (1.79 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(50); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable values(20); Query OK, 1 row affected (0.68 sec) mysql> insert into DemoTable values(30); Query OK, 1 row affected (0.18 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+-------+ | Value | +-------+ | 50 | | 20 | | 30 | +-------+ 3 rows in ...
Read MoreMySQL query to display only the column values with corresponding column having whitespace
For this, use the TRIM() function. Let us first create a table −mysql> create table DemoTable826( FirstName varchar(100), Age int ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using the insert command. Here, we have set the FirstName as whitespace for some of the records −mysql> insert into DemoTable826 values(' ', 24); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable826 values(' ', 22); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable826 values('Chris', 26); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable826 values('Robert', 27); Query ...
Read MoreHow to optimize a MySQL table after deleting some rows?
Use the OPTIMIZE TABLE command to optimize a MySQL table −optimize table yourTableName;Let us first create a table −mysql> create table DemoTable( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(100) ); Query OK, 0 rows affected (1.38 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Name) values('Chris'); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable(Name) values('Robert'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable(Name) values('Bob'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable(Name) values('David'); Query OK, 1 row affected (0.38 sec)Display all records from ...
Read MoreImplement a MySQL Void Query that does nothing
Let us first create a table −mysql> create table DemoTable(Name varchar(100)); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('Sam'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.37 sec) mysql> insert into DemoTable values('Mike'); Query OK, 1 row affected (0.09 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+--------+ | Name | +--------+ | Chris | ...
Read MoreRetrieve MIN and MAX date in a single MySQL query from a column with date values
For this, you can use aggregate function MIN() and MAX(). Let us first create a table −mysql> create table DemoTable(AdmissionDate date); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-01-21'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('2018-12-31'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('2016-11-01'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('2019-04-11'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('2016-02-01'); Query OK, 1 row affected (0.28 sec)Display all records from the ...
Read MoreORDER BY specific field value first in MySQL
To order by specific field value first in MySQL, use ORDER BY FIELD(). Let us first create a table −mysql> create table DemoTable849(Color varchar(100)); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable849 values('RED'); Query OK, 1 row affected (0.33 sec) mysql> insert into DemoTable849 values('ORANGE'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable849 values('BLUE'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable849 values('GREEN'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable849;This will ...
Read More