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

Joining Tables Query

SQL left join SQL Linking Table SQL Union MySQL Inner Join