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 on Trending Technologies
Technical articles with clear explanations and examples
Can we implement nested insert with select in MySQL?
Yes, we can implement nested insert with select in MySQL as shown in the below syntax −insert into yourTableName2(yourColumnName1, yourColumnName2, .....N) select yourColumnName1, yourColumnName2, ....N from yourTableName1 where yourCondition;Let us first see an example and create a table −mysql> create table DemoTable1 ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(40) ); Query OK, 0 rows affected (0.88 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1(Name) values('Chris'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable1(Name) values('David'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1(Name) values('Bob'); Query ...
Read MoreMySQL CASE WHEN with SELECT to display odd and even ids?
Let us first create a table −mysql> create table DemoTable ( PageId int ); Query OK, 0 rows affected (0.85 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(233); Query OK, 1 row affected (0.36 sec) mysql> insert into DemoTable values(34); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values(76); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values(89); Query OK, 1 row affected (0.26 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+--------+ | PageId | +--------+ ...
Read MorePerform Multi-table delete in MySQL
For this, you can use DELETE command. Let us first create a table −mysql> create table DemoTable1 ( Id int, Name varchar(20) ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1 values(1, 'Chris'); Query OK, 1 row affected (0.30 sec) mysql> insert into DemoTable1 values(2, 'David'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1 values(3, 'Bob'); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> select *from DemoTable1;This will produce the following output −+------+-------+ | Id ...
Read MoreHow do we mix two strings and generate another in java?
Strings are used to store a sequence of characters in Java, they are treated as objects. The String class of the java.lang package represents a String.You can create a String either by using the new keyword (like any other object) or, by assigning value to the literal (like any other primitive datatype).String stringObject = new String("Hello how are you"); String stringLiteral = "Welcome to Tutorialspoint";Concatenating StringsYou can concatenate Strings in Java in the following ways −Using the "+" operator − Java Provides a concatenation operator using this, you can directly add two String literalsExampleimport java.util.Scanner; public class StringExample { ...
Read MoreMySQL Regex to match a pattern for ignoring a character in search like Chris.Brown?
Let us first create a table −mysql> create table DemoTable ( Name varchar(40) ) ; Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John.Smith'); Query OK, 1 row affected (0.30 sec) mysql> insert into DemoTable values('Chris Brown'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Chris.Brown'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('David Miller'); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values('Chris.Taylor'); Query OK, 1 row affected (0.18 sec)Display all records from the table using select ...
Read MoreMySQL query to group rows by the numeric characters in a string field?
Fir this, you can concatenate 0 with string field with the help of + operator. The scenario here is like we need to fetch numeric “9844” from a string field “9844Bob”.Let us first create a table −mysql> create table DemoTable ( StudentId varchar(100) ); Query OK, 0 rows affected (0.92 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('9844Bob'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('6375DavidMiller'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('007'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable ...
Read MoreImplement MySQL trigger in the first table to insert records in the second table?
For this, the syntax is as follows −DELIMITER // create trigger yourTriggerName before insert on yourTableName1 for each row begin insert into yourTableName2 values (yourValue1, yourValue2, ...N); end ; // DELIMITER ;Let us first create a table −mysql> create table DemoTable1 ( StudentId int, StudentName varchar(40) ); Query OK, 0 rows affected (0.69 sec)Here is the query to create second table −mysql> create table DemoTable2( Id int, Name varchar(40) ); Query OK, 0 rows affected (0.61 sec)Here is the query for trigger before insert −mysql> DELIMITER // mysql> create trigger ...
Read MoreMySQL query to select date from 00:00 to today's date
Let’s say the current date is 2019-09-14 8 :50 :10. Now, we want records from 00 :00 to 2019-09-14 8 :50 :10. Let us now see an example and create a table −mysql> create table DemoTable ( DueDate datetime ); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-09-14'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('2019-09-14 8 :00 :10'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('2019-09-14 8 :44 :00'); Query OK, 1 row affected (0.14 sec) mysql> insert ...
Read MoreExclude some ID records from a list and display rest in MySQL
To exclude records, use MySQL NOT IN(). Let us first create a table −mysql> create table DemoTable ( Id int ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(1); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values(2); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values(3); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable values(4); Query OK, 1 row affected (0.41 sec) mysql> insert into DemoTable values(5); Query OK, 1 row affected (0.09 sec) mysql> insert into ...
Read MoreA single MySQL query to update only specific records in a range without updating the entire column
Let us first create a table −mysql> create table DemoTable ( Name varchar(40), Position int ); Query OK, 0 rows affected (1.17 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 90); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('David', 67); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('Bob', 55); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Sam', 40); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the ...
Read More