MySQL Forums
Forum List  »  Microsoft Access

Dropping a field in view
Posted by: Rolex Man
Date: April 27, 2013 07:25AM

Hi, I'm a newbie in MySQL. I live in a MS Access world most of the time.

I want to link a MySQL table remotely using the ODBC connector. I've learned that it's not "secured", but I've no idea what that means. Does it mean the data can be intercepted through cyberspace during transmission?

If it is unsecured, then I would like to only grab the non-critical information from the tables. I don't think it is possible to link a save query (I can be wrong), but I've learned that you can duplicate and link a virtual table which turns to VIEW. Is there a way to drop a column in view? I tried the same SQL to drop a column as you would for a table, but it's a no-go. Can anyone help? If it's not possible to drop a column in VIEW, can anyone suggest how I can accomplish what I'm doing, which is to link a table with certain columns only?

Options: ReplyQuote


Subject
Views
Written By
Posted
Dropping a field in view
2786
April 27, 2013 07:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.