Register on the forum now to remove ALL ads + popups + get access to tons of hidden content for members only!

Go Back   Site Owners Forums - Webmaster Forums > Web Programming > Programming General > PHP / mySQL

Notices


Reply
 
Thread Tools Rate Thread Display Modes
Old 06-01-2018, 10: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.
Pavan Techn is offline   Reply With Quote

Old 09-03-2019, 01:34 AM   #2
smith1
Registered User
 
Join Date: Feb 2018
Posts: 346
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.
smith1 is offline   Reply With Quote
Old 08-12-2020, 07:42 AM   #3
Kumkum
Registered User
 
Join Date: Dec 2017
Posts: 3
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/
Kumkum is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

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


All times are GMT -7. The time now is 09:32 AM.


Powered by vBulletin Copyright © 2013 vBulletin Solutions, Inc.