Manytimes we need to split a given string into multiple parts based on some delimiter. Python provides a function named split() which can be used to achieve this. It also provides a way to control the delimiter and number of characters to be considered as delimiter.ExampleIn the below example we ... Read More

The OR operator gives true result when any one operand is true. Let us now see an example and create a table −mysql> create table DemoTable663(ClientId int, ClientName varchar(100), ClientAge int); Query OK, 0 rows affected (0.55 sec)Insert some records in the table using insert command −mysql> insert into DemoTable663 ... Read More

Let us first create a table and set default values −mysql> create table DemoTable803(UserId int DEFAULT 101, UserName varchar(100) DEFAULT 'Chris'); Query OK, 0 rows affected (1.18 sec)Insert some records in the table using insert command. For the values we are not inserting, the default values will get set automatically ... Read More

Many times we need to look into the python documentation for some help on functions, modules etc. Python provides a help function that gives us this needed results.SyntaxHelp(‘term’) Where term is the word on which we want the help.ExampleIn the below example we seek to find help on the word ... Read More

To extract from datetime column, you can use date() along with trim(). Here, trim() is used to remove whitespace while comparing. Let us first create a table −mysql> create table DemoTable661(Duedate datetime); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into ... Read More

We sometimes arrive at a situation where we have two lists and we want to check whether each item from the smaller list is present in the bigger list or not. In such case we use the filter() function as discussed below.SyntaxFilter(function_name, sequence name)Here Function_name is the name of the ... Read More

Yes, you can use date_sub() to subtract number of days from a date. Following is the syntax −select date_sub(yourColumnName, Interval yourAmountOfDays day) from yourTableName;Let us first create a table −mysql> create table DemoTable660(AdmissionDate datetime); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> ... Read More

Finding the factorial of a number is a frequent requirement in data analysis and other mathematical analysis involving python. The factorial is always found for a positive integer by multiplying all the integers starting from 1 till the given number. There can be three approaches to find this as shown ... Read More

TautologiesA Tautology is a formula which is always true for every value of its propositional variables.Example − Prove [ (A → B) ∧ A ] → B is a tautologyThe truth table is as follows −ABA → B(A → B) ∧ A[ (A → B) ∧ A ] → BTrueTrueTrueTrueTrueTrueFalseFalseFalseTrueFalseTrueTrueFalseTrueFalseFalseTrueFalseTrueAs ... Read More

There are times when you need the entire block of code as a string and want this code to execute as part of a bigger python program. IN this article we will see how we can pass code as a string to a variable and then use that variable in ... Read More