Jennifer Nicholas has Published 332 Articles

Generating a range of numbers in MySQL?

Jennifer Nicholas

Jennifer Nicholas

Updated on 25-Jun-2020 11:21:38

2K+ Views

To generate a range of numbers in MySQL, you can use stored procedure. Firstly, we need to create a table. After that, we will create a stored procedure that generates a range of number from 10 to 1.The following is the query to create a table −mysql> create table GeneratingNumbersDemo ... Read More

How to fetch fields with multiple values set using MySQL LIKE?

Jennifer Nicholas

Jennifer Nicholas

Updated on 25-Jun-2020 11:18:08

560 Views

To fetch fields with multiple values, use LIKE with OR in MySQL −select *from yourTableName where yourColumnName like ‘%AnyStringValue’ or yourColumnName like ‘%AnyStringValue’ or yourColumnName like ‘%AnyStringValue’ ……...N;You can understand with the help of a table −mysql> create table LikeDemo    −> (       −> Hobby varchar(200)   ... Read More

Calculate average of numbers in a column MySQL query?

Jennifer Nicholas

Jennifer Nicholas

Updated on 25-Jun-2020 10:45:08

778 Views

Calculate the average of numbers in a column with the help of MySQL aggregate function AVG().The syntax is as follows −select avg(yourColumnName) as anyVariableName from yourTableName;To understand the above concept, let us create a table. The following is the query to create a table.mysql> create table AverageCalculateDemo    −> ( ... Read More

Increase or decrease units in HTML5 Canvas grid

Jennifer Nicholas

Jennifer Nicholas

Updated on 25-Jun-2020 07:25:36

162 Views

HTML5 canvas provides scale(x, y) method that is used to increase or decrease the units in our canvas grid. This can be used to draw scaled down or enlarged shapes and bitmaps.This method takes two parameters where x is the scale factor in the horizontal direction and y is the ... Read More

Adjust gap size for CSS Grid

Jennifer Nicholas

Jennifer Nicholas

Updated on 25-Jun-2020 07:10:46

3K+ Views

To adjust the gap size, use grid-column-gap, grid-row-gap or grid-gap property in CSS.grid-column-gap propertySet gap between Grid columns with CSS. You can try to run the following code to implement the grid-column-gap property.ExampleLive Demo                    .container {       ... Read More

How not to validate HTML5 input with required attribute

Jennifer Nicholas

Jennifer Nicholas

Updated on 25-Jun-2020 06:47:22

106 Views

To avoid validation, use the formnovalidate attribute in HTML5. In the example, validation is disabled for the 2nd button −Example           HTML formnovalidate attribute                        Rank                              

What exactly is the pushState state object in HTML?

Jennifer Nicholas

Jennifer Nicholas

Updated on 25-Jun-2020 05:57:12

107 Views

Use the pushSate object to update the page when the user navigates back through history. Let us see an example to include the selected color that creates a history entry −function display(color) {    var myState = { selectedColor: color },    myTitle = "Page title",    myPath = "/" + ... Read More

Set a rounded active and hover button with CSS

Jennifer Nicholas

Jennifer Nicholas

Updated on 24-Jun-2020 15:41:20

1K+ Views

Use the :hover selector to add hover effect. To give a rounded effect, use the border-radius property. You can try to run the following code to set rounded active and hover button with CSS:ExampleLive Demo                    .demo {     ... Read More

Ember.js browser support with HTML

Jennifer Nicholas

Jennifer Nicholas

Updated on 24-Jun-2020 14:24:36

96 Views

Ember.js is an open-source, free JavaScript client-side framework used for developing web applications.It allows building client-side JavaScript applications by providing a complete solution which contains datamanagement and application flow.It uses the MVC(Model-View-Controller) architecture pattern. In Ember.js, the route is used as a model, handlebar template as view and controller manipulates ... Read More

Add space between pagination links with CSS

Jennifer Nicholas

Jennifer Nicholas

Updated on 24-Jun-2020 11:20:34

277 Views

You can try to run the following code to add space between pagination links with CSS:ExampleLive Demo                    .demo {             display: inline-block;          }          .demo a { ... Read More

Advertisements