but of course, once you have got that data, it will not send it again.
In SQL, a view is a virtual table based on the result-set of an SQL statement.
A view contains rows and columns, just like a real table.
The fields in a view are fields from one or more real tables in the database.
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
You might want to consider having this logic in the application itself and switch between databases.
If it's strictly view related you should look into gettext.
Changing the data in a referenced tables alters the data shown in subsequent invocations of the view. If you ask me the time now I will tell you it is ten o'clock.
So in my database, my tables have column named "name_english" and "name_french" for example and some other numeric columns.
I can't find the My SQL query I used to get this view (it's quite obscure one) - so how can I edit the My SQL query that created this view to add a new column into it?
On the Query Result page you should see an options button/link (I have it on 3.5.7) - click that to get a "Full texts" option vs. That should get you the entire SQL result text not just the truncated version you currently see. Run the query directly (with out the CREATE VIEW...
To further elaborate - if I update the table then does the view get updated even if I don't run any query on the view?