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
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to create String object in Java?
You can create a String by -Assigning a string value wrapped in " " to a String type variable.String message = "Hello Welcome to Tutorialspoint";Creating an object of the String class using the new keyword by passing the string value as a parameter of its constructor.String message = new String ("Hello Welcome to Tutorialspoint");Passing a character array to the String constructor.char arr[] = {'H','e','l','l','o'}; String message = new String(arr);
Read MoreOrder VARCHAR records with string and numbers in MySQL
For this, use ORDER BY clause. Let us first create a table −mysql> create table DemoTable -> ( -> StudentCode varchar(20) -> ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('101J'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('100A'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values('100B'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('101S'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('103M'); Query OK, 1 row affected (0.15 ...
Read MoreHow to import java.lang.String class in Java?
To import any package in the current class you need to use the import keyword asimport packagename;ExampleLive Demoimport java.lang.String; public class Sample { public static void main(String args[]) { String s = new String("Hello"); System.out.println(s); } }OutputHello
Read MoreGet number of users of different type in MySQL?
Let us first create a table −mysql> create table DemoTable -> ( -> UserName varchar(20), -> UserType ENUM('New User', 'Registered User') -> ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 'New User'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('David', 'New User'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('Mike', 'Registered User'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('Sam', 'New User'); Query OK, 1 row affected (0.10 sec)Display all records ...
Read MoreRound records with numbers in MySQL
To round number, use MySQL ROUND(). Let us first create a table −mysql> create table DemoTable -> ( -> Amount DECIMAL(10, 4) -> ); Query OK, 0 rows affected (1.18 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100.578); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(1000.458); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(980.89); 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−+-----------+ | Amount | ...
Read MoreDisplay record with most recent time in MySQL
You can use ORDER BY STR_TO_DATE(). Let us first create a table −mysql> create table DemoTable -> ( -> DueTime varchar(20) -> ); Query OK, 0 rows affected (0.87 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('7:30AM'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('9:00PM'); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values('11:00PM'); 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−+---------+ | DueTime | +---------+ | ...
Read MoreSet conditions for columns with values 0 or 1 in MySQL
To set conditions, use CASE WHEN statement in MySQL. Let us first create a table −mysql> create table DemoTable -> ( -> Value1 int, -> Value2 int, -> Value3 int, -> Value4 int -> ); Query OK, 0 rows affected (0.98 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(1, 0, 1, 1); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable values(1, 0, 1, 0); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(1, 1, 1, 1); Query OK, 1 row affected (0.20 ...
Read MoreHow to change MySQL ending statement?
To change the MySQL ending statement, you can use DELIMITER −DELIMITER anySymbolAbove, anySymbol is the symbol you can set. The default is DELIMITER ;Let us first create a table −mysql> DELIMITER // mysql> create table DemoTable -> ( -> Id int, -> Name varchar(20) -> )// Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 'Chris')// Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable values(101, 'David')// Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values(102, 'Bob')// Query OK, 1 ...
Read MoreQuery to find Nth maximum value in MySQL
Let us first create a table −mysql> create table DemoTable -> ( -> Value int -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(40); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable values(60); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values(45); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values(85); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(78); Query OK, 1 row affected (0.10 sec)Display all records from the table ...
Read MoreHow to batch update MySQL table?
Let us first create a table −mysql> create table DemoTable -> ( -> BreakfastTime time -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('7:30:45'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('8:00:30'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('7:55:00'); Query OK, 1 row affected (0.10 sec)Display all records from the table using select statement −mysql> select * from DemoTable;This will produce the following output −+---------------+ | BreakfastTime | +---------------+ | 07:30:45 | | ...
Read More