With the help of SHOW TABLES From Database_name query, we can see the tables of another database. Here Database_name is the name of the database which we are not using currently. Consider the following example in which we run the query for getting the list of tables in database name ‘tutorial’.mysql> ... Read More

As we know that whenever an exception occurred in MySQL stored procedure, it is very important to handle it by throwing proper error message because if we do not handle the exception, there would be a chance to fail application with that certain exception in a stored procedure. MySQL provides ... Read More

We can get the list of MySQL server-side help categories by giving the keyword contents to the help command.mysql> help contents You asked for help about help category: "Contents" For more information, type 'help ', where is one of the following categories:    Account Management    Administration    Compound ... Read More

Transferring the information between MySQL and data files mean importing data from data files into our database or exporting data from our database into files. MySQL is having two commands that can be used to import or export data between MySQL and data files through the command line −mysqlimport Actually, mysqlimport ... Read More

The text-shadow property is used to set the text shadow around a text.ExampleYou can try to run the following code to implement text-shadow property:                            Indian is a country in continent Asia.          

The font-family property is used to change the face of a font. Possible value could be any font family name.                            This text is rendered in either georgia, garamond, or the default serif font          depending on which font you have at your system.          

The background-repeat property is used to control the repetition of an image in the background. You can use no-repeat value for the background-repeat property if you do not want to repeat an image, in this case, the image will display only once:ExampleYou can try to run the following code to learn ... Read More

To include stylesheet rules, use the element or style attribute or even external stylesheet using .The element can be used to include an external style sheet file in your HTML document.An external style sheet is a separate text file with .css extension. You define all the Style rules ... Read More

We can add ‘half year interval’ in date ith the following ways −(A) By adding interval of 6 Monthsmysql> Select '2017-06-20' + INTERVAL 6 Month AS 'After Half Year Interval'; +--------------------------+ | After Half Year Interval | +--------------------------+ |  2017-12-20              | +--------------------------+ 1 row ... Read More

When we try to do such kind of operations with date values stored in the table then MySQL is assuming the date values as the number and perform the arithmetic.Suppose we have a table named ‘example’ having a date value in ‘orderdate’ column then following arithmetic operation will clarify the ... Read More