Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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
Let us first create a table −mysql> create table DemoTable -> ( -> Name varchar(20) -> ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris Brown'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('Adam Smith'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('John Smith'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Carol Smith'); Query OK, 1 row affected (0.13 sec)Display all records from the table using select statement −mysql> select * from DemoTable;This ... Read More
Let us first create a table −mysql> create table DemoTable -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(10, NULL); Query OK, 1 row affected (0.32 sec) mysql> insert into DemoTable values(NULL, 'David'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values(NULL, NULL); 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 following output−+------+-------+ | Id | ... Read More
Yes, you can store double and date in VARCHAR. Let us first create a table −mysql> create table DemoTable -> ( -> Amount varchar(20), -> JoiningDate varchar(20) -> ); Query OK, 0 rows affected (0.96 sec)Insert some records in the table using insert command. We are inserting varchar double and date values −mysql> insert into DemoTable values('150.50', 'Oct 10, 2019'); Query OK, 1 row affected (0.91 sec) mysql> insert into DemoTable values('173.45', 'Sept 11, 2018'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('173.90', 'Jan 01, 2017'); Query OK, 1 row affected (0.16 ... Read More
Let us first create a table −mysql> create table DemoTable -> ( -> StudentName varchar(20), -> StudentMarks int -> ); Query OK, 0 rows affected (0.68 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 50); Query OK, 1 row affected (0.61 sec) mysql> insert into DemoTable values('David', 70); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values('Chris', 80); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('David', 90); Query OK, 1 row affected (0.24 sec)Display all records from the table using select statement −mysql> ... Read More
To find duplicate tuples, use GROUP BY HAVING clause. Let us first create a table −mysql> create table DemoTable -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.80 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 'Chris'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(101, 'David'); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values(101, 'Mike'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(100, 'Carol'); Query OK, 1 row affected (0.17 sec) ... Read More
To add a new NOT NULL column to an already created table, use ALTER command. Let us first create a table −mysql> create table DemoTable -> ( -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentName varchar(20) -> ); Query OK, 0 rows affected (0.60 sec)Following is the query to add a new NOT NULL column to an existing table −mysql> alter table DemoTable add column StudentAge int NOT NULL; Query OK, 0 rows affected (0.52 sec) Records: 0 Duplicates: 0 Warnings: 0Insert some records in the table using insert command −mysql> insert into DemoTable(StudentName, ... Read More
Let us first create a table −mysql> create table DemoTable -> ( -> Code varchar(20) -> ); Query OK, 0 rows affected (0.70 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('J23'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values('C13'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable values('A61'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('D56'); Query OK, 1 row affected (0.11 sec)Display all records from the table using select statement −mysql> select * from DemoTable;This will produce the following ... Read More
You can concatenate two strings in Java either by using the concat() method or by using the ‘+’ , the “concatenation” operator.The concat() methodThe concat() method appends one String to the end of another. This method returns a String with the value of the String passed into the method, appended to the end of the String, used to invoke this method.Examplepublic class ConncatSample { public static void main(String []args) { String s1 = "Hello"; String s2 = "world"; String res = s1.concat(s2); System.out.print("Concatenation result:: "); ... Read More
You can finish your task by combining/ concatenating your two stings using concat() method or + operator.Exampleimport java.util.Scanner; public class ConncatSample { public static void main(String []args) { Scanner sc = new Scanner(System.in); System.out.println("Enter your first name"); String firstName = sc.nextLine(); System.out.println("Enter your last name"); String lastName = sc.nextLine(); String completeName = firstName+lastName; System.out.print("Hi your complete name is :: "); System.out.println(completeName); } }OutputEnter your first name KrishnaKasyap Enter your last name BhagavatulaHi your complete ... Read More