Chandu yadav has Published 1226 Articles

Get only digits using regexp in MySQL?

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 12:45:51

17K+ Views

If you want to get only digits using REGEXP, use the following regular expression( ^[0-9]*$) in where clause.Case 1 − If you want only those rows which have exactly 10 digits and all must be only digit, use the below regular expression.SELECT *FROM yourTableName WHERE yourColumnName REGEXP '^[0-9]{10}$';Case 2 − ... Read More

System variables vs Local Variables in MySQL?

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 12:16:18

315 Views

The local variable has the scope for only a set of statements or block of statement. Whenever a set of statements or block of statement has completed then local variable goes out of scope.For ExampleLocal variable can be used in stored procedure, function etc. It is used with the DECLARE ... Read More

gmp_scan1() function in PHP

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 11:35:18

37 Views

The gmp_scan1() function scans “1” in the GMP number beginning from a particular index that you can set as a parameter.Syntaxgmp_scan1(n, i)Parametersn − The GMP number to be passed.i − The index from where the search begin.ReturnThe gmp_scan1() function returns the index of the “1” bit. It is checked after ... Read More

gmp_perfect_square() function in PHP

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 11:33:09

36 Views

The gmp_perfect_square() function checks if the GMP number is a perfect square or not.Syntaxgmp_perfect_square(val)Parametersval − The GMP number to be checked. It can be GMP object in PHP version 5.6 and later. Can also be numeric strings.ReturnThe gmp_perfect_square() function returns TRUE if val is a perfect square.ExampleThe following is an ... Read More

Role of CSS :not (selector) Selector

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 11:17:36

234 Views

Use the CSS :not(selector) selector to style every element that is not the specified element. You can try to run the following code to implement the :not selectorExampleLive Demo                    p {             color: red;          }          :not(p) {             color: blue;          }                     Heading 1       Heading 2       Heading 3       This is a paragraph.       This is another paragraph.    

Role of CSS :nth-of-type(n) Selector

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 11:15:58

112 Views

Use the CSS :nth-of-type(n) selector to style every element that is the nth element of its parent. You can try to run the following code to implement the :nth-of-type(n) selectorExampleLive Demo                    p:nth-of-type(2) {         ... Read More

Role of CSS:lang Selector

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 11:08:57

54 Views

Use the CSS :lang selector to style every element with a lang attribute value with CSS. You can try to run the following code to implement the :lang selectorExampleLive Demo                    p:lang(fr) {             background: greeb;          }                     This is my country       C'est mon pays       French is the language of France    

Digital Integrated Circuits

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 10:58:25

11K+ Views

A microprocessor is digital is a digital circuit which is built using a combination logic functions. The microprocessor package contains an integrated circuit.Integrated CircuitAn integrated circuit is electronic circuit or device that has electronic components on a small semiconductor chip. It has functionality of logic AND or amplifying of a ... Read More

Role of CSS: first-child Selector

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 09:48:28

107 Views

Use the CSS :first-child selector to style every elements that is the first child of its parent.ExampleYou can try to run the following code to implement the :first-child selectorLive Demo                    p:first-child {             ... Read More

Role of CSS: disabled Selector

Chandu yadav

Chandu yadav

Updated on 30-Jun-2020 09:42:34

156 Views

Use the CSS :disabled selector to style every disabled element. You can try to run the following code to implement the :disabled selectorExampleLive Demo                    input:enabled {             background: blue;          }          input:disabled {             background: red;          }                              Subject          Student:          Age:          

Previous 1 ... 3 4 5 6 7 ... 123 Next
Advertisements