Time 4 Tech

A typical web page has headers, footers, navigation, central area and side bars. Now if we want to represent the same in HTML 4 with proper names to the HTML section we would probably use a DIV tag. But in HTML 5 they have made it more clear by creating element names for those sections which makes your HTML more readable. HTML 5 elements which form the page structure. <header> : Represents header data of HTML. <footer> : Footer section of the page. <nav> : Navigation elements in the page. <article> : Self-contained content. <section> : Used inside article to define sections or group content in to sections. <aside> : Represent side bar contents of a page.

The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction InnoDB supports some newer features: Transactions, row-level locking, foreign keys InnoDB is for high volume, high performance Most people use MyISAM if they need speed and InnoDB for data integrity. You can use more than one or any combination of these table types in your database. Remember to asses the needs of your application before building it. Even though MyISAM is faster than InnoDB in the MySQL world, InnoDB is fast compared to any database  engine.With  InnoDB you get transactions, speed and integrity three features not usually used in the same sentence. InnoDB  has been designed for maximum performance when processing large data volumes. Its CPU efficiency is probably not matched by any other disk-based relational database engine. Fully integrated with MySQL Server, the  InnoDB  storage engine maintains its own buffer pool for caching data and ...

SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12 When we use ORDER_BY registration_no ASC get... 1 101 102 103 104 105 106 107 108 109 11 110 Etc … Using 'order by len ( registration_no )' we will get 1 11 101 102 10 104 105 106 107 108 119 Etc... This is particularly useful when the column might contain non-numeric values. Note: in some databases, the function to get the length of a string might be called  length()  instead of  len() .