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 on Trending Technologies
Technical articles with clear explanations and examples
Set special characters on values if condition is true in MySQL?
For conditions, use IF(). Let us first create a table −mysql> create table DemoTable637 (ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientName varchar(100), ClientAge int ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> insert into DemoTable637(ClientName, ClientAge) values('Chris', 23); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('Robert', 24); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('David', 57); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('Carol', 60); Query OK, 1 row affected (0.13 sec)Display all records ...
Read MoreImplement two conditions for a single column in MySQL for null and empty value
Let us first create a table −mysql> create table DemoTable635( EmployeId int NOT NULL AUTO_INCREMENT PRIMARY KEY, EmployeeName varchar(100) ); Query OK, 0 rows affected (1.24 sec)Insert some records in the table using insert command −mysql> insert into DemoTable635(EmployeeName) values('John'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable635(EmployeeName) values('Sam'); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable635(EmployeeName) values(''); Query OK, 1 row affected (0.38 sec) mysql> insert into DemoTable635(EmployeeName) values(null); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable635(EmployeeName) values('David'); Query OK, 1 row affected (0.22 sec)Display all records from the ...
Read MoreMySQL query to display ranks of multiple columns?
For this, use FIND_IN_SET() method. Let us first create a table −mysql> create table DemoTable634 (FirstName varchar(100), Marks int, Age int); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable634 values('John', 60, 23); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable634 values('Chris', 80, 21); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable634 values('Robert', 70, 24); Query OK, 1 row affected (0.22 sec)Display all records from the table using select statement −mysql> select *from DemoTable634;This will produce the following output −+-----------+-------+------+ | FirstName | Marks ...
Read MoreUpdate a table based on StudentId value in MySQL?
Let us first create a table −mysql> create table DemoTable633 (StudentId char(2) not null primary key, StudentName varchar(100)); Query OK, 0 rows affected (1.06 sec)Insert some records in the table using insert command −mysql> insert into DemoTable633 values('10', 'Chris'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable633 values('20', 'Sam'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable633 values('30', 'David'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement −mysql> select *from DemoTable633;This will produce the following output −+-----------+-------------+ | StudentId | StudentName | +-----------+-------------+ | 10 ...
Read MoreStoring value from a MySQL SELECT statement to a variable?
Let us first create a table −mysql> create table DemoTable631 ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentName varchar(100) ); Query OK, 0 rows affected (0.83 sec)Insert some records in the table using insert command −mysql> insert into DemoTable631(StudentName) values('John Smith'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable631(StudentName) values('Adam Smith'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable631(StudentName) values('David Miller'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable631;This will produce the following output −+-----------+--------------+ | StudentId | StudentName | ...
Read MoreHow to escape '%' character on the left and middle part of strings in a MySQL column?
Let us first create a table −mysql> create table DemoTable629 (StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentSubject text); Query OK, 0 rows affected (0.77 sec)Insert some records in the table using insert command −mysql> insert into DemoTable629(StudentSubject) values('MySQL%'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable629(StudentSubject) values('Spring%Hibernate'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable629(StudentSubject) values('%Java'); Query OK, 1 row affected (0.21 sec)Display all records from the table using select statement −mysql> select *from DemoTable629;This will produce the following output −+-----------+------------------+ | StudentId | StudentSubject | +-----------+------------------+ | ...
Read MoreMySQL to get only the floating-point numbers from a list of values in a column
Let us first create a table −mysql> create table DemoTable628 (Value DECIMAL(10, 2)); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable628 values(10.97); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable628 values(20.04); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable628 values(12.00); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable628 values(89.56); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> select *from DemoTable628;This will produce the following output −+-------+ | Value | +-------+ | 10.97 ...
Read MoreConvert the case of every value in a MySQL Column to uppercase
For this, use UPPER() on MySQL column. Let us first create a table −mysql> create table DemoTable627 (Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName varchar(100)); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable627(FirstName) values(UPPER('John')); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable627(FirstName) values(UPPER('Sam')); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable627(FirstName) values(UPPER('Mike')); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable627(FirstName) values(UPPER('Carol')); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable627(FirstName) values(UPPER('dAVID')); Query OK, 1 row affected (0.70 ...
Read MoreSelecting and displaying only some rows from a column in a MySQL table
Let us first create a table −mysql> create table DemoTable625 ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFirstName varchar(100), StudentScore int ); Query OK, 0 rows affected (1.01 sec)Insert some records in the table using insert command −mysql> insert into DemoTable625(StudentFirstName, StudentScore) values('John', 98); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable625(StudentFirstName, StudentScore) values('Chris', 39); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable625(StudentFirstName, StudentScore) values('Bob', 41); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable625(StudentFirstName, StudentScore) values('David', 40); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable625(StudentFirstName, StudentScore) ...
Read MoreGet the time difference between values in different columns with MySQL
For this, you can use time_format() and time_diff(). To find the time difference, you need to use the time_diff() method. Let us first create a table −mysql> create table DemoTable624 (PunchIn datetime, PunchOut datetime); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable624 values('2019-07-14 12:10:00', '2019-07-14 12:50:00'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable624 values('2019-07-14 11:00:00', '2019-07-14 11:30:00'); Query OK, 1 row affected (0.34 sec)Display all records from the table using select statement −mysql> select *from DemoTable624;This will produce the following output −+---------------------+---------------------+ | PunchIn ...
Read More