Seetha has Published 93 Articles

CSS3 Diagonal Gradient

seetha

seetha

Updated on 20-Jun-2020 12:53:23

394 Views

Diagonal starts at top left and right button. You can try to run the following code to implement diagonal gradients in CSS3 −Live Demo                    #grad1 {             height: 100px;             ... Read More

How can we create a MySQL user account by omitting the hostname?

seetha

seetha

Updated on 20-Jun-2020 11:47:50

179 Views

If we omit the hostname part of the user account, MySQL will accept it and allow the user to connect from any host. Its syntax would be as follows −Use mysql; CREATE USER user_name IDENTIFIED BY password;Here, user_name is the name of the user we wish to take account of.Password is ... Read More

How can we distinguish between MySQL CROSS JOIN and INNER JOIN?

seetha

seetha

Updated on 20-Jun-2020 11:06:05

260 Views

We can distinguish between MySQL CROSS JOIN and INNER JOIN only on the basis of join-predicate i.e. the condition specified. While writing the query for INNER JOIN we need to specify the condition but in contrast, we do not need to specify the condition while writing a query for CROSS ... Read More

What is the similarity between prepared statements and MySQL user variables?

seetha

seetha

Updated on 20-Jun-2020 10:57:22

48 Views

As we know that MySQL user variables are specific to client connection within which they are used and exist only for the duration of that connection. When a connection ends, all its user variables are lost. Similarly, the prepared statements also exist only for the duration of the session in ... Read More

How can we MySQL LOAD DATA INFILE statement with ‘ENCLOSED BY’ option to import data from text file into MySQL table?

seetha

seetha

Updated on 20-Jun-2020 09:15:29

631 Views

Sometimes the input text files have the text fields enclosed by double quotes and to import data from such kind of files we need to use the ‘ENCLOSED BY’ option with LOAD DATA INFILE statement. We are considering the following example to make it understand −ExampleFollowings are the comma-separated values ... Read More

Additional color properties provided by CSS3

seetha

seetha

Updated on 20-Jun-2020 09:01:23

52 Views

CSS3 has additional color properties as follows −RGBA colorsHSL colorsHSLA colorsLet us see what are HSL colors:HSL stands for hue, saturation, lightness. Here, Huge is a degree of the color wheel, saturation and lightness are percentage values between 0 to 100%.A sample syntax of HSL as shown below:#g1 {background-color: hsl(120, 100%, ... Read More

How MySQL handles the empty and null values for enumerations?

seetha

seetha

Updated on 20-Jun-2020 08:48:00

840 Views

MySQL accepts empty values for enumeration only if SQL mode is not set as TRADITIONAL, STRICT_TRANS_TABLES or STRICT_ALL_TABLES. Otherwise, MySQL would not accept empty values and throws an error. As we know that each enumeration value is having an index value, the empty value would have 0 index value.Examplemysql> SET ... Read More

How can we change MySQL AUTO_INCREMENT starting number?

seetha

seetha

Updated on 20-Jun-2020 07:49:06

104 Views

MySQL AUTO_INCREMENT value starts from 1 but we can change it with the help of following two ways −With the help of ALTER TABLE query We can use ALTER TABLE query to change the staring value of AUTO_INCREMENT as follows −ALTER TABLE table_name AUTO_INCREMENT = value;ExampleSuppose we have created a ... Read More

What MySQL will return on adding microseconds in the timestamp value for converting it into an integer?

seetha

seetha

Updated on 20-Jun-2020 06:34:20

49 Views

As we know that the value of timestamp can be converted to a number of seconds with the help of UNIX_TIMESTAMP() function. MySQL would ignore the microseconds added to the value of timestamp because the value of UNIX_TIMESTAMP is only 10digits long.Examplemysql> SELECT UNIX_TIMESTAMP('2017-10-22 04:05:36')AS 'Total Number of Seconds'; +-------------------------+ ... Read More

How to create Empty Values String in JavaScript?

seetha

seetha

Updated on 19-Jun-2020 11:20:59

1K+ Views

To create empty values string in JavaScript, you can try to run the following code −Example                    var val;          val = "";          document.write("Value: "+val);          document.write("Type: "+typeof val);                  

Advertisements