AmitDiwan has Published 11365 Articles

HTML

AmitDiwan

AmitDiwan

Updated on 16-Sep-2019 11:33:11

325 Views

The disabled attribute of the element is used to set a disabled option from a list of options. After that, the disabled option won’t be clickable.SyntaxFollowing is the syntax −ExampleLet us now see an example to implement the disabled attribute of the element − Live Demo Impurity ... Read More

HTML min Attribute

AmitDiwan

AmitDiwan

Updated on 16-Sep-2019 11:28:21

90 Views

The min attribute of the element is used to set the lower bound for . However, the element is used to measure data with a give range like water impurity level and it is set using the min and max attribute.SyntaxFor obvious reasons, the min value is less ... Read More

HTML

AmitDiwan

AmitDiwan

Updated on 16-Sep-2019 11:16:41

142 Views

The for attribute of the element is used to set an element with a label.SyntaxFollowing is the syntax −Above, id is the associated element id.ExampleLet us now see an example to implement the for attribute of element − Live Demo Last Semester Results Result Student: ... Read More

HTML disabled Attribute

AmitDiwan

AmitDiwan

Updated on 16-Sep-2019 11:07:23

179 Views

The disabled attribute of the element is used to disable element. When an element is disabled, it becomes unclickable. For obvious reasons, the disabled input element won’t get submitted.SyntaxFollowing is the syntax −Let us now see an example to implement the disabled attribute of the element −Example Live ... Read More

HTML Block and Inline Elements

AmitDiwan

AmitDiwan

Updated on 16-Sep-2019 09:19:06

380 Views

Block ElementsThe block elements appear on a screen as if they have a line break before and after them. They also take up the entire available width. Some of the block elements include, to , , , , , , , , etc.ExampleLet us see an example of one ... Read More

Can 'false' match some string in MySQL?

AmitDiwan

AmitDiwan

Updated on 09-Sep-2019 09:11:53

41 Views

Yes, you can use false as 0 to match.Let us first create a table −mysql> create table DemoTable804 ( Id varchar(100) ); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into DemoTable804 values('101John'); Query OK, 1 row affected ... Read More

Set DEFAULT values for columns while creating a table in MySQL

AmitDiwan

AmitDiwan

Updated on 09-Sep-2019 09:10:32

2K+ Views

To set default values for columns while creating a table, DEFAULT. Let us first see an example and create a table. As you can see below, while creating the table, we have set DEFAULT −mysql> create table DemoTable803 ( UserId int DEFAULT 101, UserName ... Read More

Display and concatenate records ignoring NULL values in MySQL

AmitDiwan

AmitDiwan

Updated on 09-Sep-2019 09:08:45

563 Views

Use CONCAT() to concatenate records whereas IFNULL() to check for NULL values.Let us first create a table −mysql> create table DemoTable802 ( FirstName varchar(100), LastName varchar(100) ); Query OK, 0 rows affected (1.01 sec)Insert some records in the table using insert command −mysql> insert ... Read More

MySQL query to perform sort order on same field

AmitDiwan

AmitDiwan

Updated on 09-Sep-2019 09:06:18

96 Views

For this, use ORDER BY IF().Let us first create a table −mysql> create table DemoTable801 ( Score int ); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable801 values(30); Query OK, 1 row affected (0.19 sec) mysql> insert into ... Read More

MySQL select only a single value from 5 similar values?

AmitDiwan

AmitDiwan

Updated on 09-Sep-2019 09:04:29

144 Views

Let us first create a table −mysql> create table DemoTable800 ( Value int ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command. Here, we have inserted 5 similar values −mysql> insert into DemoTable800 values(10); Query OK, 1 row affected (0.18 ... Read More

Advertisements