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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment