execute row is added to the table
Brought to you by:
brujahpriest,
jfranz
conn=pdo.connect("Module=MySQLdb;User=xx;Passwd=xx;DB=test")
ex=conn.execute("insert into test.Tests(name) values('This is a Test2')")
Issue:
execute causes auto incrementing of a private key in the database table, but no row is added to the table.
PDO version 1.3.2
Mysql: 5.0.32
Logged In: NO
I found the issue! The transaction must be committed after executing the SQL statement.