SQL

Search using  match against
Match Against search






Primary Key Constraint

Primary Key is unique and not null constraint of the column to identify the row and we can use one Primary Key for one table.

Primary Key constraint
Installation
Installing and Managing MySQL database

PHP MySQL
Php functions to manage MySQL database

SQL Introduction
Types of Query and about SQL

Standard SQL functions ( commands )

Functions Description
AVGAverage value of a column and other math functions
AlterChanging the table Structure
BetweenRecords between two ranges
CASECondition check with select query
CountNumber of records in a table with different combinations
Copy TableCopy data from one table to another table
CONCATJoining and adding strings to columns
Create TableCreate table by using SQL
DatabaseCreate , display and delete Database
DeleteDelete records from table
DropDeleting table or table column
DistinctUnique records of a table
Group byGrouping data of a column of MySQL table
Group_concatGrouping string data to single column
HavingMatching data by Having command with group by
InsertAdding records to a table
ISIs operator to check against Boolean values
IFChecking Condition with Group By
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
Over() Grouping window function using over() and partition
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
Show TablesListing of Database and Tables
SubqueriesQuery inside a query
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

FunctionsDescription
left join Managing Date & time field of MySQL table by formatting outputs and applying calculations on year, month, day etc.
left join II Left join using Multiple tables
left join III Example of Left Join using multiple tables
RIGHT JOINRIGHT Outer join of tables using ON columns
Linking TableDisplaying records connecting more than one table
UnionJoin two tables and display unique records
Inner Join Joining tables with itself and displaying records
CROSS Join Joining all rows of both tables

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
CSV Data Download table rows as CSV file data

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

Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com

    17-06-2020

    SELECT STUDENTID,CASE WHEN MARKS < 50 THEN 'FAIL' ELSE TO_CHAR(Marks) END AS STATUS FROM ASSESSMENT




    SQL Video Tutorials










    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer