Search using  match against Match Against search
Basics of Database & SQL
What is SQL and database management

Php functions to manage MySQL database

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
CASECondition check with select query
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
REGEXPRegular expression to match pattern in string 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
String Functionsto use get length, lower case, repeat, reverse etc

Joining More than one table

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
Inner Join Joining tables with itself and displaying records

Collecting records from table

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

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
Visitors Rating
Your Rating


Post Comment This is for short comments only. Use the forum for more discussions.

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us
©2000-2016 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer