distal-attribute
distal-attribute
distal-attribute
distal-attribute

Does Heidi handle MySQL 5 views. If so, where please?

User, date Message
Written by johnain
5 years ago
Category: General
7 posts since Tue, 08 Sep 09
Hi there

I have a series of master data tables with multi-lingual texts for stuff like description stored in another table with the same key + an extra key field for language.

I plan to create views for stuff like text searches, but I cannot find anything in Heidi to help me to define them.

Please can somebody update me on this.

John
Written by ansgar
5 years ago
4940 posts since Fri, 07 Apr 06
If you cannot find anything you're likely not using HeidiSQL 4.0 are you? In 4.0, views are displayed in the same context as tables, and also stored procedures and functions. Rightclick anywhere, click "New" > "View" to create a new one, or rightclick a view and click "Edit..." to edit an existing one. The "Data" tab is also available for views.

This is the View editor:
Written by korgon
5 years ago
3 posts since Tue, 29 Sep 09
Hi,

I'm using Heidi x.y Revsion 2656 with mySQL 5 and I cannot edit view with the view editor.

Is this a bug?

Greets

Georg
Written by ansgar
5 years ago
4940 posts since Fri, 07 Apr 06
What means "cannot edit"?
Written by korgon
5 years ago
3 posts since Tue, 29 Sep 09
If I want to edit an existing view the box with the select statement is empty.
Written by korgon
5 years ago
3 posts since Tue, 29 Sep 09
If I want to edit an existing view the box with the select statement is empty.
Written by ansgar
5 years ago
4940 posts since Fri, 07 Apr 06
I think you're facing a bug in the server here. See issue #958.
 

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