Sharon Christine has Published 337 Articles

HTML DOM Input Number max Property

Sharon Christine

Sharon Christine

Updated on 01-Jul-2020 09:07:47

207 Views

The HTML DOM input number max property returns and modify the value of the max attribute of the input field of type=”number” in an HTML document.SyntaxFollowing is the syntax −Returning maxobject.max2. Modifying maxobject.max = “number”ExampleLet us see an example of input number max property − Live Demo   ... Read More

HTML DOM Input Number min Property

Sharon Christine

Sharon Christine

Updated on 01-Jul-2020 09:06:23

159 Views

The DOM input number min property returns and modify the value of the min attribute of the input field of type=”number” in an HTML document.SyntaxFollowing is the syntax −Returning minobject.min2. Modifying minobject.min = “number”ExampleLet us see an example of HTML DOM input number min property − Live Demo ... Read More

HTML DOM Input Number autofocus Property

Sharon Christine

Sharon Christine

Updated on 01-Jul-2020 08:55:59

162 Views

The HTML DOM input number autofocus property returns and modify whether the input number field should get focused or not when page load.SyntaxFollowing is the syntax −Returning autofocusobject.autofocus2. Modifying autofocusobject.autofocus = true | falseExampleLet us see an example of HTML DOM input number autofocus property − Live Demo HTML ... Read More

HTML DOM Input Number disabled Property

Sharon Christine

Sharon Christine

Updated on 01-Jul-2020 08:10:33

226 Views

The HTML DOM input number disabled property returns and modify whether the input field of type=”number” in an HTML document is disabled or not.SyntaxFollowing is the syntax −Returning disabledobject.disabledModifying disabledobject.disabled = true | falseExampleLet us see an example of HTML DOM input number disabled property − Live Demo ... Read More

HTML DOM Input Number name Property

Sharon Christine

Sharon Christine

Updated on 01-Jul-2020 08:06:10

177 Views

The HTML DOM input number name property returns and modify the value of the name attribute of the input field of type=”number” in a HTML document.SyntaxFollowing is the syntax −1. Returning nameobject.name2. Modifying nameobject.name = “text”ExampleLet us see an example of HTML DOM input number name property − Live Demo ... Read More

HTML DOM Input Number readOnly Property

Sharon Christine

Sharon Christine

Updated on 01-Jul-2020 07:58:12

195 Views

The HTML DOM input number readOnly property returns and modify whether the input number field is read-only or not in an HTML document.SyntaxFollowing is the syntax −Returning readOnlyobject.readOnlyModifying readOnlyobject.readOnly = true | falseExampleLet us see an example of input number readOnly property − Live Demo    html{   ... Read More

Swap data between two columns in MySQL?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 15:06:56

1K+ Views

To swap data between two columns in MySQL, use the concept of variable. Let us first create a table. Here, we will swap Name1 with Name2 −mysql> create table DemoTable -> ( -> Name1 varchar(100), -> Name2 varchar(100) -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in ... Read More

MySQL stored procedure to return a column value?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 15:05:27

1K+ Views

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

Add values of two columns considering NULL values as zero in MySQL

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 15:00:17

961 Views

For this, use COALESCE() function from MySQL. Let us first create a table −mysql> create table DemoTable -> ( -> Value1 int, -> Value2 int -> ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 200); Query OK, ... Read More

How can I get the number of times a specific word appears in a column with MySQL?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 14:59:08

1K+ Views

For this, you can use COUNT() function. Let us first create a table −mysql> create table DemoTable    -> (    -> EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> EmployeeName varchar(100)    -> ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert ... Read More

Advertisements