What are MySQL aliases and how to use them?
May 21st, 2016
The aliases in MySQL may be used to improve readability of the queries. There are two kinds of aliases supported by MySQL, and these are:
column alias
tabl...
Tutorials
-
CSS Tutorial
-
CSS Basics
-
CSS Selectors
-
CSS Assigning Property Values, Cascading, and Inheritance
-
CSS Media Types
-
CSS Box Model
-
CSS Visual Formatting Model
-
CSS Visual Effects
-
CSS Background Styling
-
CSS Font Styling
-
CSS Text Styling
-
CSS Tables
-
CSS Generated Content
-
CSS Lists and Automatic Numbering
-
CSS User Interface
-
CSS Aural Style Sheets
-
CSS Advanced
-
CSS Examples
-
CSS References
-
-
CSS3 Tutorial
-
CSS3 Basics
-
CSS3 Boxes and Borders
-
CSS3 Backgrounds
-
CSS3 Flexible Boxes
-
CSS3 Colors
-
CSS3 Gradients
-
CSS3 Font Styling
-
CSS3 Text Effects
-
CSS3 Writing Modes
-
CSS3 Multiple Columns
-
CSS3 Transitions
-
CSS3 Transformations
-
CSS3 Animations
-
CSS3 Filter Effects
-
CSS3 Image Values and Replaced Content
-
CSS3 User Interface
-
CSS3 Fragmentation
-
CSS3 Advanced
-
CSS3 Examples
-
CSS3 References
-
-
JavaScript Tutorial
-
JS Basics
-
JS Data Types
-
JS Operators
-
JS Conditional Statements
-
JS Arrays
-
JS Functions
-
JS Regular Expressions
-
JS Date and Time
-
JS Primitive wrappers
-
JS Objects
-
JS Built-in Objects, Global & Math
-
JS Scope and Memory
-
JS Anonymous Functions
-
JS Browser Object Model (BOM)
-
JS Document Object Model (DOM)
-
JS Document Object Model Extensions
-
JS Document Object Model 2 & 3
-
JS Events
-
JS Form Scripting
-
JS Error Handling
-
JS XML Scripting
-
JS Working with Clients
-
JS Advanced
-
JS Examples
-
JS References
-
-
PHP Tutorial
-
PHP Basics
-
PHP Data Types
-
PHP Operators
-
PHP Conditional Statements
-
PHP Control Structures
-
PHP Strings
-
PHP Arrays
-
PHP Functions
-
PHP Classes and Objects
-
PHP Regular Expressions
-
PHP Date and Time
-
PHP Forms
-
PHP Mail Handling
-
PHP File Handling
-
PHP Image Handling
-
PHP Audio Formats
-
PHP Databases
-
PHP XML Manipulation
-
PHP Web Services
-
PHP Mathematical Extensions
-
PHP Credit Card Extensions
-
PHP Advanced
-
PHP Examples
-
PHP References
-
-
MySQL Tutorial
-
MySQL Basics
-
MySQL Data Types
-
MySQL Table and Data Manipulation
-
MySQL Index, Keys and Constraints
-
MySQL Data Queries
-
MySQL Querying Operators
-
MySQL Combining Queries
-
MySQL Character Sets and Collation
-
MySQL Stored Procedures
-
MySQL Triggers
-
MySQL Views
-
MySQL Functions and Operators
-
MySQL Administrational Functions
-
MySQL Advanced
-
MySQL References
-
-
XML Tutorial
-
XML Basics
-
XML Structure
-
XML Document Type Definition
-
XML Entities
-
XML Characters
-
XML Namespaces
-
XML Path (XPath)
-
XML XSLT - XML on Web
-
XML XSLT - Affecting XML Structure
-
XML Styling with CSS
-
XML XLink - XML Linking
-
XML Document Object Model (DOM)
-
XML Document Object Model 2
-
XML Advanced
-
XML Examples
-
XML References
-
Latest Tutorials
Eliminate duplicate rows with DISTINCT operator
May 24th, 2016
Very often we might retrieve duplicate values from our records. In order to "see" only distinct records we can use the DISTINCT operator. The basic syntax for DISTINCT op...
How to test range of specified data by using then BETWEEN operator?
May 24th, 2016
The BETWEEN operator is used to specify a range of data you want to test your result set against. The BETWEEN operator is frequently used with the
Usage of LIKE operator for searching database and similar queries
May 24th, 2016
How to search through database?
A simple way of creating searching queries is by using the LIKE operators. In broader terminology, the LIKE operators are used to...
Filtering data with IN operators
May 24th, 2016
The IN operator is used to determine if a specified value matches any values returned by the query. The IN operator may be used with all main statements such as
How to use ANY (SOME) and ALL operators to filter queries?
May 24th, 2016
The ANY and ALL operators allow you to perform a comparison between a single column value and a range of other values. In particular, the ANY operator will return a result if the o...
Sub-queries written with EXISTS or NOT EXISTS operators
May 24th, 2016
Data sub-queries using EXISTS or
Testing retrieved values with IS NULL and IS NOT NULL
May 24th, 2016
The IS NULL and IS NOT NULL operators are very useful in verifying if the returned value is a NULL type, or a valid one. Sometimes these NULL values will result in errors if not filtered properly a...
What are JOINS and how to use them?
May 24th, 2016
The JOIN keyword is used in a MySQL statement to query data from two or more tables...
How to combine result with UNION operator?
May 24th, 2016
In order to combine two or more result sets into one, and thus increase readability and speed up querying, the UNION operator may be used.
Syntax
The basic syntax...
