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 830 of 840
Select 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 MoreHow to group by column name and ensure the query retrieves the last update in MySQL?
Let us first create a table −mysql> create table DemoTable621 (UserName varchar(100), UserEmailId varchar(100), UserLastPost datetime); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable621 values('John', 'John@gmail.com', '2019-04-10 11:01:10'); Query OK, 1 row affected (0.47 sec) mysql> insert into DemoTable621 values('John', 'John@gmail.com', '2019-07-14 13:07:10'); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql> select *from DemoTable621;This will produce the following output −+----------+----------------+---------------------+ | UserName | UserEmailId | UserLastPost | +----------+----------------+---------------------+ | John | ...
Read MoreWhere is MySQL bin directory located in Windows OS?
Let’s say we installed MySQL version is 8.0 on our Windows OS. The bin directory is present at the following location −C:\Program Files\MySQL\MySQL Server 8.0\binLet us check the location. The screenshot is as follows −These are the drives −Go to C: drive and click Program Files −Now, click “MySQL” and open the folder −After that, click the current MySQL version folder. For us, it is MySQL Server 8.0 −Inside the folder, you can easily locate the bin folder as shown in the following screenshot −
Read MoreDivide numbers from two columns and display result in a new column with MySQL
Let us first create a table −mysql> create table DemoTable719 (FirstNumber int, SecondNumber int); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable719 values(20, 10); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable719 values(500, 50); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable719 values(400, 20); Query OK, 1 row affected (0.11 sec)Display all records from the table using select statement −mysql> select *from DemoTable719;This will produce the following output −+-------------+--------------+ | FirstNumber | SecondNumber | +-------------+--------------+ | 20 | ...
Read MoreHow to add columns values with suffixed currency sign in MySQL
For this, you can use aggregate function SUM(). Let us first create a table:mysql> create table DemoTable616 (Price varchar(100)); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable616 values('€200.00'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable616 values('€300.00'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable616 values('€500.00'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable616;This will produce the following output −+-----------+ | Price | +-----------+ | €200.00 | | ...
Read MoreDelete a specific record on the basis of EmployeeId in MySQL
Let us first create a table −mysql> create table DemoTable615 (EmployeeId varchar(100), EmployeeName varchar(100)); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable615 values('EMP-101', 'Adam'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable615 values('EMP-1001', 'David'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable615 values('EMP-1002', 'Chris'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable615 values('EMP-1003', 'Robert'); Query OK, 1 row affected (0.21 sec)Display all records from the table using select statement −mysql> select *from DemoTable615;This will produce the following output −+------------+--------------+ | ...
Read MoreReturn similar names from different columns with distinct space allocations in MySQL?
For this, use LTRIM() and RTRIM(), since the names are similar but have different left and right space allocations. For example, “ John “ and “John”.Let us first create a table −mysql> create table DemoTable614 (EnterName varchar(100), ReennterName varchar(100)); Query OK, 0 rows affected (0.97 sec)Insert some records in the table using insert command −mysql> insert into DemoTable614 values(' John ', 'John'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable614 values('Carol ', 'Bob'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable614 values('David ', 'David'); Query OK, 1 row affected (0.23 sec)Display all records from ...
Read MorePerform MySQL update with AND operator
Let us first create a table −mysql> create table DemoTable613 (Id int, Age int, isMarried tinyint(1)); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable613 values(100, 29, 0); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable613 values(200, 22, 0); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable613 values(300, 30, 1); Query OK, 1 row affected (0.19 sec)Display all records from the table using select statement −mysql> select *from DemoTable613;This will produce the following output −+------+------+-----------+ | Id | Age | isMarried | +------+------+-----------+ ...
Read MoreHow to create conditions in a MySQL table with multiple columns?
For conditions, use IF(). Following is the syntax −IF(yourCondition, trueStatement, falseStatement);Let us first create a table −mysql> create table DemoTable612 (Number1 int, Number2 int, Score int); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable612 values(10, 20, 1000); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable612 values(30, 40, 500); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable612 values(50, 70, 1200); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable612 values(100, 120, 400); Query OK, 1 row affected (0.16 sec)Display all records from ...
Read More