Python MySQL Update Query (original) (raw)

Last Updated : 09 Mar, 2020

A connector is employed when we have to use MySQL with other programming languages. The work of MySQL-connector is to provide access to MySQL Driver to the required language. Thus, it generates a connection between the programming language and the MySQL Server.

Update Clause

The update is used to change the existing values in a database. By using update a specific value can be corrected or updated. It only affects the data and not the structure of the table.
The basic advantage provided by this command is that it keeps the table accurate.

Syntax:

UPDATE tablename SET ="new value" WHERE ="old value";

The following programs will help you understand this better.
DATABASE IN USE:

python-mysql-update

Example 1: Program to update the age of student named Rishi Kumar.

import mysql.connector

mydb = mysql.connector.connect(

`` host = 'localhost' ,

`` database = 'College' ,

`` user = 'root' ,

)

cs = mydb.cursor()

statement = "UPDATE STUDENT SET AGE = 23 WHERE Name ='Rishi Kumar'"

cs.execute(statement)

mydb.commit()

mydb.close()

Output:

python-mysql-update1

Example 2: Program to correct the spelling of an Student named SK

import mysql.connector

mydb = mysql.connector.connect(

`` host = 'localhost' ,

`` database = 'College' ,

`` user = 'root' ,

)

cs = mydb.cursor()

statement = "UPDATE STUDENT SET Name = 'S.K. Anirban' WHERE Name ='SK Anirban'"

cs.execute(statement)

mydb.commit()

mydb.close()

Output:

python-mysql-update2

Similar Reads

MySQL Queries

Python MySQL - Select Query Python Database API ( Application Program Interface ) is the Database interface for the standard Python. This standard is adhered to by most Python Database interfaces. There are various Database servers supported by Python Database such as MySQL, GadFly, mySQL, PostgreSQL, Microsoft SQL Server 2000 2 min read

CRUD Operation in Python using MySQL In this article, we will be seeing how to perform CRUD (CREATE, READ, UPDATE and DELETE) operations in Python using MySQL. For this, we will be using the Python MySQL connector. For MySQL, we have used Visual Studio Code for python. Before beginning we need to install the MySQL connector with the co 6 min read

Python MySQL - Create Database Python Database API ( Application Program Interface ) is the Database interface for the standard Python. This standard is adhered to by most Python Database interfaces. There are various Database servers supported by Python Database such as MySQL, GadFly, mSQL, PostgreSQL, Microsoft SQL Server 2000, 2 min read

Python MySQL - Update Query A connector is employed when we have to use MySQL with other programming languages. The work of MySQL-connector is to provide access to MySQL Driver to the required language. Thus, it generates a connection between the programming language and the MySQL Server. Update Clause The update is used to ch 2 min read

Python MySQL - Insert into Table MySQL is a Relational Database Management System (RDBMS) whereas the structured Query Language (SQL) is the language used for handling the RDBMS using commands i.e Creating, Inserting, Updating and Deleting the data from the databases. SQL commands are case insensitive i.e CREATE and create signify 3 min read

Python MySQL - Insert record if not exists in table In this article, we will try to insert records and check if they EXISTS or not. The EXISTS condition in SQL is used to check if the result of a correlated nested query is empty (contains no tuples) or not. It can be used to INSERT, SELECT, UPDATE, or DELETE statements. Pre-requisite Connect MySQL Da 4 min read

Python MySQL - Delete Query Python Database API ( Application Program Interface ) is the Database interface for the standard Python. This standard is adhered to by most Python Database interfaces. There are various Database servers supported by Python Databases such as MySQL, GadFly, PostgreSQL, Microsoft SQL Server 2000, Info 3 min read

MySQL Clause

Python MySQL - Where Clause Where clause is used in MySQL database to filter the data as per the condition required. You can fetch, delete or update a particular set of data in MySQL database by using where clause.SyntaxÂ SELECT column1, column2, .... columnN FROM [TABLE NAME] WHERE [CONDITION];Â Â The above syntax is used for 2 min read

