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
Articles by AmitDiwan
Page 812 of 839
MySQL 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 MoreSelect Statement to retrieve the same first names with similar last name (but different case) using MySQL?
Let us first create a table −mysql> create table DemoTable623 (FirstName varchar(100), LastName varchar(100), Age int); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command −mysql> insert into DemoTable623 values('John', 'Smith', 23); Query OK, 1 row affected (0.66 sec) mysql> insert into DemoTable623 values('Adam', 'smith', 23); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable623 values('Chris', 'Brown', 24); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable623 values('Robert', 'brown', 21); Query OK, 1 row affected (0.22 sec)Display all records from the table using select statement −mysql> select *from DemoTable623;This will ...
Read MoreMySQL query to set different combinations for values in a table?
Let us first create a table −mysql> create table DemoTable622 (Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value1 int, Value2 int); Query OK, 0 rows affected (1.08 sec)Insert some records in the table using insert command −mysql> insert into DemoTable622(Value1, Value2) values(1000, 1000); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable622(Value1, Value2) values(2000, 3000); Query OK, 1 row affected (1.04 sec)Display all records from the table using select statement −mysql> select *from DemoTable622;This will produce the following output −+----+--------+--------+ | Id | Value1 | Value2 | +----+--------+--------+ | 1 | 1000 | 1000 ...
Read More