Skip to main content
Here is the list of all important MySQL functions. Each function has been explained along with suitable example.
  • MySQL Group By Clause - The MySQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certain database table column(s).
  • MySQL IN Clause - This is a clause, which can be used along with any MySQL query to specify a condition.
  • MySQL BETWEEN Clause - This is a clause, which can be used along with any MySQL query to specify a condition.
  • MySQL UNION Keyword - Use a UNION operation to combine multiple result sets into one.
  • MySQL COUNT Function - The MySQL COUNT aggregate function is used to count the number of rows in a database table.
  • MySQL MAX Function - The MySQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.
  • MySQL MIN Function - The MySQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.
  • MySQL AVG Function - The MySQL AVG aggregate function selects the average value for certain table column.
  • MySQL SUM Function - The MySQL SUM aggregate function allows selecting the total for a numeric column.
  • MySQL SQRT Functions - This is used to generate a square root of a given number.
  • MySQL RAND Function - This is used to generate a random number using MySQL command.
  • MySQL CONCAT Function - This is used to concatenate any string inside any MySQL command.
  • MySQL DATE and Time Functions - Complete list of MySQL Date and Time related functions.
  • MySQL Numeric Functions - Complete list of MySQL functions required to manipulate numbers in MySQL.
  • MySQL String Functions - Complete list of MySQL functions required to manipulate strings in MySQL.

Comments

Post a Comment

Popular posts from this blog

Android operating system is a stack of software components which is roughly divided into five sections and four main layers as shown below in the architecture diagram. Linux kernel At the bottom of the layers is Linux - Linux 3.6 with approximately 115 patches. This provides a level of abstraction between the device hardware and it contains all the essential hardware drivers like camera, keypad, display etc. Also, the kernel handles all the things that Linux is really good at such as networking and a vast array of device drivers, which take the pain out of interfacing to peripheral hardware. Libraries On top of Linux kernel there is a set of libraries including open-source Web browser engine WebKit, well known library libc, SQLite database which is a useful repository for storage and sharing of application data, libraries to play and record audio and video, SSL libraries responsible for Internet security etc. Android Libraries This category encompasses those Java-based li...
Post a Comment
Read more
C is a general-purpose, procedural, imperative computer programming language developed in 1972 by Dennis M. Ritchie at the Bell Telephone Laboratories to develop the UNIX operating system. C is the most widely used computer language. It keeps fluctuating at number one scale of popularity along with Java programming language, which is also equally popular and most widely used among modern software programmers. Audience This tutorial is designed for software programmers with a need to understand the C programming language starting from scratch. This tutorial will give you enough understanding on C programming language from where you can take yourself to higher level of expertise. Prerequisites Before proceeding with this tutorial, you should have a basic understanding of Computer Programming terminologies. A basic understanding of any of the programming languages will help you in understanding the C programming concepts and move fast on the learning track. Execute ...
Post a Comment
Read more
C is a general-purpose, high-level language that was originally developed by Dennis M. Ritchie to develop the UNIX operating system at Bell Labs. C was originally first implemented on the DEC PDP-11 computer in 1972. In 1978, Brian Kernighan and Dennis Ritchie produced the first publicly available description of C, now known as the K&R standard. The UNIX operating system, the C compiler, and essentially all UNIX application programs have been written in C. C has now become a widely used professional language for various reasons − Easy to learn Structured language It produces efficient programs It can handle low-level activities It can be compiled on a variety of computer platforms Facts about C C was invented to write an operating system called UNIX. C is a successor of B language which was introduced around the early 1970s. The language was formalized in 1988 by the American National Standard Institute (ANSI). The UNIX OS was totally written in C. Today C...
Post a Comment
Read more