MySQL Forums
Forum List  »  MySQL Administrator

Re: Howto add/remove columns in Table Editor
Posted by: Barry Galbraith
Date: July 17, 2009 05:51AM

I wouldn't have thought "users" would be looking at your tables.

You might save all the country names in a table called tblCountry and use the row id as a pointer, and store the pointer in the domicile table. Same with postal codes.
Then a raw view of your domicile table would then be unreadable, but quite readable with an application using a JOIN.

You could use the Query browser to pull the fields you want from multiple tables with JOINs, and present them in the order you desire, then make a View of your SELECT. The table columns themselves can be any order.

But I wouldn't let users use the Query Browser to look at my tables.

Tables are places where you keep your data, they are not for general consumption. Only administrators should be looking at tables.

Good Luck.

Options: ReplyQuote

Written By
Re: Howto add/remove columns in Table Editor
July 17, 2009 05:51AM

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.