Create table, insert data, update data and select data : MySQL « Database

Create table, insert data, update data and select data : MySQL « Database « Python Tutorial

1.	Introduction
2.	Data Type
3.	Statement
4.	Operator
5.	String
6.	Tuple
7.	List
8.	Dictionary
9.	Collections
10.	Function
11.	Class
12.	File
13.	Buildin Function
14.	Buildin Module
15.	Database
16.	Regular Expressions
17.	Thread
18.	Tkinker
19.	wxPython
20.	XML
21.	Network
22.	CGI Web
23.	Windows

Python Tutorial » Database » MySQL

15.3.6.Create table, insert data, update data and select data

import MySQLdb

cxn = MySQLdb.connect(user='root')

cxn.query('DROP DATABASE test')

cxn.query('CREATE DATABASE test')

cxn.query("GRANT ALL ON test.* to ''@'localhost'")

cxn.commit()

cxn.close()



cxn = MySQLdb.connect(db='test')

cur = cxn.cursor()

cur.execute('CREATE TABLE users(login VARCHAR(8), uid INT)')

cur.execute("INSERT INTO users VALUES('john', 7000)")

cur.execute("INSERT INTO users VALUES('jane', 7001)")

cur.execute("INSERT INTO users VALUES('bob', 7200)")

cur.execute("SELECT * FROM users WHERE login LIKE 'j%'")

for data in cur.fetchall():

      print '%s\t%s' % data



cur.execute("UPDATE users SET uid=7100 WHERE uid=7001")

cur.execute("SELECT * FROM users")

for data in cur.fetchall():

    print '%s\t%s' % data

cur.execute('DELETE FROM users WHERE login="bob"')

cur.execute('DROP TABLE users')

cur.close()

cxn.commit()

cxn.close()

15.3.MySQL
	15.3.1.	Basic connection to MySQL with mysqldb
	15.3.2.	Connecting to a MySQL Database Server
	15.3.3.	Creating a MySQL Database
	15.3.4.	Adding Entries to a MySQL Database
	15.3.5.	Retrieving Entries from a MySQL Database
	15.3.6.	Create table, insert data, update data and select data

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.