Question about synonym tables in MySQL 1

[jshuen]

Hi,

I was just wondering if anyone knows whether MySQL v 3.5 supports synonym tables on the database level.

Regards,
jshuen

 

[swampBoogie]

No

 

[jshuen]

how about in version 4?

 

[swampBoogie]

Haven't seem anything about that on the todo list.

 

[sleipnir214]

I'm not familiar with that nomenclature.

Out of curiosity, what is a synonym in this context, and what servers support it? Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[swampBoogie]

A synonym serves as an alias for a table or view

create synonym x for sleipnir214.t

after that I could use x instead of sleipnir214.t in my DML statements.

There is also some DBMS that have

create global/public synonym x for sleipnir214.t

which means that all users can use x without any qualification.

Synonyms is not an ANSI standard feature.

It is supported in Oracle and mimer for instance possibly more, with variations in the exact functionality though.

 

[sleipnir214]

swampBoogie:
Thanks.

What do synonyms give you other than simplifying queries? Can you hang permissions on them, like views in PostgreSQL?

jshuen:
Yeah, I doubt there is any plan to implement something like that in MySQL any time soon. They're only just now getting around to subselects and stored procedures.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[swampBoogie]

It has not really to do with permissions, this is stil checked for the original table.

As I see it, if you have views, synonyms does not serve any real purpose.

 

[sleipnir214]

swampBoogie:

<sarcasm>
So we have found Oracle's appendix?
</sarcasm> Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!