Python MySQL - Order By Clause A connector is employed when we have to use MySQL with other programming languages. The work of MySQL-connector is to provide access to MySQL Driver to the required language. Thus, it generates a connection between the programming language and the MySQL Server. OrderBy Clause OrderBy is used to arra 2 min read

Python MySQL - Limit Clause A connector is employed when we have to use MySQL with other programming languages. The work of mysql-connector is to provide access to MySQL Driver to the required language. Thus, it generates a connection between the programming language and MySQL Server. Python-MySQL-Connector This is a MySQL Con 2 min read

Python MySQL - Join A connector is employed when we have to use mysql with other programming languages. The work of mysql-connector is to provide access to MySQL Driver to the required language. Thus, it generates a connection between the programming language and the MySQL Server. Python-MySQL-Connector This is a MySQL 2 min read

MySQL Working with Data

MySQL | Regular Expressions (Regexp) In MySQL, regular expressions (REGEX) offer powerful functionality for flexible pattern matching within string data. By using the REGEXP and RLIKE operators, developers can efficiently search, validate, and manipulate string data in more dynamic ways than simple LIKE queries. In this article, we wil 7 min read

SQL Query to Match Any Part of String It is used for searching a string or a sub-string to find a certain character or group of characters from a string. We can use the LIKE Operator of SQL to search sub-strings. The LIKE operator is used with the WHERE Clause to search a pattern in a string of columns. The LIKE operator is used in conj 3 min read

SQL Auto Increment In SQL databases, a primary key is important for uniquely identifying records in a table. However, sometimes it is not practical to manually assign unique values for each record, especially when handling large datasets. To simplify this process, SQL databases offer an Auto Increment feature that aut 6 min read

SQL Query to Delete Duplicate Rows Duplicate rows in a database can cause inaccurate results, waste storage space, and slow down queries. Cleaning duplicate records from our database is an essential maintenance task for ensuring data accuracy and performance. Duplicate rows in a SQL table can lead to data inconsistencies and performa 6 min read

SQL Query to Convert an Integer to Year Month and Days With this article, we will be knowing how to convert an integer to Year, Month, Days from an integer value. The prerequisites of this article are you should be having a MSSQL server on your computer. What is a query? A query is a statement or a group of statements written to perform a specific task, 2 min read

Calculate the Number of Months between two specific dates in SQL In this article, we will discuss the overview of SQL Query to Calculate the Number of Months between two specific dates and will implement with the help of an example for better understanding. Let's discuss it step by step. Overview :Here we will see, how to calculate the number of months between th 3 min read

How to Compare Two Queries in SQL Queries in SQL :A query will either be an invitation for data results from your info or for action on the info, or each. a question will provide you with a solution to a straightforward question, perform calculations, mix data from totally different tables, add, change, or delete data from info. Cre 2 min read

Joining 4 Tables in SQL The purpose of this article is to make a simple program to Join two tables using Join and Where clause in SQL. Below is the implementation for the same using MySQL. The prerequisites of this topic are MySQL and the installment of Apache Server on your computer. Introduction :In SQL, a query is a req 3 min read

MySQL Working with Images

Working with MySQL BLOB in Python In Python Programming, We can connect with several databases like MySQL, Oracle, SQLite, etc., using inbuilt support. We have separate modules for each database. We can use SQL Language as a mediator between the python program and database. We will write all queries in our python program and send th 4 min read

Retrieve Image and File stored as a BLOB from MySQL Table using Python Prerequisites: MySQL server should be installed In this post, we will be talking about how we can store files like images, text files, and other file formats into a MySQL table from a python script. Sometimes, just like other information, we need to store images and files into our database and provi 3 min read

How to read image from SQL using Python? In this article, we are going to discuss how to read an image or file from SQL using python. For doing the practical implementation, We will use MySQL database. Â First, We need to connect our Python Program with MySQL database. For doing this task, we need to follow these below steps: Steps to Conne 3 min read

Boutique Management System using Python-MySQL Connectivity In this article, we are going to make a simple project on a boutique management system using Python MySql connectivity. Introduction This is a boutique management system made using MySQL connectivity with Python. It uses a MySQL database to store data in the form of tables and to maintain a proper r 15+ min read