Does Heidi handle MySQL 5 views. If so, where please?
| User, date | Message |
|---|---|
|
Written by johnain
4 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
4 years ago 3958 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
4 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
4 years ago 3958 posts since Fri, 07 Apr 06 |
What means "cannot edit"? |
|
Written by korgon
4 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
4 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
4 years ago 3958 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. |