SQL PHP HTML ASP JavaScript articles and free scripts to download
 
 

SQL List of Articles

 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

Discuss this tutorial at forum

List of SQL Tutorials


Scripts
PHP
JavaScript
SQL Tutorial List
SQL (Home)
mysql_affected_rows mysql_change_user mysql_close mysql_connect mysql_create_db mysql_data_seek mysql_db_name mysql_db_query mysql_drop_db mysql_errno mysql_error mysql_fetch_array mysql_fetch_assoc mysql_fetch_field mysql_fetch_lengths mysql_fetch_row mysql_field_flags mysql_field_len mysql_field_name mysql_field_seek mysql_field_table mysql_field_type mysql_free_result mysql_insert_id mysql_list_dbs mysql_list_fields mysql_list_tables mysql_num_fields mysql_num_rows mysql_pconnect mysql_query mysql_result mysql_select_db mysql_tablename
SQL site Map
Knowledge Management
Subscribe
Submit your email address and receive article and product notifications. Your email is safe with us.