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 381 of 547
MySQL RegEx to find lines containing N semi-colons?
Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY , Title text ); Query OK, 0 rows affected (0.88 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Title) values('This is; a; MySQL;Tutorial'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable(Title) values('Java is; an;Object Oriented'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable(Title) values('MongoDB ; is;a; database'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following ...
Read MoreAdding characters in values for an existing int column in MySQL?
To add characters to an existing int column values, use MySQL CONCAT(). Let us first create a table −mysql> create table DemoTable ( Amount int ); Query OK, 0 rows affected (1.44 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(709); Query OK, 1 row affected (0.67 sec) mysql> insert into DemoTable values(34560); Query OK, 1 row affected (0.30 sec) mysql> insert into DemoTable values(90854); Query OK, 1 row affected (0.28 sec) mysql> insert into DemoTable values(3456); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql> select ...
Read MorePull MySQL records for the last 60 minutes?
To pull records for the last 60 minutes, use MySQL INTERVAL as shown in the below syntax −select *from yourTableName where yourColumnName > now() - interval 60 minute;Let us first create a table −mysql> create table DemoTable ( ArrivalTime datetime ); Query OK, 0 rows affected (0.61 sec)Let us find the current date −mysql> select now(); +-----------------------+ | now() | +-----------------------+ | 2019-09-17 00 :04 :54 | +-----------------------+ 1 row in set (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-09-16 08 :00 :00'); Query ...
Read MoreDelete selective multiple records using MySQL DELETE query
For selective multiple records, use MySQL IN(). To delete them, use MySQL DELETE. Let us first create a table −mysql> create table DemoTable ( ClientId varchar(40), ClientName varchar(50) ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('CLI-101', 'Chris'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable values('CLI-110', 'Adam'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('CLI-220', 'Mike'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('CLI-120', 'Bob'); Query OK, 1 row affected (0.53 sec) mysql> insert ...
Read MoreHow to check if any of the strings in a column contains a specific string in MySQL?
For this, use CONCAT() along with LIKE operator. Let us first create a table −mysql> create table DemoTable ( Name varchar(40) ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John'); Query OK, 1 row affected (0.33 sec) mysql> insert into DemoTable values('Adam'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Bob'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable values('Johnson'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('David'); Query OK, 1 row affected (0.12 sec)Display all records ...
Read MorePerform NAND/NOR operations in MySQL
Let us first see how we can perform NAND/NOR operations in MySQL. The concept is as follows −NAND= NOT( yourColumnName1 AND yourColumnName2) NOR=NOT( yourColumnName1 OR yourColumnName2)Let us first create a table −mysql> create table DemoTable ( Value1 boolean , Value2 boolean ); Query OK, 0 rows affected (0.72 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(true, true); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(false, false); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values(false, true); Query OK, 1 row affected (0.10 sec) mysql> insert ...
Read MoreDisplay records from the current date till rest of the same month in MySQL?
Let us first create a table −mysql> create table DemoTable ( BookingDate date ); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-09-21'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('2018-09-10'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('2019-09-10'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('2019-09-08'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('2016-09-18'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement −mysql> select ...
Read MoreMySQL query to group by names and display the count in a new column
Use GROUP BY with the COUNT() method. Group the names with GROUP BY and count using the COUNT() method. Let us first create a table −mysql> create table DemoTable ( Name varchar(30) ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Mike'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.07 sec) mysql> insert into ...
Read MoreNeed to populate autocomplete with records on the basis of first and last name of schools in MySQL?
To populate autocomplete, use the LIKE clause in MySQL. Let us first create a table −mysql> create table DemoTable ( SchoolName varchar(100) ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Horce Greeley'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('Conestoga Senior'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('Adlai E.Stevenson'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Thomas Jefferson'); Query OK, 1 row affected (0.07 sec)Display all records from the table using select statement :mysql> ...
Read MoreDisplay NULL and NOT NULL records except a single specific value in MySQL
To display NULL records, use IS NULL in MySQL. To ignore a single value, use the != operator , which is an alias of the operator.Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, PlayerName varchar(40) ); Query OK, 0 rows affected (0.50 sec)Insert some records in the table using insert command −p>mysql> insert into DemoTable(PlayerName) values('Adam'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable(PlayerName) values(NULL); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable(PlayerName) values('Sam'); Query OK, 1 row affected (0.13 sec) ...
Read More