data inserted by python not showing up

MySQL database connector for Python programming

Brought to you by: adustman

data inserted by python not showing up

Forum: Help

Creator: Steve Young

Created: 2006-01-05

Updated: 2012-09-19

Steve Young - 2006-01-05

When I use MySQLdb and insert some values into a table, python says that it is inserted and when I try to select the value with python, it gets selected and shows up. But then when I use mysql and try to look at the table, it doesn't show up. Can anyone help me out? Thanks.

-Steve

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- iVirus - 2006-01-21
  
  I had same problem. I try change type of table from InnoDB to MyISAM and work it.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Andy Dustman - 2006-01-21
    
    Yes, that's one solution. The non-crazy solution is to call commit() on your database connection.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- szplug - 2006-01-05
  
  I'm just guessing, I really don't know. Try calling commit() in your Python code, or set autocommit (however it's spelled) - though I thought it was on by default.
  
  Post more details if that doesn't work.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.