You can use the auto increment column. However, you have to add it to
the table.
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#example-AUTO_INCREMENT
On Thu, 12 Sep 2002, Fam. Tarniceru wrote:
> Dear Sirs,
>
> How can I handle with this situation?
> I need a speci
If you have proper indexes on alias, the optimizer should not make a table
scan. You can try to add an index on pw too. Or you could combine the two
queries with an UNION.
But beside this point you have a possible problem with the basic design.
It is possible that someone adds an alias that i
specially what
> > > indexes are available. If you just put "explain" in front of your query
> > > you will be able to see how mysql will execute your query.
> > >
> > > On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote:
> > >
>
ure and especially what
> indexes are available. If you just put "explain" in front of your query
> you will be able to see how mysql will execute your query.
>
> On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote:
>
>
>> How does MySQL process
How does MySQL process a join between tables? Does it always use
nested-loop join, or does it use sort-merge join if the table is sorted
before joining it? Is the join algorithm merge if the tables are already
sorted on the join attributes (through an index)?
Sincerely,
Toni Strandell
