George John has Published 1080 Articles

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

11K+ 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

188 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

255 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

506 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

7K+ 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

3K+ 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

What is the fastest, pure JavaScript, Graph visualization toolkit?

George John

George John

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

151 Views

The fastest and pure JavaScripr Graph visualization toolkit isJavaScript InfoVis Toolkit. With it, you can, Perform Graph manipulation, Create bar graphs, Custom nodes, Implementing NodeTypes Adding subtrees, Drag and drop nodes, etc.

How to add a Favicon to Your WordPress Site?

George John

George John

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

256 Views

A favicon is a little icon visible on the web browser tab, just before the page title. It is generally a logo with the smaller size. You need to include a Site Icon in WordPress to add a favicon to your WordPress site. Login to your WordPress website and from ... Read More

Java variable naming rules

George John

George John

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

4K+ Views

All Java components require names. Names used for classes, variables, and methods are called identifiers. In Java, there are several points to remember about identifiers. They are as follows - Step 1 − All identifiers should begin with a letter (A to Z or a to z), currency character ($) ... Read More

Atomic variables in Java

George John

George John

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

476 Views

Yes, from Java 8 onwards, java.util.concurrent.atomic package contains classes which support atomic operations on single variables preventing race conditions or do not face synchronization issues. All classes in the atomic package have get/set methods. Each set method has a happens-before relationship with any subsequent get() method call on the same ... Read More

Advertisements