Rama Giri has Published 110 Articles

Fetch records containing a specific character twice in MySQL

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

194 Views

Let us first create a table −mysql> create table DemoTable    -> (    -> Words text    -> ); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Ever'); Query OK, 1 row affected (0.18 sec) mysql> insert ... Read More

How do I search and replace specific chars at the beginning of a string in MySQL?

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

188 Views

For this, you can use INSERT(). Let us first create a table −mysql> create table DemoTable    -> (    -> ZipCode varchar(200)    -> ); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('9030'); Query OK, 1 row ... Read More

How to combine two tables and add a new column with records in MySQL?

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

439 Views

Let us first create a table −mysql> create table DemoTable1    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> Name varchar(100)    -> ); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1(Name) values('Chris'); Query ... Read More

AUTO_INCREMENT in MySQL can be signed by default?

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

217 Views

Yes, the AUTO_INCREMENT in MySQL will be signed (Positive and Negative Value both) by default.Let us first create a table −mysql> create table DemoTable    -> (    -> MyNumber int AUTO_INCREMENT PRIMARY KEY    -> ); Query OK, 0 rows affected (0.45 sec)Insert some records in the table using ... Read More

Count rows having three or more rows with a certain value in a MySQL table

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

85 Views

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

HTML DOM Input Checkbox disabled Property

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

740 Views

The HTML DOM Input Checkbox disabled property sets/returns whether Input Checkbox is to be enabled or disabled.SyntaxFollowing is the syntax −Returning boolean value − true/falseinputCheckboxObject.disabledSetting disabled to booleanValueinputCheckboxObject.disabled = booleanValueBoolean ValuesHere, “booleanValue” can be the following −booleanValueDetailstrueIt defines that the checkbox is disabled.falseIt defines that the checkbox is not disabled ... Read More

HTML DOM Input Checkbox name Property

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

112 Views

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

HTML DOM Input Checkbox required Property

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

293 Views

The Input Checkbox required property determines whether Input Checkbox is compulsory to check or not.SyntaxFollowing is the syntax −Returning boolean value - true/falseinputCheckboxObject.requiredSetting required to booleanValueinputCheckboxObject.required = booleanValueBoolean ValuesHere, “booleanValue” can be the following −booleanValueDetailstrueIt defines that it is compulsory to check the checkbox to submit form.falseIt is the default ... Read More

HTML DOM Input Checkbox value Property

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

394 Views

The Input Checkbox value property returns a string with the value attribute of input checkbox. User can also set it to a new string.SyntaxFollowing is the syntax −Returning string valueinputCheckboxObject.valueSetting value attribute to a string valueinputCheckboxObject.value = ‘String’ExampleLet us see an example of Input Checkbox value property − Live Demo ... Read More

HTML DOM Input Color defaultValue Property

Rama Giri

Rama Giri

Updated on 30-Jul-2019 22:30:26

70 Views

The HTML DOM Input Color defaultValue property sets/returns the default value corresponding to a color. It may or may not be same as value attribute.SyntaxFollowing is the syntax −Returning string valueinputColorObject.defaultValueSetting defaultValue to stringinputColorObject.defaultValue = ‘string’Boolean ValueHere, “string” can be the following −booleanValueDetails#000000 - #ffffffIt defines that input color can have ... Read More

Previous 1 ... 4 5 6 7 8 ... 11 Next
Advertisements