May I appeal to primary key without knowing name of it? - Michael Widenius - com.mysql.lists.java

4 messages in com.mysql.lists.javaMay I appeal to primary key without k...

From	Sent On	Attachments
Evgeniy Strokin	18 Feb 2003 08:54
Michael Widenius	25 Feb 2003 03:28
Evgeniy Strokin	26 Feb 2003 05:46
Evgeniy Strokin	27 Feb 2003 10:42

Subject:	May I appeal to primary key without knowing name of it?
From:	Michael Widenius (mon...@mysql.com)
Date:	02/25/2003 03:28:27 AM
List:	com.mysql.lists.java

Hi!

"Evgeniy" == Evgeniy Strokin <evge...@yahoo.com> writes:

Evgeniy> Hi, Evgeniy> Is it possible to make such query and run it via JDBC: Evgeniy> Select * from tableName where primary_key = 123 Evgeniy> Primary_key is not name of column. In fact I dont Evgeniy> know what is name of primary key. But I know only that Evgeniy> primary key should be = 123. Evgeniy> Another words: may I appeal to primary key without Evgeniy> knowing name of it?

You can do:

SELECT * from table_name WHERE _rowid=123

_rowid is in MySQL an alias for the primary key...

Regards, Monty