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

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

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:

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

What means "cannot edit"?

If I want to edit an existing view the box with the select statement is empty.

If I want to edit an existing view the box with the select statement is empty.

I think you're facing a bug in the server here. See issue #958.