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 739 of 840
MySQL query to sort by both timestamp and enum?
For this, you can use ORDER BY DATE(). Let us first create a table. Here, we have a column with type DATE and another with type ENUM −mysql> create table DemoTable -> ( -> JoiningDate date, -> Status ENUM('Good', 'Excellent', 'Bad') -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-01-21', 'Excellent'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable(Status) values('Bad'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable(Status) values('Good'); Query OK, 1 row affected (0.13 sec)Display all ...
Read MoreHow to use a select statement while updating in MySQL?
For this, use sub query along with WHERE clause while using the MySQL UPDATE command. Let us first create a table −mysql> create table DemoTable -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 'Chris'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values(250, 'David'); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable values(150, 'Mike'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select ...
Read MoreQuery results that have less than X characters in MySQL?
You can use CHAR_LENGTH() along with the WHERE clause. Let us first create a table −mysql> create table DemoTable -> ( -> FullName varchar(50) -> ); Query OK, 0 rows affected (1.75 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris Brown'); Query OK, 1 row affected (0.40 sec) mysql> insert into DemoTable values('David Miller'); Query OK, 1 row affected (0.91 sec) mysql> insert into DemoTable values('Robert Miller'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable values('John Smith'); Query OK, 1 row affected (0.89 sec)Display all records from the ...
Read MoreHow to split a column in MySQL?
To split a column, you need to use SUBSTRING_INDEX() in MySQL. Let us first create a table −mysql> create table DemoTable -> ( -> Name varchar(40) -> ); Query OK, 0 rows affected (1.80 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John_Smith'); Query OK, 1 row affected (0.36 sec) mysql> insert into DemoTable values('Carol_Taylor'); Query OK, 1 row affected (0.28 sec) mysql> insert into DemoTable values('David_Miller'); Query OK, 1 row affected (0.54 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+--------------+ ...
Read MoreAdd a single year to all the date records in a MySQL table column
Let us first create a table −mysql> create table DemoTable -> ( -> JoiningDate datetime -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2015-01-21'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('2017-04-02'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('2018-12-31'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+---------------------+ | JoiningDate | +---------------------+ | 2015-01-21 00:00:00 ...
Read MorePlacing comments in the middle of a create table statement? Is it possible?
Yes, it is possible using the # symbol. Let us first create a table −mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY , # Creating a sequence Number -> FirstName varchar(20), # Creating a column to store name -> Age int # creating a column to store an age -> ); Query OK, 0 rows affected (1.43 sec)Above, we have set comments using the # symbol. Insert some records in the table using insert command. We will set comments in insert statement as well using the same # symbol ...
Read MoreMySQL update multiple records in a single query?
Let us first create a table −mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Marks1 int, -> Marks2 int, -> Marks3 int -> ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Marks1, Marks2, Marks3) values(45, 67, 34); Query OK, 1 row affected (0.33 sec) mysql> insert into DemoTable(Marks1, Marks2, Marks3) values(89, 87, 56); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable(Marks1, Marks2, Marks3) values(87, 56, 54); Query OK, 1 row affected (0.31 sec)Display ...
Read MoreFind out the popular domains from a MySQL table with domain records and search volume
For this, you can use GROUP BY along with the ORDER BY clause. Let us first create a table &mins;mysql> create table DemoTable -> ( -> URL varchar(40), -> DomainName varchar(20), -> SearchTimes int -> ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('www.gmail.com', 'gmail.com', 4); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable values('www.google.com', 'google.com', 3); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable values('www.gmail.com', 'gmail.com', 9); Query OK, 1 row affected (0.15 sec) mysql> insert ...
Read MoreHow to display the storage engine while implementing JDBC - MySQL CONNECTION query?
Use SELECT ENGINE to display the storage engine name. Let us first create a table −mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Name varchar(20), -> Age int, -> CountryName varchar(20) -> ); Query OK, 0 rows affected (0.63 sec)Here is the Java code to get the storage engine using JDBC −Exampleimport java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class GetTheStorageEngine { public static void main(String[] args) { String hostURL = "jdbc:mysql://localhost:3306/web?useSSL=false"; Connection con = null; ...
Read MoreGet last second of a date in MySQL?
To get the last second of a date in MySQL, use the INTERVAL command. Let us first create a table −mysql> create table DemoTable -> ( -> JoiningDatetime datetime, -> DueDatetime datetime -> ); Query OK, 0 rows affected (0.55 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(JoiningDatetime) values('2019-11-03 12:34:54'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable(JoiningDatetime) values('2019-10-04 12:34:54'); Query OK, 1 row affected (0.13 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+---------------------+-------------+ | JoiningDatetime ...
Read More