Whatever I'm enthused about at the moment ;-p

MySQL 5.5 and InnoDB

2013-01-19 - Category: computing

<< One of my servers downstairs shut itself off -12 F is too painful for my tastes >>

Welp, this totally screwed me over today as I spent hours wondering why my Perl script's MySQL insert and update statements weren't working on some tables. If you've recently upgraded to MySQL 5.5, new tables that you create are InnoDB instead of MyISAM, and so AutoCommit must be turned on or you can just do a commit statement after your inserts and updates. FFFFUUUUUU. PHP has AutoCommit turned on by default, evidently, so it is not effected.


Copyright © 2001 - 2014, Korey Pelton -- Static HTML blog generated with PeltonBlog