feature request: virtual fields

[expired user #6736]'s profile image [expired user #6736] posted 11 years ago in General Permalink
Many years ago I worked with a database that had 'virtual fields', which are very convenient, and I think will be a wonderful addition to HeidiSQL.
Suppose you have:
Table1:
name: transactions,
fields: customerID, bought_item, date.
Table 2:
name: custromers
fields: customerID. customerName

In order to get a list of transactions that include the customer name, I need a query in order to join the tables.
Instead, it would be nice to add a 'virtual field' to Table1 called customerName, which will not really hold data; rather it will be data extracted from Table2 for the view. Furthermore, once such a field is defined, it can also be used in queries, as if this field is part of Table 1.
kalvaro's profile image kalvaro posted 11 years ago Permalink
Views have been supported for a long while. If you are not talking about that you should explain what you mean exactly.
ansgar's profile image ansgar posted 11 years ago Permalink
And MariaDB + HeidiSQL supports virtual column definition, see the "Virtuality" column in Heidi's table editor.

Please login to leave a reply, or register at first.