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

Use the align-items property with value flex-end to align flex items on the bottom.You can try to run the following code to implement the flex-end value:ExampleLive Demo                    .mycontainer {             display: flex;       ... Read More

To set the triangle at the center and at the bottom of div, use the following. You need to set left to 50% −.demo: after {    position: absolute;    border-top: solid 50px #e15915;    border-left: solid 50px transparent;    border-right: solid 50px transparent;    top: 100%;    left: 50%;    margin-left: -50px;    width: 0;    height: 0; }