Miscellaneous MySQL functions
May 26th, 2016
Apart from the functions defined in previous chapters, MySQL has a range of other useful functio...
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
How to use regular arithmetic operators in MySQL queries?
May 26th, 2016
As in any other programming, the usual group of arithmetic operations is available in MySQL as well.
The following table shows all possible operations:
About administrational functions in MySQL
May 26th, 2016
In this chapter we are going to have a brief look at the administration functions in the MySQL.
Administration functions of MYSQL usually include:
Starting and stopping MYSQL...
How to create a new user in MySQL
May 26th, 2016
We add new user accounts, adjust privileges, passwords using MYSQL commands.
With CREATE USER and INSERT commands we can specify the username and...
How to update passwords for accounts in MySQL?
May 26th, 2016
Once account is created, the password of the account can be changed. The
Privileges in MySQL
May 26th, 2016
Privileges to access database content in MySQL can be given in different level and context to the user; or in other word in seperate process then setting up a user's account. The list...
Backing up a MYSQL database
May 26th, 2016
Backup of a database is necessary to recover data in case of problems such as system crashes, hardware failures, and user deleting data accidentally, etc... Backup is also essential before upgr...
Writing sub-queries for complex operations
May 26th, 2016
Subquery is a query statement written within an other query such as SELECT...
Natural sorting with ORDER BY clause
May 26th, 2016
The data in MySQL table can be selected and sorted using SELECT and
