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 807 of 840
How to remove only the first word from columns values with a MySQL query?
To remove only the first word from column values, use substring(). Following is the syntax −select substring(yourColumnName, locate(' ', yourColumnName)+1) AS anyAliasName from yourTableName;Let us first create a table −mysql> create table DemoTable ( Title text ); Query OK, 0 rows affected (0.50 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Java in Depth'); Query OK, 1 row affected (0.49 sec) mysql> insert into DemoTable values('C++ is an object oriented programming language'); Query OK, 1 row affected (0.47 sec) mysql> insert into DemoTable values('MySQL is a relational database'); Query OK, 1 row affected (0.17 ...
Read MoreRemove 20% from stored price in MySQL field, using SQL query?
Let’s say the stored price is inclusive of 20% sales tax. Now, let us first create a table −mysql> create table DemoTable ( Price int ); Query OK, 0 rows affected (1.09 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(20); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(40); Query OK, 1 row affected (0.07 sec) mysql> insert into DemoTable values(80); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values(60); Query OK, 1 row affected (0.18 sec)Display all records from the table using select statement −mysql> select ...
Read MoreConvert Iterator to Iterable in Java
Let’s say the following is our Iterator with Integer values −Iteratoriterator = Arrays.asList(20, 40, 60, 80, 100, 120, 150, 200).iterator();Now, convert the Iterator to Iterable −Iterableiterable = StreamSupport.stream(Spliterators.spliteratorUnknownSize(iterator, 0),false).collect(Collectors.toList());ExampleFollowing is the program to convert Iterator to Iterable in Java −import java.util.*; import java.util.stream.Collectors; import java.util.stream.StreamSupport; public class Demo { public static void main(String[] args) { Iteratoriterator = Arrays.asList(20, 40, 60, 80, 100, 120, 150, 200).iterator(); Iterableiterable = StreamSupport.stream(Spliterators.spliteratorUnknownSize(iterator, 0), false).collect(Collectors.toList()); System.out.println("Iterable = "); iterable.forEach(System.out::println); } }OutputIterable = 20 40 60 80 100 120 150 200
Read MoreConvert an Iterator to Stream in Java
At first, set an Interator −Iteratoriterator = Arrays.asList(50, 100, 200, 400, 500, 1000).iterator();Now, we have used stream −Streamstream = convertIterator(iterator);Above, the method convertIterator() is used for conversion. Following is the method −public static Stream convertIterator(Iterator iterator) { return StreamSupport.stream(((Iterable) () -> iterator).spliterator(), false); }ExampleFollowing is the program to convert an Iterator to Stream in Java −import java.util.stream.*; import java.util.*; public class Demo { public static Stream convertIterator(Iterator iterator) { return StreamSupport.stream(((Iterable) () -> iterator).spliterator(), false); } public static void main(String[] args) { Iteratoriterator = Arrays.asList(50, 100, 200, ...
Read MoreConvert a Set of String to a comma separated String in Java
Let us first create a set with string values −Setset = new HashSet(Arrays.asList("One", "Two", "Three", "Four", "Five", "Six"));Now, convert it to a comma separated string using String.join() −String str = String.join(", ", set);ExampleFollowing is the program to convert set of string to a comma separated string in Java −import java.util.*; public class Demo { public static void main(String args[]) { Setset = new HashSet(Arrays.asList("One", "Two", "Three", "Four", "Five", "Six")); System.out.println("Set = " + set); String str = String.join(", ", set); System.out.println("Comma separated String: "+ str); } ...
Read MoreConvert a List of String to a comma separated String in Java
At first, let’s say the following is our List of String −List myList = new ArrayList(Arrays.asList("One", "Two", "Three", "Four"));Now, convert this to a comma separated string using String.join()String str = String.join(", ", myList);ExampleFollowing is the program to convert List of String to a comma separated String in Java −import java.util.*; public class Demo { public static void main(String args[]) { List myList = new ArrayList(Arrays.asList("One", "Two", "Three", "Four")); System.out.println("List = " + myList); // comma separated String str = String.join(", ", myList); System.out.println("String (Comma ...
Read MoreConversion of Java Maps to List
At first, let us create a Java Map and initialize −Map map = new HashMap(); map.put(1, "Tom"); map.put(2, "John"); map.put(3, "Kevin"); map.put(4, "Jacob"); map.put(5, "Ryan");Now, convert the Map to List −ArrayList key = new ArrayList(map.keySet()); ArrayList value = new ArrayList(map.values());ExampleFollowing is the program to convert Maps to List in Java −import java.util.HashMap; import java.util.ArrayList; import java.util.Map; public class Demo { public static void main(String args[]) { Map map = new HashMap(); map.put(1, "Tom"); map.put(2, "John"); map.put(3, "Kevin"); map.put(4, "Jacob"); map.put(5, "Ryan"); ...
Read MoreProgram to convert Boxed Array to Stream in Java
A boxed array is an array which is defined in the form of an object, instead of the primitives.ExampleFollowing is the program to convert Boxed Array to Stream in Java −import java.util.*; import java.util.stream.*; public class Demo { public static void main(String args[]) { String arr[] = { "Laptop", "Mobile", "Notebook", "Desktop" }; System.out.println("Array = "+ Arrays.toString(arr)); Streams = Stream.of(arr); System.out.println("Stream (array to stream) = "+ Arrays.toString(s.toArray())); } }OutputArray = [Laptop, Mobile, Notebook, Desktop] Stream (array to stream) = [Laptop, Mobile, Notebook, Desktop]
Read MoreConvert an ArrayList of String to a String array in Java
At first, let us set an ArrayList of string −ArrayList arrList = new ArrayList(); arrList.add("Bentley"); arrList.add("Audi"); arrList.add("Jaguar"); arrList.add("Cadillac");Now, use toArray() to convert to a string array −int size = arrList.size(); String res[] = arrList.toArray(new String[size]);ExampleFollowing is the program to convert an ArrayList of String to a String array in Java −import java.util.*; public class Demo { public static void main(String[] args) { ArrayList arrList = new ArrayList(); arrList.add("Bentley"); arrList.add("Audi"); arrList.add("Jaguar"); arrList.add("Cadillac"); arrList.add("Mazda"); arrList.add("Land Rover"); arrList.add("Porsche"); ...
Read MoreConvert String into comma separated List in Java
At first, set a list with string values −List myList = new ArrayList( Arrays.asList("One", "Two", "Three", "Four"));Now, use String.join() to set them as a comma separated list −String str = String.join(", ", myList);ExampleFollowing is the program to convert string into comma separated List in Java −import java.util.*; public class Demo { public static void main(String args[]) { List myList = new ArrayList(Arrays.asList("One", "Two", "Three", "Four")); System.out.println("List = " + myList); // comma separated String str = String.join(", ", myList); System.out.println("String (Comma Separated) = " ...
Read More