Giri Raju has Published 116 Answers

Add shadow effects to elements with CSS

Giri Raju

Giri Raju

Updated on 20-Jun-2020 13:22:09

Use the box-shadow property to add shadow effects to elements.The following is an example to add shadow effects −ExampleLive Demo<html>    <head>       <style>          div {             width: 300px;             height: 100px;     ... Read More

How can we change MySQL user password by using UPDATE statement?

Giri Raju

Giri Raju

Updated on 20-Jun-2020 11:43:23

To change MySQL user password with the help of UPDATE statement, we need to update the ‘user’ table of the ‘mysql’ database. Its syntax would be as follows −SyntaxUSE mysql; UPDATE user SET authentication_string = PASSWORD(‘new_password’) WHERE user = user_name AND host = host_name;The first two statements will be common ... Read More

What do you mean MySQL user variables and how can we assign values to them?

Giri Raju

Giri Raju

Updated on 20-Jun-2020 10:51:00

MySQL user variables are written as @variable and it may be set to an integer, real, string or NULL value. With the help of SET statement, we can assign a value to the user variable. We can use either = or := as the assignment operator while assigning the values ... Read More

How can we export all the data from MySQL table into a CSV file?

Giri Raju

Giri Raju

Updated on 20-Jun-2020 09:22:06

It can be done with the help of SELECT … INTO OUTFILE statement. We are illustrating it with the help of the following example −ExampleSuppose we are having following data from table ‘Student_info’ −mysql> Select * from Student_info; +------+---------+------------+------------+ | id   | Name    | Address    | Subject ... Read More

What is the maximum length of data we can put in a BLOB column in MySQL?

Giri Raju

Giri Raju

Updated on 20-Jun-2020 08:30:05

As we know that BLOB is a binary large object that can hold a variable amount of data. The different TEXT objects offer a range of storage space from 255 bytes to 4 Gb. Following table shows the storage of different kinds of BLOB data type −Type of BLOBMaximum amount ... Read More

What kind of compound units can be used in MySQL EXTRACT() function?

Giri Raju

Giri Raju

Updated on 20-Jun-2020 06:14:32

MySQL EXTRACT() function can use following compound units −SECOND_MICROSECONDMINUTE_MICROSECONDHOUR_MICROSECONDDAY_MICROSECONDMINUTE_SECONDHOUR_SECONDHOUR_MINUTEDAY_SECONDDAY_MINUTEDAY_HOURYEAR_MONTHSome of the examples of these compound units used in EXTRACT() function are as follows −mysql> Select EXTRACT(YEAR_MONTH from '2017-10-20'); +---------------------------------------+ | EXTRACT(YEAR_MONTH from '2017-10-20') | +---------------------------------------+ |                             ... Read More

How many groups of data types are supported by MySQL?

Giri Raju

Giri Raju

Updated on 19-Jun-2020 13:25:45

MySQL uses many different data types broken into three categories −NumericDate and TimeString TypesNUMERIC DATA TYPESMySQL uses all the standard ANSI SQL numeric data types, so if you're coming to MySQL from a different database system, these definitions will look familiar to you.The following list shows the common numeric data ... Read More

What is onmousemove event in JavaScript?

Giri Raju

Giri Raju

Updated on 19-Jun-2020 11:07:27

The onmousemove event triggers when the mouse pointer moves.ExampleYou can try to run the following code to learn how to work with onmousemove event in JavaScript −<html>    <head>       <script>          <!--             function sayHello() {         ... Read More

What are basic JavaScript mathematical operators?

Giri Raju

Giri Raju

Updated on 19-Jun-2020 08:25:40

The basic mathematical operators in JavaScript include the following −Arithmetic OperatorsComparison OperatorsLogical (or Relational) OperatorsAssignment OperatorsLet’s see how Arithmetic operators work and what does it include −Sr.NoOperator and Description1+ (Addition)Adds two operandsEx: A + B will give 302- (Subtraction)Subtracts the second operand from the firstEx: A - B will give ... Read More

How to get the arctangent (in radians) of a number in JavaScript?

Giri Raju

Giri Raju

Updated on 19-Jun-2020 07:27:57

To get the arctangent of a number, use the atan() method in JavaScript. This method returns the arctangent in radians of a number. The atan method returns a numeric value between -pi/2 and pi/2 radians.ExampleYou can try to run the following code to get the arctangent of a number in ... Read More

Advertisements