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 428 of 547
How 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 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 More