Update Operation

The UPDATE-SET statement is used to update any column inside the table. The following SQL query is used to update a column.

<br />
>  update Employee set name = ‘alex’ where id = 110<br />

Consider the following example.

Example

<br />
import mysql.connector</p>
<p>#Create the connection object<br />myconn = mysql.connector.connect(host = “localhost”, user = “root”,passwd = “google”,database = “PythonDB”)</p>
<p>#creating the cursor object<br />cur = myconn.cursor()</p>
<p>try:<br />    #updating the name of the employee whose id is 110<br />    cur.execute(“update Employee set name = ‘alex’ where id = 110”)<br />    myconn.commit()<br />except:</p>
<p>    myconn.rollback()</p>
<p>myconn.close()<br />

Update Operation

Delete Operation

The DELETE FROM statement is used to delete a specific record from the table. Here, we must impose a condition using WHERE clause otherwise all the records from the table will be removed.

The following SQL query is used to delete the employee detail whose id is 110 from the table.

<br />
>  delete from Employee where id = 110<br />

Consider the following example.

Example

<br />
import mysql.connector</p>
<p>#Create the connection object<br />myconn = mysql.connector.connect(host = “localhost”, user = “root”,passwd = “google”,database = “PythonDB”)</p>
<p>#creating the cursor object<br />cur = myconn.cursor()</p>
<p>try:<br />    #Deleting the employee details whose id is 110<br />    cur.execute(“delete from Employee where id = 110”)<br />    myconn.commit()<br />except:</p>
<p>    myconn.rollback()</p>
<p>myconn.close()<br />

原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/tech/courses/263638.html

Update Operation

Update Operation

Example

Delete Operation

Example

相关推荐

发表回复