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

For this, use the aggregate function SUM(). Let us first create a table −mysql> create table DemoTable    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> € int    -> ); Query OK, 0 rows affected (0.71 sec)Insert some records in the table using insert ... Read More

To return the first n letters, use the LEFT() function. Following is the syntax −select left(yourColumnName, yourValue) from yourTableName;Let us first create a table −mysql> create table DemoTable    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> CourseTitle text    -> ); Query OK, 0 ... Read More

For this, you can use CREATE TABLE AS SELECT statement. Let us first create a table −mysql> create table DemoTable1    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> CountryName varchar(20)    -> ); Query OK, 0 rows affected (0.68 sec)Insert some records in the ... Read More