Nagesh Blog

Thursday, August 19, 2010

All MySQL Important Query's at one place

SQL List of Articles

 Introduction
SQL Introduction
Access to MySQL
Insert Query
MySQL insert with set option
Update Query
Replace command in SQL query
SQL
Delete Query
 Manageing the records
Checking if Record exists
How to get second highest record
Where Query
SQL IN
SQL OR AND
SQL Limit
Random Record
Select Query
Sql Group by
Sql Group with sub groups
MySQL Having
Avoid duplicate records using Distinct SQL
SQL Between
SQL Like
SQL Order By
user to change the record display order ?
Inserting sum of a column in other table
Updating other table
concat:Adding string to data
Length of characters present in a field
 MySQL Functions
MySQL Affected rows
MySQL insert ID
MySQL error number
MySQL error message
MySQL error posting
MySQL number of rows
MySQL Auto increment number
Starting Auto increment number with a value
MySQL Version
MySQL functions


Full Articles -
http://www.plus2net.com/sql_tutorial/replace.php
Posted by NageshBlog at 5:59 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Total Pageviews

Translate

About Me

NageshBlog
View my complete profile

Blog Archive

  • ►  2019 (1)
    • ►  February (1)
  • ►  2018 (1)
    • ►  December (1)
  • ►  2017 (1)
    • ►  April (1)
  • ►  2016 (1)
    • ►  October (1)
  • ►  2015 (5)
    • ►  March (3)
    • ►  February (2)
  • ►  2014 (7)
    • ►  September (1)
    • ►  August (2)
    • ►  July (2)
    • ►  March (1)
    • ►  February (1)
  • ►  2013 (3)
    • ►  October (1)
    • ►  May (1)
    • ►  January (1)
  • ►  2012 (13)
    • ►  October (1)
    • ►  September (3)
    • ►  July (2)
    • ►  June (1)
    • ►  May (1)
    • ►  April (2)
    • ►  March (2)
    • ►  January (1)
  • ►  2011 (16)
    • ►  December (1)
    • ►  November (1)
    • ►  September (1)
    • ►  August (2)
    • ►  June (2)
    • ►  May (2)
    • ►  April (2)
    • ►  March (3)
    • ►  January (2)
  • ▼  2010 (39)
    • ►  December (5)
    • ►  November (1)
    • ►  October (1)
    • ►  September (6)
    • ▼  August (4)
      • All MySQL Important Query's at one place
      • Facebook’s Stream.Publish method on browsers with ...
      • Query Grid 3.1
      • Latest in “jQuery”
    • ►  July (13)
    • ►  June (3)
    • ►  March (6)

Followers

killerstartups.Widget

Picture Window theme. Powered by Blogger.