Wow, I want to unlearn this. """ For the benefit of some ODBC applications, the following query can be used to find a newly inserted row: ... SELECT * FROM tbl_name WHERE auto IS NULL;
All further executions of the same statement provide the expected result """ Thanks, Michael! --diana On Tue, Oct 26, 2010 at 11:27 PM, Michael Bayer <[email protected]> wrote: > yeah you'd have to search around MySQL's bugtracker for that one, I've seen > it before, the only record I can find at the moment is #4 here: > > http://sql-info.de/mysql/gotchas.html#1_1 > > > > > On Oct 26, 2010, at 11:16 PM, Diana Clarke wrote: > >> Any ideas why I'm getting one row back with an id of 5 when I filtered >> by id IS NULL? >> >> [SQLAlchemy-0.6.4, MySQL 5, MyISAM] >> >> sqlalchemy.engine.base.Engine.0x...eb2c: INFO: SELECT user.id AS >> user_id, user.username AS user_username, user.level AS user_level >> FROM user >> WHERE user.level = %s AND user.id IS NULL >> >> sqlalchemy.engine.base.Engine.0x...eb2c: INFO: (1,) >> >> sqlalchemy.engine.base.Engine.0x...eb2c: DEBUG: Col ('user_id', >> 'user_username', 'user_level') >> >> sqlalchemy.engine.base.Engine.0x...eb2c: DEBUG: Row (5L, u'jane', 1) >> >> Thanks, >> >> --diana >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/sqlalchemy?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
