George John has Published 1167 Articles

What does the method pop() do in java?

George John

George John

Updated on 30-Jul-2019 22:30:21

376 Views

The pop() method is used to remove the object at the top of this stack and returns that object as the value of this function. Example import java.util.*; public class StackDemo { public static void main(String args[]) { Stack ... Read More

How can we set PRIMARY KEY on multiple columns of a MySQL table?

George John

George John

Updated on 30-Jul-2019 22:30:21

788 Views

Actually, MySQL allows us to set PRIMARY KEY on multiple columns. The advantage of doing this is that we can work on multiple columns as a single entity. Example We have created the table allotment by defining composite PRIMARY KEY on multiple columns as follows − mysql> Create table ... Read More

How to Initialize and Compare Strings in Java?

George John

George John

Updated on 30-Jul-2019 22:30:21

123 Views

You can compare Strings using compareTo() method or, equals() method or, or == operator. Following example demonstrates how to initialize and compare strings in Java. Example Live Demo public class StringDemo { public static void main(String[] args) { String ... Read More

I am calling RAND() function two times in the same query then will it generate same random number two times or will it generate two different random numbers?

George John

George John

Updated on 30-Jul-2019 22:30:21

216 Views

We know that MySQL RAND() returns a random floating point value between the range of 0 and 1. It will generate two different random numbers if we will call the RAND() function, without seed, two times in the same query. Following example will make it clearer − Example mysql> ... Read More

How can we remove FOREIGN KEY constraint from a column of an existing MySQL table?

George John

George John

Updated on 30-Jul-2019 22:30:21

10K+ Views

We can remove FOREIGN KEY constraint from a column of an existing table by using DROP keyword along with ALTER TABLE statement. Syntax ALTER TABLE table_name DROP FOREIGN KEY constraint_name Here constraint name is the name of foreign key constraint which we applied while creating the table. If ... Read More

How can we apply AUTO_INCREMENT to a column?

George John

George John

Updated on 30-Jul-2019 22:30:21

115 Views

AUTO_INCREMENT means that the column will get the value automatically. To illustrate it we have created a table ‘employees’ as follows − mysql> Show Create Table employees\G *************************** 1. row *************************** Table: employees Create Table: CREATE TABLE `employees` ( `Id` int(11) NOT NULL AUTO_INCREMENT, ... Read More

Returning an array in Java

George John

George John

Updated on 30-Jul-2019 22:30:21

144 Views

Yes, an array can be returned from a java function. See the example below − Example public class Tester { public static void main(String[] args) { int[] array = getData(); for(int i: array) { System.out.println(i); } } public static int[] getData() { int[] dataArray = {1, 2, 3, 4}; return dataArray; } } Output 1 2 3 4

How to get the list of tables in default MySQL database?

George John

George John

Updated on 30-Jul-2019 22:30:21

322 Views

As we know that the default MySQL database would be the database that is currently in use for subsequent queries. We can get the list of tables in that database by using SHOW TABLES statement. mysql> SHOW TABLES; +------------------+ | Tables_in_sample | +------------------+ | employee ... Read More

How to redirect URL to the different website after few seconds?

George John

George John

Updated on 30-Jul-2019 22:30:21

5K+ Views

Page redirection is a situation where you clicked a URL to reach a page X but internally you were directed to another page Y. It happens due to page redirection. To redirect URL to a different website after few seconds, use the META tag, with the content attribute. The attributes ... Read More

When is a semicolon after } mandated in C++ Program?

George John

George John

Updated on 30-Jul-2019 22:30:21

2K+ Views

A semicolon after a close brace is mandatory if this is the end of a declaration. In case of braces, they have used in declarations of class, enum, struct, and initialization syntax. At the end of each of these statements, we need to put a semicolon. For example, class ... Read More

Advertisements