The Input Color form property returns the reference of enclosing form for input color.SyntaxFollowing is the syntax −Returning reference to the form objectinputColorObject.formExampleLet us see an example of Input Color form property − Live Demo Input Color Form Color Picker:  Get Form ID   ... Read More

The HTML DOM Input Color Object represents an input HTML element with type color.SyntaxFollowing is the syntax −Creating an with type color −var colorObject = document.createElement(“input”); colorObject.type = “color”;AttributesHere, “colorObject” can have the following attributes −AttributesDescriptionautocompleteIt defines the value of autocomplete attribute of a color pickerautofocusIt defines if the ... Read More

The HTML DOM Input Color value property returns a string, which represents the value of the input color value attribute. User can also set it to a new string.SyntaxFollowing is the syntax −Returning string valueinputColorObject.valueSetting value attribute to a string valueinputColorObject.value = ‘String’ExampleLet us see an example of Input Color value ... Read More

The HTML DOM Input Date disabled property sets/returns whether Input Date is enabled or disabled.SyntaxFollowing is the syntax −Returning boolean value - true/falseinputDateObject.disabledSetting disabled to booleanValueinputDateObject.disabled = booleanValueBoolean ValueHere, “booleanValue” can be the following −booleanValueDetailstrueIt defines that the input date is disabled.falseIt defines that the input date is not disabled and ... Read More

The HTML DOM Input Date name property returns a string, which is the name attribute of input date. User can also set it to a new string.SyntaxFollowing is the syntax −Returning string valueinputDateObject.nameSetting name attribute to a string valueinputDateObject.name = ‘String’ExampleLet us see an example of Input Date name property − Live ... Read More

For this, you can use the DEFAULT CURRENT_TIMESTAMP clause in MySQL. Following is the syntax −CREATE TABLE yourTableName (    yourColumnName1 dataType1,    yourColumnName timestamp DEFAULT CURRENT_TIMESTAMP );Let us first create a table −mysql> create table DemoTable    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,   ... Read More

To find the greatest value among four tables, you can use the method GREATEST(). Following is the query to create first table −mysql> create table DemoTable1    -> (    -> Value int    -> ); Query OK, 0 rows affected (0.70 sec)Insert some records in the first table using ... Read More

To remove seconds from MySQL datetime, use UPDATE and SET as in the following syntax −update yourTableName set yourDateColumnName=yourDateColumnName -second(yourDateColumnName);Let us first create a table −mysql> create table DemoTable    -> (    -> Shippingdatetime datetime    -> ); Query OK, 0 rows affected (0.76 sec)Insert some records in the ... Read More

Let us first create a table −mysql> create table DemoTable    -> (    -> status int    -> ); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(30); Query OK, 1 row affected (0.17 sec) mysql> insert ... Read More

For string matching, use LIKE operator. Let us first create a table −mysql> create table DemoTable    -> (    -> MonthName varchar(100)    -> ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('JFMA'); Query OK, 1 row ... Read More