It can be done with the SHOW COLUMNS statement. Its Syntax would be as follows:SyntaxSHOW COLUMNS FROM tab_name IN db_nameHere,  tab_name is the name of the table from which we want to see the list of columns.Db_name is the name of the database, in which the table is storedExampleIn the ... Read More

The EXIT or QUIT commands take you returned to windows from MySQL command line tool.mysql> EXITORmysql> QUIT

Writing inner joins with the help of comma operator is the most basic way to combine two tables. As we know that we can also write inner join by using keyword INNER JOIN or synonyms like JOIN. To form an inner join we need to specify a particular condition which ... Read More

To decorate a text in CSS, use the text-decoration property. The following example demonstrates how to decorate a text. Possible values are none, underline, overline, line-through, blink.                            This will be underlined                      This will be striked through.                      This will have a over line.                      This text will have blinking effect          

Use the text-decoration property to underline text with CSS. You can try to run the following code to underline text:                            India          

To set the background image position, use the background-position property. You can try to run the following code to learn how to work with the background-position property:ExampleIt sets the background image position 80 pixels away from the left side:                    body { ... Read More

To set font size with CSS Measurement Unit vmin, try to run the following code:                            This div has relative positioning.          

To define a measurement in screen pixels with CSS, use the px unit.Let us see an example:                            This div has relative positioning.          

In this case, MySQL will take into consideration right most unit given in compound INTERVAL unit. It will return the output after calculating the interval on the basis of single value provided in the enclosed set of unit values. The following example will clarify it −mysql> Select TIMESTAMP('2017-10-22 04:05:36' + ... Read More

With the help of following example we can understand that how we can use MySQL INTERVAL keyword with EXTRACT() function −mysql> Select StudentName, RegDate, EXTRACT(YEAR from RegDate+INTERVAL 2 year) AS 'Two Year Interval' from testing where StudentName = 'Gaurav'; +-------------+---------------------+-------------------+ | StudentName | RegDate             ... Read More