MySQL Forums
Forum List  »  General

Re: any way to "ignore" a value in an INSERT/UPDATE query?
Posted by: Rick James
Date: July 20, 2013 09:21PM

> "burned" - I'm not sure I know what you mean ... The PKey is not an AI column though.

OK, ignore my comments about "burned".

> In fact it's really a unique compound index made up of an unsigned smallint ('y') and a datetime column ('z').

The tables should have PRIMARY KEY(y,z) -- or (z,y).

> Hopefully doing 3 queries won't add significant overhead as the tables are quite large.

Possibly will run faster. (Hard to say without specific schema, etc. Even then, it may be hard to predict which will be faster.)

Options: ReplyQuote


Subject
Written By
Posted
Re: any way to "ignore" a value in an INSERT/UPDATE query?
July 20, 2013 09:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.