Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE `mytestdb`.`getperson` (IN personid INT)
- BEGIN
- select person.person_id,
- person.person_fname,
- person.person_mi,
- person.person_lname,
- person.persongender_id,
- person.personjob_id
- from person
- where person.person_id = personid;
- END
- import mysql.connector
- cnx = mysql.connector.connect(user='root', host='127.0.0.1', database='mytestdb')
- cnx._open_connection()
- cursor = cnx.cursor()
- cursor.execute("select * from person where person.person_id = 1")
- people = cursor.fetchall()
- for person in people:
- print(person)
- cnx.close()
- import mysql.connector
- cnx = mysql.connector.connect(user='root', host='127.0.0.1', database='mytestdb')
- cnx._open_connection()
- cursor = cnx.cursor()
- cursor.callproc("getperson", [1])
- people = cursor.fetchall()
- for person in people:
- print(person)
- cnx.close()
- import mysql.connector
- cnx = mysql.connector.connect(user='root', host='127.0.0.1', database='mytestdb')
- cnx._open_connection()
- cursor = cnx.cursor()
- cursor.execute("call getperson(1)")
- people = cursor.fetchall()
- for person in people:
- print(person)
- cnx.close()
- for result in cursor.stored_results():
- people = result.fetchall()
- import mysql.connector
- cnx = mysql.connector.connect(user='me',password='pw',host='localhost',database='mydb')
- cnx._open_connection()
- cursor = cnx.cursor()
- cursor.callproc("getperson",[1])
- for result in cursor.stored_results():
- people=result.fetchall()
- for person in people:
- print person
- cnx.close()
- cursor.callproc("getperson", ['1'])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement