Solved - Python: automate input to MySQL query
Joe Riopel
goon12 at gmail.com
Thu Sep 24 08:49:02 EDT 2009
On Wed, Sep 23, 2009 at 4:21 PM, D'Arcy J.M. Cain <darcy at druid.net> wrote:
> In any case, I have a strong philosophical objection to using the same
> name to refer to two different things regardless of any operational
> issues. The manager.firstname and employee.firstname are not the same
> thing and should have different names to reflect that.
They are in separate tables, that should be enough to reflect the fact
that they're not the same thing.
> A similar issue comes up in the classic situation of the inventory table
> price field and the sale item price field. They sound like the same
> thing but they are not. One is the current price in the catalogue and
> the other is the price it was sold for at a particular time. They need
> different names for that reason.
I am not sure if you're talking about two different tables (inventory
and sale?). If you meant a single table; I would hope you don't have
two columns, with the same name, in a single table. If you were
talking about two different tables, see my above comment.
More information about the Python-list
mailing list