SQL Functions

  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8416
  • Loc: USA

Post 3+ Months Ago

Where could I find all of the SQL functions, clauses and everything on the web? I googled and couldn't find anything that lists all of the functions of SQL... I found a few aggregate and a few scalar functions but that's about it.

So far, I've got the following:
PHP Code: [ Select ]
<?php
$sql_funcs = array(
   'AGGR' => array(
      'AVG',
    'COUNT',
    'SUM',
    'FIRST',
    'LAST',
    'MAX',
    'MIN'
    ),
   'SCALAR' => array(
      'UCASE',
    'LCASE',
    'MID',
    'LEN',
    'ROUND',
    'NOW',
    'FORMAT',
    'ABS',
    'SIGN',
    'MOD',
    'ROUND',
    'POW',
    'SQRT',
    'LEAST',
    'GREATEST',
    'LOWER',
    'UPPER',
    'CONCAT',
    'LENGTH',
    'LTRIM','TRIM','RTRIM',
    'SUBSTRING',
    'DATEOB'
    ),
   'SEC' => array(
      'USER',
    'PRIVGROUPS'
      ),
   'OTHERS' => array(
      'IF',
      'COALESCE',
      'UNIQUEKEY',
      'TONUMBER'
      )
   );
?>
  1. <?php
  2. $sql_funcs = array(
  3.    'AGGR' => array(
  4.       'AVG',
  5.     'COUNT',
  6.     'SUM',
  7.     'FIRST',
  8.     'LAST',
  9.     'MAX',
  10.     'MIN'
  11.     ),
  12.    'SCALAR' => array(
  13.       'UCASE',
  14.     'LCASE',
  15.     'MID',
  16.     'LEN',
  17.     'ROUND',
  18.     'NOW',
  19.     'FORMAT',
  20.     'ABS',
  21.     'SIGN',
  22.     'MOD',
  23.     'ROUND',
  24.     'POW',
  25.     'SQRT',
  26.     'LEAST',
  27.     'GREATEST',
  28.     'LOWER',
  29.     'UPPER',
  30.     'CONCAT',
  31.     'LENGTH',
  32.     'LTRIM','TRIM','RTRIM',
  33.     'SUBSTRING',
  34.     'DATEOB'
  35.     ),
  36.    'SEC' => array(
  37.       'USER',
  38.     'PRIVGROUPS'
  39.       ),
  40.    'OTHERS' => array(
  41.       'IF',
  42.       'COALESCE',
  43.       'UNIQUEKEY',
  44.       'TONUMBER'
  45.       )
  46.    );
  47. ?>


Thanks in advance
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13504
  • Loc: Florida

Post 3+ Months Ago

http://en.wikipedia.org/wiki/SQL:2008
  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8416
  • Loc: USA

Post 3+ Months Ago

Umm... that doesn't really list any functions at all... I don't really know what you mean by that link.

On a different note, I didn't knew they redid SQL...
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13504
  • Loc: Florida

Post 3+ Months Ago

http://www.iso.org/iso/iso_catalogue/ca ... mber=45499

It's the SQL standard, the standard which database engine makers base the functionality of their database engines on. Access to the standard is not free like say, the DTD of an HTML or XHTML document is.

Unless you amend your question to specify SQL functions and extensions supported by specific version of a specific database engine, that link is the answer to your question.
  • RedBMedia
  • Proficient
  • Proficient
  • User avatar
  • Posts: 315

Post 3+ Months Ago

Have you seen this yet???


http://oreilly.com/catalog/sqlnut/chapter/ch04.html
  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8416
  • Loc: USA

Post 3+ Months Ago

Alright... how about MySQL and MsSQL Functions and extensions then?

O
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13504
  • Loc: Florida

Post 3+ Months Ago

You should be able to swap the "5.0" in the URL with the version you want.

http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html
  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8416
  • Loc: USA

Post 3+ Months Ago

Why did I not think of going there??? Thanks joebert.
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13504
  • Loc: Florida

Post 3+ Months Ago

Also if you're working from the command line you can type "help contents" which will give you a list of other help commands like "help functions" which will in turn give you a list of function groups which leads to, well here.

Code: [ Select ]
mysql> help contents
You asked for help about help category: "Contents"
For more information, type 'help <item>', where <item> is one of the following
categories:
   Account Management
   Administration
   Data Definition
   Data Manipulation
   Data Types
   Functions
   Functions and Modifiers for Use with GROUP BY
   Geographic Features
   Language Structure
   Storage Engines
   Stored Routines
   Table Maintenance
   Transactions
   Triggers
   User-Defined Functions
   Utility
 
mysql> help functions
You asked for help about help category: "Functions"
For more information, type 'help <item>', where <item> is one of the following
topics:
   PROCEDURE ANALYSE
categories:
   Bit Functions
   Comparison operators
   Control flow functions
   Date and Time Functions
   Encryption Functions
   Information Functions
   Logical operators
   Miscellaneous Functions
   Numeric Functions
   String Functions
 
mysql> help bit functions
You asked for help about help category: "Bit Functions"
For more information, type 'help <item>', where <item> is one of the following
topics:
   &
   <<
   >>
   BIT_COUNT
   ^
   |
   ~
 
mysql>
 
  1. mysql> help contents
  2. You asked for help about help category: "Contents"
  3. For more information, type 'help <item>', where <item> is one of the following
  4. categories:
  5.    Account Management
  6.    Administration
  7.    Data Definition
  8.    Data Manipulation
  9.    Data Types
  10.    Functions
  11.    Functions and Modifiers for Use with GROUP BY
  12.    Geographic Features
  13.    Language Structure
  14.    Storage Engines
  15.    Stored Routines
  16.    Table Maintenance
  17.    Transactions
  18.    Triggers
  19.    User-Defined Functions
  20.    Utility
  21.  
  22. mysql> help functions
  23. You asked for help about help category: "Functions"
  24. For more information, type 'help <item>', where <item> is one of the following
  25. topics:
  26.    PROCEDURE ANALYSE
  27. categories:
  28.    Bit Functions
  29.    Comparison operators
  30.    Control flow functions
  31.    Date and Time Functions
  32.    Encryption Functions
  33.    Information Functions
  34.    Logical operators
  35.    Miscellaneous Functions
  36.    Numeric Functions
  37.    String Functions
  38.  
  39. mysql> help bit functions
  40. You asked for help about help category: "Bit Functions"
  41. For more information, type 'help <item>', where <item> is one of the following
  42. topics:
  43.    &
  44.    <<
  45.    >>
  46.    BIT_COUNT
  47.    ^
  48.    |
  49.    ~
  50.  
  51. mysql>
  52.  

Post Information

  • Total Posts in this topic: 9 posts
  • Users browsing this forum: No registered users and 52 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.