SQL PHP HTML ASP JavaScript articles and free scripts to download
 
Introduction to SQL
What is SQL and database management

Standard SQL functions ( commands )

Functions Description
AVGAverage value of a column and other math functions
AlterChanging the table Structure
BetweenRecords between two ranges
CountNumber of records in a table with different combinations
Copy TableCopy data from one table to another table
Create TableCreate table by using SQL
DeleteDelete records from table
DropDeleting table or table column
DistinctUnique records of a table
Group byGrouping data of a column of MySQL table
HavingMatching data by Having command with group by
InsertAdding records to a table
Insert SetAdding record with matching column and value
Inner Join Joining table to itself
INMatching record with set of data
Left joinJoining two tables and getting matching records with unique combination
LimitGetting limited records with starting and ending limit
LikeMatching record with wildcard and formatting
LocateMatching record and getting position of the search string
MAXHighest number of a column ( math functions: min, sum, average etc )
NULL valueMissing or unknown data
Order By displaying A to Z or Maximum to Minimum data
OR ANDLogical operators to use in a query
RandRandom records from a table
ReplaceUpdating part of data
Rename Table Rename table by query
Select QuerySelect record from a table
SubqueriesQuery inside a querry
UnionJoining tables and getting records
UpdateUpdate record with new data
WhereGetting records with conditions

MySQL Functions

Functions Description
Date & Time Managing Date & time field of MySQL table by formatting outputs and applying calculations on year, month, day etc.
Math FunctionsCounting total, average, Sum of a range of records by using Math Functions

Joining More than one table

FunctionsDescription
left join Managing Date & time field of MySQL table by formatting outputs and applying calculations on year, month, day etc.
Linking TableDisplaying records connecting more than one table
UnionJoin two tables and display unique records
Innter Join Joining tables with itself and displaying records

Collecting records from table

FunctionsDescription
Record existsRecord is already available in a table ( checking userid )
second highestGetting the second highest number in a table column
sub groups Grouping within a group by sub-groups
Changing order Displaying highest or lowest or changing the display order
Sum storing Inserting sum of a column in other table
Length of Data Length of characters present in a field

More on SQL and Database Management

FunctionsDescription
Keyword SearchGenerate SQL from the input search string and apply
Dynamic SearchGenerate Query based on various input combinations
SQL Securitydatabase vulnerability and injection attacks
Excel to MySQLShifting records from Excel to MySQL




Join Our Email List
Email:  
For Email Newsletters you can trust
HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2013 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer