How can I get the primary key in VIEW (a key that is independent of the source tables)

Question

I create a VIEW OF 3 TABLES. Each TABLE has a primary key. However, in VIEW, in order to have a primary key, I will have to use a composite primary key (combination of primary keys 3 TABLES).

However, I would like to add a column to VIEW as a primary key that is created only for VIEW purposes. As part of the definition of VIEW, it must be UNIQUE (auto-increment, since it will be mainly INT). How can i achieve this?

I am using MySQL 5.1

Answer 1

You can use various methods to insert a unique identifier in the data of the form, for example:

SELECT @rownum:=@rownum+1 as id, mytable.*
FROM (SELECT @rownum:=0) r, mytable;

, .

?

Answer 2

SELECT @rownum:=@rownum+1 as id, mytable.*
FROM (SELECT @rownum:=0) r, mytable;

- mysql, sub-select FROM. .

Answer 3

- mysql , .

Answer 4

- . .

... , ( )

(although I say SQL Server ... I'm not sure how this translates to MySQL)