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 713 of 840
Search text containing a new line in MySQL?
You can use REGEXP. Let us first create a table −mysql> create table DemoTable ( Name varchar(100) ); Query OK, 0 rows affected (1.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('JohnSmith'); Query OK, 1 row affected (0.73 sec) mysql> insert into DemoTable values('John Doe'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('DavidMiller'); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable values('Carol Taylor'); Query OK, 1 row affected (0.27 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following ...
Read MoreRename multiple files using Java
Following is the code to rename multiple files using Java −Exampleimport java.io.File; import java.io.IOException; public class Demo{ public static void main(String[] argv) throws IOException{ String path_to_folder = "path\to\folder\where\multiple\files\are\present"; File my_folder = new File(path_to_folder); File[] array_file = my_folder.listFiles(); for (int i = 0; i < array_file.length; i++){ if (array_file[i].isFile()){ File my_file = new File(path_to_folder + "" + array_file[i].getName()); String long_file_name = array_file[i].getName(); String[] my_token = long_file_name.split("\s"); ...
Read MoreJar files in Java
JAR is a file format that helps in aggregating Java class file, along with its associated metadata and resources into a single file.Creation of a JAR file − The jar cf command can be used, where ‘cf’ means creating the file.jar cf jar_file_name files_to_compressOnce a jar file has been created, a default manifest file is also created. Only one manifest file is present in a specific archive, and it will have the extension ‘mf’ and will be in the pathname. Thismanifest file helps give information about the files that have been compressed/present in the package.Viewing a JAR file − The ...
Read MoreInteresting Facts about Java
Java was built by sheer accident, a team of developers were busy building a set top box, and began cleaning C++. When they were winding up these changes, they ended up discovering Java and its runtime environment.Many of you might be aware of this, but for those who aren’t, Java wasn’t the original name that was decided for this language. It was ‘Oak’. Sun Marketing system changed the name later when they realized that a company named ‘Oak’ existed.It is a widely used language all over the world, and is considered to be a favourite amongst the developer group, and ...
Read MoreMySQL query to count records that begin with specific letters
Let us first create a table −mysql> create table DemoTable775 ( FirstName varchar(100) ); Query OK, 0 rows affected (0.78 sec)Insert some records in the table using insert command −mysql> insert into DemoTable775 values('Adam') ; Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable775 values('Carol'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable775 values('John'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable775 values('Sam'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable775 values('Adan'); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql> select ...
Read MoreDifference Between MySql <> NULL and IS NOT NULL?
If you compare the operator with NULL value then you will get NULL value always and no result.Let us see some examples for comparison −mysql> select 10 NULL; +------------+ | 10 NULL | +------------+ | NULL | +------------+ 1 row in set (0.00 sec) mysql> select NULL NULL; +--------------+ | NULL NULL | +--------------+ | NULL | +--------------+ 1 row in set (0.00 sec) mysql> select 'Chris' NULL; +-----------------+ | 'Chris' NULL | +-----------------+ | NULL | +-----------------+ 1 row in ...
Read MoreDisplay MySQL histogram with negative values?
For negative values, use reverse() along with concat(). Let us first create a table −mysql> create table DemoTable632 ( histogramId int NOT NULL AUTO_INCREMENT PRIMARY KEY, histogramValue int, histogramImage text ); Query OK, 0 rows affected (0.78 sec)Insert some records in the table using insert command −mysql> insert into DemoTable632(histogramValue) values(2); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable632(histogramValue) values(3); Query OK, 1 row affected (0.34 sec) mysql> insert into DemoTable632(histogramValue) values(-6); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable632(histogramValue) values(-5); Query OK, 1 row affected (0.13 sec)Display all records from the table ...
Read MoreCount occurrences of known distinct values in MySQL
For this, you can use aggregate function SUM(). Let us first create a table −mysql> create table DemoTable636 ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFirstName varchar(100) ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert into DemoTable636(StudentFirstName) values('John'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable636(StudentFirstName) values('Robert'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable636(StudentFirstName) values('Robert'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable636(StudentFirstName) values('Sam'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable636(StudentFirstName) values('Mike'); Query OK, ...
Read MoreHow can I display all databases in MySQL and for each database show all tables?
For this, you can use INFORMATION_SCHEMA. Following is the syntax −select my_schema.SCHEMA_NAME, group_concat(tbl.TABLE_NAME) from information_schema.SCHEMATA my_schema left join information_schema.TABLES tbl on my_schema.SCHEMA_NAME=tbl.TABLE_SCHEMA group by my_schema.SCHEMA_NAME;Let us implement the above syntax in order to show all databases in MySQL and for each database −mysql> select my_schema.SCHEMA_NAME, group_concat(tbl.TABLE_NAME) from information_schema.SCHEMATA my_schema left join information_schema.TABLES tbl on my_schema.SCHEMA_NAME=tbl.TABLE_SCHEMA group by my_schema.SCHEMA_NAME;This will produce the following output −+---------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | SCHEMA_NAME | group_concat(tbl.TABLE_NAME) ...
Read MoreComma separated argument applicable for IN operator in MySQL?
Use FIND_IN_SET() for command separated argument. Let us first create a table −mysql> create table DemoTable604 (Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Title varchar(100)); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert into DemoTable604(Title) values('MySQL'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable604(Title) values('C++'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable604(Title) values('MongoDB'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable604(Title) values('Java'); Query OK, 1 row affected (0.14 sec)Display all records from the table using select statement −mysql> select *from DemoTable604;This ...
Read More