Scribd
Upload
7 views2 pages

DBS Lab 05 Functions in SQL Task

The document outlines common functions in MySQL categorized into Numeric, String, and Date functions. It also provides lab tasks that require executing specific MySQL functions and capturing screenshots of the results. Additionally, it includes a note regarding naming conventions for databases and tables based on student registration numbers.

Uploaded by

zahidaparveen614
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views2 pages

DBS Lab 05 Functions in SQL Task

The document outlines common functions in MySQL categorized into Numeric, String, and Date functions. It also provides lab tasks that require executing specific MySQL functions and capturing screenshots of the results. Additionally, it includes a note regarding naming conventions for databases and tables based on student registration numbers.

Uploaded by

zahidaparveen614
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Common functions in MySQL

Numeric:
 AVG() - Average
 COUNT()
 SUM()
 MAX()
 MIN()
 ABS()
 CEIL()
 CEILING()
 DIV() – Division
 EXP() – Exponent
 FLOOR()
 PI()
 POWER()

String
 CONCAT()
 LOWER()
 UPPER()
 TRIM()
 LTRIM()
 RTRIM()

Date:
 CURRENT_DATE()
 CURRENT_TIMESTAMP()
Lab 05 – MySQL Function
Note:
 Database and Table name must be suffixed by last two digit of student’s Registration #.
 Each task must contain Query in text and only one screenshot of successful execution
and result. Screenshot must be edge to edge complete including Title bar and Task bar.

Lab Tasks
Task 1: Execute Absolute and Ceiling function (Two screenshot).
Task 2: Count total rows in a table. Also find maximum of table column (Two screenshot).
Task 3: Convert Name/Text column of table to Upper case (One screenshot).

You might also like