Truncate the Table SQL>truncate table <table name> Example: SQL>truncate table smarttips;
Author: smarttips
How to ALTER table in SQL
ALTER a table in SQL Use the following commands for add,change,drop table fields in SQL. SQL>AlTER TABLE <Table name> <ADD,DROP,CHANGE> <field name> ALTER TABLE `test` ADD `test INT NOT NULL ALTER TABLE `test` DROP `name` ALTER TABLE `test` CHANGE `name` `student_name` INT( 11 ) NOT NULL
How to create a table in SQL
Command or syntax for crating a table in SQL SQL> CREATE TABLE <tablename name>(fieldname datatype(size) PRIMARY KEY); Example:CREATE TABLE STUDENT(stu_number number(2) PRIMARY KEY,stu_name varchar(20));
what is mean by Bounce rate?
Bounce rate It is a common term used in website traffic analysis. Bounce rate is the ratio between number of people enter your site and leave the site(bounce) without viewing other pages. Low bounce rate means the site is very useful. Bounce rate is mainly depends on the quality of content.
jquery smooth scrolling of internal anchor links
jquery smooth scrolling of internal anchor links <script> jQuery(document).ready(function(){ jQuery(‘a[href^=”#”]’).on(‘click’,function (s) { s.preventDefault(); var smarttarget = this.hash, $smarttarget = jQuery(smarttarget); jQuery(‘html, body’).stop().animate({ ‘scrollTop’: $target.offset().top }, 900, ‘swing’, function () { window.location.hash = smarttarget; }); }); }); </script> <ul> <li><h1>Contents</h1></li> <li> 1. <a class=”msection” style=”color:#1155CC” href=”#section_1″>Tes1</a></li> <li> 2. <a class=”msection” style=”color:#1155CC” href=”#section_2″>Test 2</a></li> </ul> <a id=”section_1″…