In this program, we will convert a string to both lowercase and uppercase using toLowerCase() and toUpperCase() methods of Java. The toUpperCase() method converts all of the characters in this String to upper case using the rules of the default locale. The toLowerCase() method converts all of the characters in ... Read More

CSS or Cascading Style Sheets is used to design the web pages, it helps web developers to control the layout and other visual aspects of the web pages. Using CSS, you can control the color of the text, the style of fonts, the spacing between paragraphs, how columns are sized ... Read More

All Java components require names. Names used for classes, variables and methods are called identifiers. The naming conventions for different Java components are as follows: Package Naming Convention Class Naming Convention ... Read More

Let us look at an example that creates a package called animals. It is a good practice to use names of packages with lower case letters to avoid any conflicts with the names of classes and interfaces.Following package example contains interface named animals −/* File name : Animal.java */ package ... Read More

We should avoid using global variables in any language, not only C++. This is because these variables pollute the global namespace, can cause some very nasty bugs in big projects as they can be accessed from any file and hence be modified from anywhere. These are some of the reasons ... Read More

LOAD DATAThis statement is used for importing the data from data files into our database. It reads data records directly from a file and inserts them into a table. Its syntax would be as follows −SyntaxLOAD DATA LOCAL INFILE '[path/][file_name]' INTO TABLE [table_name ];Here, a path is the address of ... Read More

As we know that MySQL provides us loop statements that allow us to execute a block of SQL code repeatedly based on a condition. WHILE loop statement is one of such kind of loop statements. Its syntax is as follows −WHILE expression DO statements END WHILEActually, the WHILE loop checks ... Read More

The column-span property is used to specify the span between columns. You can try to run the following code to implement column-span property using CSS −Example Live Demo    .multi {       /* Column count property */       -webkit-column-count: 4;       -moz-column-count: 4; ... Read More

As we know that the default format for MySQL DATE data type is “YYYY-MM-DD” and in this format, there is no possibility to store the time value. But still, if we store date along with time value in a column having DATE data type then MySQL will show a warning ... Read More

Suppose we want to store the date such as February 30 in a MySQL table then we must have to first set ALLOW_INVALID_DATES mode enabled.For example, I am trying to add, without enabling ALLOW_INVALID_DATES mode, such kind of date in a table then MySQL will give an error as follows ... Read More