The rollback() method is one among the various methods in Python which is used to make the database transactions.Here, we will discuss about the rollback() method.The rollback() method is used to revert the last change or commit made to the database. If a condition arises such that the user is not satisfied with the changes made to the database, or if the transaction fails, then the rollback() method is operated to bring the database to its original state which was before committing the changes. This is a very important method as it helps in maintaing the integrity of the database ... Read More

The commit() method is one among the various methods in Python which is used to make the database transactions.Here, we will discuss about the commit() method. The commit() method is used to confirm the changes made by the user to the database. Whenever any change is made to the database using update or any other statements, it is necessary to commit the changes. If we donot use the commit() method after making any changes to the database, the database will not not be updated and changes will not be reflected.Syntaxdb.commit()db refers to the database connection object.Given below is an example ... Read More

LIKE is a operator in MySQL. The LIKE operator is used with the WHERE statement to search for a specific pattern in the table.Suppose you want to search for values which start with “a” in the table, the LIKE statement is used in such scenarios.There are two wildcard characters used with the LIKE clause.% − This sign represents zero, one or multiple characters._ (underscore) − This represents one single character.ExampleLIKE ‘a%’ - Searches for all the values starting with a.LIKE ‘%a’  -Searches for all the values which end with a.LIKE ‘_a%’ - Searches for all the values where ‘a’ is ... Read More

The MIN() and MAX() functions are used to perform arithmetic operations on the columns of the table.As the name suggests, the MIN() function is used to select and return the samllest value from the selected column.The MAX() function, on the other hand, selects and returns the highest value from the selected column.SyntaxMIN()SELECT MIN(column_name) FROM table_nameMAX()SELECT MAX(column_name) FROM table_nameSteps invloved in finding minimum and maximum value from a column in table using MySQL in pythonimport MySQL connectorestablish connection with the connector using connect()create the cursor object using cursor() methodcreate a query using the appropriate mysql statementsexecute the SQL query using execute() ... Read More

We can join two tables in SQL based on a common column between them or based on some specified condition. There are different types of JOIN available to join two SQL tables.Here, we will discuss about the SELF join on two tables.As the name signifies, SELF join is the join with the table itself. This join is performed between two copies of the same table. The rows of the table are matched with the other rows of the same table based on some condition.SyntaxSELECT a.coulmn1 , b.column2 FROM table_name a, table_name b WHERE condition;a and b are the two aliases ... Read More

We can join two tables in SQL based on a common column between them or based on some specified condition. There are different types of JOIN available to join two SQL tables.Here, we will discuss about the FULL join on two tables. In the FULL JOIN, all the records from both the tables are included in the result. For the records for which no matching is found, NULL is inserted on the either sides.SyntaxSELECT column1, column2... FROM table_1 FULL JOIN table_2 ON condition;Let there be two tables, “Students” and “Department” as folllows −Students+----------+--------------+-----------+ |    id    | Student_name | ... Read More

We can join two tables in SQL based on a common column between them or based on some specified condition. There are different types of JOIN available to join two SQL tables.Here, we will discuss about the RIGHT join on two tables.In the RIGHT JOIN, all the records from the second table or the right table are always included in the result. From the left table, the matching records are joined to the records of the right table. If there is no matching record found for a row in right table, then None is joined with that record.The tables are ... Read More

We can join two tables in SQL based on a common column between them or based on some specified condition. There are different types of JOIN available to join two SQL tables.Here, we will discuss about the LEFT join on two tables. The tables can be joined using the LEFT join. In the LEFT JOIN, all the records from the first table or the left table are always included in the result. From the right table, the matching records are joined to the records of the left table. If there is no matching record found for a row in left ... Read More

We can join two tables in SQL based on a common column between them or based on some specified condition. There are different types of JOIN available to join two SQL tables.Here, we will discuss about the inner join on two tables.JOIN and INNER JOIN both work the same way. The INNER JOIN matches each row in one table with every row in other table and allows to combine the rows from both the tables which either have somecommon column or which satisfy some condition which is specified.When applying join among two tables, we need to specify the condition based ... Read More

There might be a scenario where you might be deleting a table which actually does not exist in your database. It is possible that while executing the command to delete a table from the database, we may give wrong name of the table which doesnot exist in our database. The another possibility is that you are deleting a table which was already deleted by someone else who has access to the database. In this scenario you will get an error while executing the command since the table you wish to delete is not present.This error can be avoided by checking ... Read More