On 11 Feb 2005, at 00:44, chromatic wrote:
> On Tue, 2005-01-11 at 01:23 +0000, Terrence Brannon wrote:
>
>> During development, I often want to quickly see if a table just
>> successfully inserted a new record.
>>
>> In MySQL, a field can be used this way. Are there any drawbacks to
>> using such a field? Of course inserts will be a bit slower. But it is
>> certainly useful in a dev environment.
>
> I prefer to count the number of rows before and after an operation
> instead of relying on the side effect of a change to hint that the
> right
> thing happened.

Ditto.

I also have a /very/ strong aversion to having my development
environment and live environments differ. I want to have the same tests
run in the same way everywhere. Having things like database schema
varying between dev/live scares me :-)

Adrian