What is the usage of SQL functions? - Site Owners Forums

Pavan Techn · 06-01-2018, 11:17 AM

SQL functions are used for following purpose:

To perform calculations on data.
To modify individual data items.
To manipulate the output.
To format dates and numbers.
To convert data types.

smith1 · 09-03-2019, 02:34 AM

SQL functions are used extensively in databases to manipulate and process data. All SQL systems have built-in as well as user-defined SQL functions. SQL functions can act on each individual row of data or on multiple rows of data grouped on the values of a field (or fields) in the table.

Kumkum · 08-12-2020, 08:42 AM

MySQL function is a stored program that can be called when required and passed parameters to get a value in return. You can create your own functions, but there are many built-in functions provided you can use off the shelves.

You can use the functions in SQL statements or as queries in MySQL. Alternatively, they can also be used within a MySQL programming environment.

You can check: https://hoststud.com/new/resources/c...must-know.647/

06-01-2018, 11:17 AM	#1
Pavan Techn Registered User Join Date: Mar 2018 Posts: 341	What is the usage of SQL functions? SQL functions are used for following purpose: To perform calculations on data. To modify individual data items. To manipulate the output. To format dates and numbers. To convert data types. __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

09-03-2019, 02:34 AM	#2
smith1 Registered User Join Date: Feb 2018 Posts: 402	SQL functions are used extensively in databases to manipulate and process data. All SQL systems have built-in as well as user-defined SQL functions. SQL functions can act on each individual row of data or on multiple rows of data grouped on the values of a field (or fields) in the table. __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Database Recovery	WilliamTravis	Search Engine Optimization	0	01-14-2016 12:23 AM
Windows Hosting on IIS 8 Server with Free SQL 2012 Database	thewebhosting	Web Promotion	1	04-04-2013 09:53 AM
SQL Server and PHP	williamcastro22	PHP / mySQL	16	06-04-2012 03:14 AM

08-12-2020, 08:42 AM	#3
Kumkum Registered User Join Date: Dec 2017 Posts: 5	MySQL function is a stored program that can be called when required and passed parameters to get a value in return. You can create your own functions, but there are many built-in functions provided you can use off the shelves. You can use the functions in SQL statements or as queries in MySQL. Alternatively, they can also be used within a MySQL programming environment. You can check: https://hoststud.com/new/resources/c...must-know.647/

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)