Nitya Raut has Published 276 Articles

How can we take a backup of all the databases by using mysqldump client program?

Nitya Raut

Nitya Raut

Updated on 07-Feb-2020 06:38:46

152 Views

By using mysql dump client program we can take the backup of all the databases into a file having the extension ‘.sql’. It can be understood with the help of the following example −ExampleIn this example, with the help of mysql dump client program, we are taking the backup all ... Read More

How can we search a record from MySQL table having a date as a value in it?

Nitya Raut

Nitya Raut

Updated on 30-Jan-2020 06:29:55

66 Views

It can be understood with the help of following example in which we are using the following data from the table named ‘detail_bday’ −mysql> Select * from detail_bday; +----+---------+------------+ | Sr | Name    | Birth_Date | +----+---------+------------+ | 1  | Saurabh | 1990-05-12 | | 2  | Raman   ... Read More

What is the usage of
and

Nitya Raut

Nitya Raut

Updated on 29-Jan-2020 10:24:41

48 Views

The elements and are useful for screenreaders as well and help visually impaired users in reading the content of your web page. These are beneficial for eBook readers as well.Let us see how to work with both the elements.           HTML Section Tag ... Read More

What are the DataTransfer object attributes?

Nitya Raut

Nitya Raut

Updated on 29-Jan-2020 08:21:27

275 Views

The DataTransfer object holds data about the drag and drop operation. This data can be retrieved and set in terms of various attributes associated with the DataTransfer object.The following are the attributes:Sr.No.DataTransfer attributes and their description1dataTransfer.dropEffect [ = value ]Returns the kind of operation that is currently selected.This attribute can ... Read More

URL Encoding in HTML5

Nitya Raut

Nitya Raut

Updated on 29-Jan-2020 07:29:40

173 Views

URL encoding is the practice of translating unprintable characters or characters with special meaning within URLs to a representation that is unambiguous and universally accepted by web browsers and servers. These characters include −ASCII control characters − Unprintable characters typically used for output control. Character ranges 00-1F hex (0-31 decimal) ... Read More

Test if the HTML attribute tabindex is present and get the value

Nitya Raut

Nitya Raut

Updated on 29-Jan-2020 06:35:53

256 Views

To get the value of the HTML attribute, try the following:$("#demo").attr("tabindex")The attr() method can be used to either fetch the value of an attribute from the first element in the matched set or set attribute values onto all matched elements.You can also use the hasAttribute() method to see if there ... Read More

What would be output if we will try to extract time values by providing the date values only to MySQL EXTRACT() function?

Nitya Raut

Nitya Raut

Updated on 29-Jan-2020 06:03:30

49 Views

When we try to extract hour value from a date, then EXTRACT() function will give the output 0 with a warning as shown in the below-given example −mysql> Select EXTRACT(Hour from '2017-10-20'); +---------------------------------+ | EXTRACT(Hour from '2017-10-20') | +---------------------------------+ | 0                 ... Read More

In MYSQL, how can we store a date where the day, month or both month & day are zero?day are zero?

Nitya Raut

Nitya Raut

Updated on 28-Jan-2020 10:34:35

215 Views

To store such kind of dates where the day, month or both month & day are zero we must have to set mode of sql to allow_invalid_dates mode.mysql> set sql_mode = 'allow_invalid_dates'; Query OK, 0 rows affected (0.00 sec) mysql> insert into check_date(OrderDate) values('2017-00-00'); Query OK, 1 row affected ... Read More

Flexbox layout losing proportions when reduced in size

Nitya Raut

Nitya Raut

Updated on 28-Jan-2020 09:19:54

62 Views

To avoid the Flexbox layout issue, you need to add the following:* {    flex-shrink: 0;    min-width: 0;    min-height: 0; }Here, flex-shrink: 1 - Flex items are allows to shrinkmin-width: 0 - flex items to shrink past their content

Cancels ongoing watchPosition call in HTML5

Nitya Raut

Nitya Raut

Updated on 28-Jan-2020 08:28:19

162 Views

The clearWatch method cancels an ongoing watchPosition call. When canceled, the watchPosition call stops retrieving updates about the current geographic location of the device.                    var watchID;          var geoLoc;          function showLocation(position) ... Read More

Previous 1 ... 7 8 9 10 11 ... 28 Next
Advertisements