Question

Write main function of mysql

Answer 1

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.

IN OTHER WORDS

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

ADDITIONAL INFO

Relational Database System: Like almost all other database systems on the market, MySQL is a relational database system. Client/Server Architecture: MySQL is a client/server system.SQL is a standardized language for querying and updating data and for the administration of a database. Functions allow us to enhance the capabilities of MySQL.

1.Functions always return a value and can optionally accept parameters.

2.Built in functions are functions that are shipped with MySQL. ...

3.Stored functions are created by the user within MySQL server and can be used in SQL statements

HOPE YOU UNDERSTAND                                     #SJSINGH16