'Character manipulation functions' diaporamas de présentation

Ch. 3 Single-Row Functions

590 views • 46 slides

Single-Row Functions

Single-Row Functions. Objectives. After completing this lesson, you should be able to do the following: Describe various types of functions available in MySQL Use character, number, and date functions in SELECT statements Describe the use of conversion functions . Input. Output. arg 1.

634 views • 43 slides

Lecture 5

Lecture 5. SQL FUNCTIONS. Functions are a very powerful feature of SQL. They can be used to do the following: Perform calculations on data Modify individual data items Manipulate output for groups of rows Format dates and numbers for display

195 views • 19 slides