AmitDiwan has Published 10740 Articles

How to fetch all databases with name having upper case character after some word using MySQL?

AmitDiwan

AmitDiwan

Updated on 31-Dec-2019 06:29:10

111 Views

For this, use regular expression. The syntax is as follows −select * from information_schema.schemata WHERE SCHEMA_NAME REGEXP '^yourValue_+[A-Z]';Let us create some databases −mysql> create database bank_APP1; Query OK, 1 row affected (0.00 sec) mysql> create database bank_APP2; Query OK, 1 row affected (0.00 sec) mysql> create database bank_APP3; Query OK, ... Read More

jQuery dequeue() with Examples

AmitDiwan

AmitDiwan

Updated on 31-Dec-2019 06:28:09

260 Views

The dequeue() method in jQuery is used to remove the next function from the queue and then execute the function.SyntaxThe syntax is as follows −$(selector).dequeue(queue)Above, the queue is the name of the queue.ExampleLet us now see an example to implement the jQuery dequeue() method − Live Demo   ... Read More

Count number of occurrences of records in a MySQL table and display the result in a new column?

AmitDiwan

AmitDiwan

Updated on 31-Dec-2019 06:26:13

3K+ Views

For this, use COUNT(*) along with GROUP BY clause. Let us first create a table −mysql> create table DemoTable1942    (    Value int    ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1942 values(1); Query OK, 1 row ... Read More

jQuery remove() with Examples

AmitDiwan

AmitDiwan

Updated on 31-Dec-2019 06:25:21

172 Views

The remove() method in jQuery is used to remove the selected elements.SyntaxThe syntax is as follows −$(selector).remove(selector)Above, the parameter selector is used to specify one or more elements to be removed.ExampleLet us now see an example to implement the jQuery remove() method − Live Demo    $(document).ready(function(){   ... Read More

jQuery clearQueue() with Examples

AmitDiwan

AmitDiwan

Updated on 31-Dec-2019 06:21:53

174 Views

The clearQueue() method in jQuery is used to remove all items from the queue.SyntaxThe syntax is as follows −$(selector).clearQueue(queue)Above, the queue is the name of the queue.ExampleLet us now see an example to implement the jQuery clearQueue() method − Live Demo    $(document).ready(function(){       $(".button1").click(function(){   ... Read More

Setting up Background Color using CSS

AmitDiwan

AmitDiwan

Updated on 30-Dec-2019 12:49:36

248 Views

To set background color using CSS, use the background-color property.ExampleLet us now see an example − Live Demo .demo {    text-decoration: overline underline;    background-color: red; } Details Examination Center near ABC College. Exam begins at 9AM. OutputExampleLet us now see another example ... Read More

Relative Positioning in CSS

AmitDiwan

AmitDiwan

Updated on 30-Dec-2019 12:44:26

273 Views

With relative positioning, the element is positioned relative to its normal position. For this, use position: relativeExampleLet us now see an example − Live Demo div.demo {    position: relative;    color: white;    background-color: orange;    border: 2px dashed blue;    left: 50px; } ... Read More

Static Positioning in CSS

AmitDiwan

AmitDiwan

Updated on 30-Dec-2019 12:19:26

165 Views

With static positioning, the elements are not affected by the top, bottom, left, and right properties. For this, use position: static.ExampleLet us now see an example − Live Demo div.static {    position: static;    color: white;    background-color: orange;    border: 2px dashed blue; } ... Read More

Setting Line Height using CSS

AmitDiwan

AmitDiwan

Updated on 30-Dec-2019 12:10:35

96 Views

To set line height, use the line-height property. Followng are the property values −line-height: normal|number|length|initial|inherit;ExampleLet us now see an example − Live Demo div {    line-height: 1.9; } Demo Heading This is demo text. This is another demo text. OutputExampleLet ... Read More

Styling Lists with CSS

AmitDiwan

AmitDiwan

Updated on 30-Dec-2019 11:04:11

243 Views

Lists are ordered as well unordered. With CSS, you can set the set list item markers or an image for the markers. With that, with CSS, we can also set the position for list-item markers.Let us now see some examples −list-style-typeThe list-style-type is used to set the type of list-item ... Read More

Advertisements