Scribd
Upload
5 views1 page

Class 12 IP Practical MySQL and Python Functions

The document outlines essential MySQL and Python functions for Class 12 Informatics Practices. Part A lists 15 MySQL functions including COUNT(), SUM(), and CONCAT(), while Part B details 10 Python functions such as print(), input(), and len(). These functions are fundamental for data manipulation and programming tasks.

Uploaded by

vanshwatts98
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
5 views1 page

Class 12 IP Practical MySQL and Python Functions

The document outlines essential MySQL and Python functions for Class 12 Informatics Practices. Part A lists 15 MySQL functions including COUNT(), SUM(), and CONCAT(), while Part B details 10 Python functions such as print(), input(), and len(). These functions are fundamental for data manipulation and programming tasks.

Uploaded by

vanshwatts98
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

Class 12 Informatics Practices Practical File

Part A: MySQL Functions (15)


1 COUNT() – Returns the number of rows.
2 SUM() – Returns the total sum of a numeric column.
3 AVG() – Returns the average value of a numeric column.
4 MIN() – Returns the minimum value.
5 MAX() – Returns the maximum value.
6 NOW() – Returns the current date and time.
7 CURDATE() – Returns the current date.
8 UPPER() – Converts text to uppercase.
9 LOWER() – Converts text to lowercase.
10 LENGTH() – Returns the length of a string.
11 ROUND() – Rounds a numeric value.
12 MOD() – Returns the remainder of a division.
13 SUBSTR() – Extracts a substring.
14 CONCAT() – Joins two or more strings.
15 ABS() – Returns the absolute value.

Part B: Python Functions (10)


1 print() – Displays output on the screen.
2 input() – Takes input from the user.
3 len() – Returns the length of an object.
4 type() – Returns the type of an object.
5 int() – Converts a value to integer.
6 float() – Converts a value to float.
7 str() – Converts a value to string.
8 range() – Generates a sequence of numbers.
9 max() – Returns the largest value.
10 min() – Returns the smallest value.

You might also like