• Home
FacebookTwitterRSS

Sumit Bansal

Ad Widget
  • Home
  • PHP
    • PHP Functions
    • PHP5 OOPS
  • MySql
  • Scripts
    • Java Scripts
    • PHP Scripts
  • Frameworks
    • Codeigniter Tips
  • Web Development
    • Technical Skills
    • Web Designing Tips
    • Web Development Tips
    • API
  • WordPress
    • WordPress Plugin
    • WordPress Tips
  • Computer Related
Tuesday, 24 April 2018
Ad Widget

Category: MySql

Mysql if condition in update query

Posted on November 9, 2012 by Bansal Sumit | 0 Comments
We can use the IF CONDITION in update query, given blow example will show how we can use the IF Condition in update query. Suppose we have a table that has 2 column first is Name and second is Gender,…
Read more »

Calculate average and sum from Mysql query

Posted on April 30, 2012 by Bansal Sumit | 0 Comments
The AVG function return the average value of the specified column. For example I have a table of product list and now I want the total of price and average price of all the products. id name price 43245 Jeans…
Read more »

What is the difference between MyISAM and InnoDB?

Posted on April 6, 2012 by Bansal Sumit | 0 Comments
The main difference between mysql table type MyISAM and InnoDB is that InnoDB supports transaction by MyISAM does not. MyISAM support full text search but InnoDB does not. InnoDB supports some new features: Transactions, row level locking, foreign keys. If…
Read more »

How to calculate difference in days between two dates in MySQL

Posted on September 19, 2010 by Bansal Sumit | 0 Comments
Let’s say we have a MySQL table where one column (date or datetime type) is named creation-date and contains dates in one of the YYYY-MM-DD or YYYY-MM-DD HH:MM:SS formats from the past and we need to calculate the difference in…
Read more »

Random Posts

  • Add/Remove unwanted links from wordpress admin bar
  • Find latitude and longitude using google map API
  • Rewrite dynamic URL to static URL in PHP using .htaccess
  • Calculating the length of a string using PHP
  • Changing Case (Uppercase to lowercase or inverse) using php

Advertisement

Ad Widget

Get Updates

Subscribe to our newsletter to receive breaking news by email.

  • Popular
  • Latest
  • Comments
  • How to export Email List from cpanel using javascript and firebug

    April 11, 2013
  • How to validate email id in javascript

    April 22, 2013
  • Get current URL in PHP

    February 27, 2012
  • Find latitude and longitude using google map API

    February 12, 2012
  • Fix wordpress plugin profile pic error

    January 20, 2012
  • Five Reputation Management Tips To Increase Web Traffic

    Five Reputation Management Tips To Increase Web Traffic

    March 24, 2018
  • Why Search Engine Rankings of Your Website Are Lower?

    Why Search Engine Rankings of Your Website Are Lower?

    March 7, 2018
  • Benefits of Using WordPress For Website Development

    Benefits of Using WordPress For Website Development

    February 26, 2018
  • Importance of Having a Professional Website Design for Your Business

    Importance of Having a Professional Website Design for Your Business

    February 20, 2018
  • How To Optimize App For Better Ranking In Google Play Store

    How To Optimize App For Better Ranking In Google Play Store

    February 8, 2018
  • baksogoreng.web.id It's actually a great and helpful piece of info. I am satisf
  • car wreckers best informatin or all of us fr getting best iea about this
  • sagar Thank you so much works perfect
  • Glinda wonderful publish, very informative. I ponder why the opposi
  • alat bantu seks pria thanks dude.. awesome article

Most Views Posts

  • Adding And Subtracting Dates in PHP

  • Error reporting and debugging in codeigniter

  • How to Replace Newline with Space Using PHP

  • How to check date if date is between two date

  • Rewrite dynamic URL to static URL in PHP using .htaccess

Popular Posts

  • How to export Email List from cpanel using javascript and firebug
  • How to validate email id in javascript
  • Get current URL in PHP
  • Find latitude and longitude using google map API
  • Fix wordpress plugin profile pic error

Random Posts

  • Paging in PHP (Splitting records into pages)
  • Calculating the length of a string using PHP
  • How to make a dynamic tree structure menu
  • What is the difference between MyISAM and InnoDB?
  • Remove unwanted menu/submenu links from wordpress dashboard

Recent Posts

  • Five Reputation Management Tips To Increase Web TrafficFive Reputation Management Tips To Increase Web Traffic
  • Why Search Engine Rankings of Your Website Are Lower?Why Search Engine Rankings of Your Website Are Lower?
  • Benefits of Using WordPress For Website DevelopmentBenefits of Using WordPress For Website Development
  • Importance of Having a Professional Website Design for Your BusinessImportance of Having a Professional Website Design for Your Business
  • How To Optimize App For Better Ranking In Google Play StoreHow To Optimize App For Better Ranking In Google Play Store
© Copyright 2017 Sumit Bansal.