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

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

johnain posted 5 years ago in General
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
ansgar posted 5 years ago
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:
korgon posted 5 years ago
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
ansgar posted 5 years ago
What means "cannot edit"?
korgon posted 5 years ago
If I want to edit an existing view the box with the select statement is empty.

korgon posted 5 years ago
If I want to edit an existing view the box with the select statement is empty.
ansgar posted 5 years ago
I think you're facing a bug in the server here. See issue #958.

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