Vanithasree has Published 80 Articles

How can we get an idea about the server performance from the output of MySQL?

vanithasree

vanithasree

Updated on 11-Feb-2020 07:02:22

102 Views

After running a query, MySQL returns the number of rows and gives time in the output that shows how much it took for running that query. As for example, if we run the following querymysql> create table e1(id int); Query OK, 0 rows affected (0.23 sec)It is showing the time ... Read More

How to set the whitespace between text in CSS?

vanithasree

vanithasree

Updated on 31-Jan-2020 06:37:37

232 Views

To set the whitespace between text, use the white-space property. Possible values are normal, pre, nowrap.ExampleYou can try to run the following code to set the whitespace between text in CSS:                            This text has a line break ... Read More

Set the font family with CSS

vanithasree

vanithasree

Updated on 30-Jan-2020 10:34:23

462 Views

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.          

Usage of background-attachment property in CSS

vanithasree

vanithasree

Updated on 30-Jan-2020 09:23:52

73 Views

The background-attachment property is used to control the scrolling of an image in the background.ExampleYou can try to run the following code to learn how to work with the background-attachment property:                    body {             ... Read More

ID Selectors in CSS

vanithasree

vanithasree

Updated on 30-Jan-2020 07:54:45

594 Views

You can define style rules based on the id attribute of the elements. All the elements having that id will be formatted according to the defined rule. #black {    color: #000000; }This rule renders the content in black for every element with id attribute set to black in our document. ... Read More

What is the query to know about all character sets supported by MySQL?

vanithasree

vanithasree

Updated on 30-Jan-2020 06:23:43

140 Views

With the help of the following query we can see all the character sets supported by MySQL −mysql> Show Character Set; +-----------+-----------------------------+---------------------+--------+ | Charset   | Description                 | Default collation   | Maxlen | +---------- +-----------------------------+---------------------+--------+ | big5      | Big5 ... Read More

With the help of function, how can we return the difference in Year, Month and Days between two date values?

vanithasree

vanithasree

Updated on 29-Jan-2020 06:37:59

109 Views

We can create a function, which accepts the date values as its argument and returns the difference in year, month and days, as followsmysql> CREATE FUNCTION date_difference(Date1 DATE, date2 DATE) RETURNS VARCHAR(30)    -> RETURN CONCAT(    -> @years := TIMESTAMPDIFF(YEAR, date1, date2), IF (@years = 1, ' year, ', ... Read More

How does comparison operator work with date values in MySQL?

vanithasree

vanithasree

Updated on 28-Jan-2020 10:41:23

197 Views

Comparison operator between dates will work in a logical way. In the following example, while comparing two dates, MySQL is simply comparing two numbers or string −mysql> select 20171027 < 20150825; +---------------------------+ | 20171027 < 20150825       | +---------------------------+ |                 ... Read More

In MySQL, when VARCHAR data type will use 1-byte and when 2-bytes prefix length along with data?length along with data?

vanithasree

vanithasree

Updated on 28-Jan-2020 09:29:04

171 Views

As we know that in MySQL, VARCHAR values are stored as a 1-byte or 2-byte length prefix plus data. This length prefix points out the number of bytes in the value of data. The data value itself will decide that when VARCHAR data type will use 1-byte and when 2-byte ... Read More

What is onclick event in JavaScript?

vanithasree

vanithasree

Updated on 08-Jan-2020 10:19:53

564 Views

The onClick event is the most frequently used event type, which occurs when a user clicks the left button of the mouse.ExampleYou can put your validation, warning etc., against this event type.Live Demo                                         Click the following button and see result                          

Advertisements