feature request: virtual fields

User, date Message
Written by ofer
1 year ago
Category: General
9 posts since Sun, 23 Dec 12
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:
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.
Written by kalvaro
1 year ago
595 posts since Thu, 29 Nov 07
Views have been supported for a long while. If you are not talking about that you should explain what you mean exactly.
Written by ansgar
1 year ago
5023 posts since Fri, 07 Apr 06
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.