Invert effect is used to map the colors of the object to their opposite values in the color spectrum, i.e., to create a negative image.The following parameter is used in this filter:Sr.NoParameter & Description1InvertMaps the colors of the object to their opposite value in the color spectrum.ExampleYou can try to ... Read More

Let’s say we have a database “business” with number of tables. If you want to show only foreign key constraints, then use the following query −mysql> select *    −> from information_schema.referential_constraints    −> where constraint_schema = 'business';The following is the output displaying only foreign key constraints −+--------------------+-------------------+--------------------------+---------------------------+--------------------------+------------------------+--------------+-------------+-------------+-------------------+-----------------------+ | CONSTRAINT_CATALOG ... Read More

To know whether a MySQL table is using MyISAM or InnoDB engine then you can use below syntax.The below syntax can be used for multiple tables −show table status from yourDatabaseName;Here is the syntax that can be used for a specific table i.e. to know the engine of a table ... Read More

The NOW() function gives current datetime as a timestamp while CURDATE() gives only current date, not time.Now let us work on both the functions with the help of select statement. The query is as follows −The following is a demo of NOW() function −mysql> select NOW();The following is the output ... Read More

To insert the date with date formats, use the str_to_date() function with date in single quotes. The following is the syntax −insert into yourTableName values(Value1, value2, ......ValueN, str_to_date(‘anyDate’, ’%Y-%m-%d’));Here are the Date Formats in MySQL −FormatDescription%aAbbreviated weekday name (Sun to Sat)%bAbbreviated month name (Jan to Dec)%cNumeric month name (0 to ... Read More

To skip first 10 results, use “limit offset”. The syntax is as follows −select *from yourTableName limit 10 offset lastValue;Let us create a table to understand the above syntax. The following is the query to create a table −mysql> create table SkipFirstTenRecords    −> (       −> StudentId ... Read More

Yes, a user can disable HTML5 sessionStorage.It is easy to prevent browsers from accepting localStorage and sessionStorage. Let us see the settings for web browsers −Firefox Type “about config” in the address bar and press. This would show the internal browser settings. Move to dom.storage.enabled“, you need to right-click and ... Read More

Use HTML with jQuery to achieve this and fire after pressing ENTER −Example                          $(document).ready(function(){             $('input').bind("enterKey",function(e){                alert("Enter key pressed");             });             $('input').keyup(function(e){                if(e.keyCode == 13)                {                   $(this).trigger("enterKey");                }             });          });                             Press Enter key in the above input text.    

To preview an image before and after upload, you need to try the following code − HTML         The following is the jQuery −function display(input) {    if (input.files && input.files[0]) {       var reader = new FileReader();       reader.onload = function(event) ... Read More

Use the align-content property to align the flex lines. You can try to run the following code to implement the align-content property:ExampleLive Demo                    .mycontainer {             display: flex;             ... Read More