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

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
Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use; don't define a field as 10 characters wide if you know you're only going to use 2 characters. These types of fields (or columns) are also referred to as data types, after the  type of data  you will be storing in those fields. MySQL uses many different data types broken into three categories: numeric, date and time, and string types. Numeric Data Types: MySQL uses all the standard ANSI SQL numeric data types, so if you're coming to MySQL from a different database system, these definitions will look familiar to you. The following list shows the common numeric data types and their descriptions: INT  - A normal-sized integer that can be signed or unsigned. If signed, the allowable range is from -2147483648 to 2147483647. If unsigned, the allowable range is from 0 to 4294967295. You can specify a widt
Post a Comment
Read more