If value of a parameter is already known then you can assign default values to a Python function’s parameter. Further, the default values can be specified in the function header. For example, def sum(x, y, z=15): s=x+y+z return s In the above program, value of parameter z is 15. If in program, function call sum(20, […]
Default Arguments in Python Functions Read More »
Time and date datatypes and functions in SQL play very important role in DBMS (Database Management Systems). Such as, transaction management, or admission time of a student, time of product purchase and many more cases where time and date datatypes and functions becomes essential. In this post, I will explain time and date datatypes and
Time and Date Datatypes and Functions in SQL Read More »
Array in PHP- In PHP, there are three types of arrays , and array() function is used to create an array in PHP. 1- Indexed or Numeric Array- In a numeric or an indexed array elements of an array are indexed with numeric values. For example, if you define an array ar with the elements
See Also: Time and Date Datatypes and Functions in SQL Create a Table in SQL and Select Data from Table Update Command in Structured Query Language (SQL) BETWEEN, NOT BETWEEN, IN and NOT IN Operators in SQL Create Table Insert Data Into Table and Select Data in SQL
ORDER BY Keyword in SQL Read More »
In the previous post Create Table Insert Data Into Table and Select Data in SQL, you have learnt how to create a table, insert data into it and select rows and columns from table. In this post, you will learn how to use BETEEN, NOT BETWEEN, IN and NOT IN operators
BETWEEN, NOT BETWEEN, IN and NOT IN Operators in SQL Read More »
Structured Query Language (SQL) is standard language to manipulate databases. MySQL, MariaDB, MS-Access and all popular Database Management System software use SQL. In this post, I will demonstrate how to create a table, insert data into table and select columns and rows. In this example, I will example of class table of school database. So,
Create Table Insert Data Into Table and Select Data in SQL Read More »
Dictionary in Python is a very important data-structure which can have elements in the form of of key value pairs key:value. Moreover, dictionary also provides different methods to manipulate. In this post, I will explain methods which will work on dictionary. If you use print(dir(dict)) Then you will see the output. The above output
Dictionary Methods in Python Read More »
Dictionary in Python is a very important data-structure which can have unordered list of key value pairs. See a dictionary d={2:4, 3:9, 4:16, ‘India’:’Delhi’} In dictionary d, you can key:value pairs this is one of the ways to create a dictionary. However, there are several ways to create a dictionary using dict() function. In this
Different Ways to Create a Dictionary in Python Read More »
A list in Python is collection of values of any type such as integer, float, string or a complex number in a square bracket separated by comma. For example If you can create a list l as follows l=[50, “Post”, “Network”, 50.3, 80, 100, 150, 180, 200, 300] In the above list you can see
Slicing of a List in Python Read More »
Set is a fundamental concept in mathematics and each object of interest in mathematics is set of some type. Set theory was developed by German mathematician George Cantor, who defined set as collection of well-defined objects. Here well-defined means. One can say or decide that an element belongs to a given collection or not. If
Set in Mathematics Read More »