tag:blogger.com,1999:blog-4622775563416752930.post2874380844753879085..comments2022-09-01T20:53:27.194+01:00Comments on Mark's stream of verbiage: Improve reliability and maintainability by using stateless connectionsMark Robsonhttp://www.blogger.com/profile/15864507044869250062noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4622775563416752930.post-43707314239267476292008-04-16T18:53:00.000+01:002008-04-16T18:53:00.000+01:00Well in theory something like mysql_change_user() ...Well in theory something like mysql_change_user() should be a reliable way to clean up your connections:<BR/>http://dev.mysql.com/doc/refman/5.0/en/mysql-change-user.htmlAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4622775563416752930.post-7737214319454763592008-04-15T04:58:00.000+01:002008-04-15T04:58:00.000+01:00Mark, sure, I understand. As far as updates, what ...Mark, sure, I understand. As far as updates, what I meant when I said 'unique data' is updating a set of values to something that cannot be described by a single WHERE clause (a set of youtube view counts, for example).Artem Russakovskiihttps://www.blogger.com/profile/15848494241404160186noreply@blogger.comtag:blogger.com,1999:blog-4622775563416752930.post-69454497703703071682008-04-14T18:23:00.000+01:002008-04-14T18:23:00.000+01:00Don't select @@LAST_INSERT_ID or last_insert_id() ...<I>Don't select @@LAST_INSERT_ID or last_insert_id() - use your API method to get it instead.</I><BR/><BR/>Or, use natural primary keys or other unique keys instead.Sheeri K. Cabralhttps://www.blogger.com/profile/13990877688502800403noreply@blogger.comtag:blogger.com,1999:blog-4622775563416752930.post-62065804234553901442008-04-14T15:33:00.000+01:002008-04-14T15:33:00.000+01:00Using standard SQL it is possible to update multip...Using standard SQL it is possible to update multiple rows with one statement, just by having an UPDATE with a WHERE clause that matches more than one row.<BR/><BR/>I was only using this as an example of how transactions apply even with autocommit enabled.Mark Robsonhttps://www.blogger.com/profile/15864507044869250062noreply@blogger.comtag:blogger.com,1999:blog-4622775563416752930.post-46762389385041721782008-04-14T06:32:00.000+01:002008-04-14T06:32:00.000+01:00"in MySQL it is possible to delete from several ta..."in MySQL it is possible to delete from several tables in one statement, insert several rows etc" - How about updating several rows in one statement (I'm talking about actual unique data, of course, not just a column deletion or something)? Is/will that be possible?Artem Russakovskiihttps://www.blogger.com/profile/15848494241404160186noreply@blogger.com