Introduction

SQL SQL Introduction Access to MySQL Insert Query MySQL insert with set option Update Query Replace command in SQL query 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

Date and time field in Table Query

Records of Last week Getting Records of week days MySQL date format Inserting current date & time to date field Automatically Updating date & time field Selecting records between two date ranges Formatting MySQL date value MySQL Date difference Year in Date Month in Date Day in Date

Counting total, average, Sum of a range of records

SQL Sum SQL AVG SQL MAX SQL MIN Count Query Data Format

Table structure and Copy table

Create Table Query SQL Copy Table SQL Rename Table SQL Alter Table MySQL exporting data

Searching records in MySQL table

Keyword Search Query generation Dynamic Search Query generation