Add field to View

H

Hardus

Member
HI, I created a view via a sql query, I added a new field to the main table, how do I add it to the view also?

[pre]
You are using DaDaBIK version 9.2-Monterosso enterprise, installed on 11-15-2018 (installation code: 140855bc739c14ccd4), the latest version of DaDaBIK is 9.2-Monterosso released on 11-07-2018

You are runnning the last release of DaDaBIK

PHP Version: 7.2.10-0ubuntu0.18.04.1

mysql version: 5.7.24-0ubuntu0.18.04.1

Web server: Apache/2.4.29 (Ubuntu)

Client: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.110 Safari/537.36
[/pre]
 
H

Hardus

Member
Thats the ultimate, but just was looking for an easier way, theres a way in mysql but I cannot get the command 100% working.

https://www.techonthenet.com/mysql/views.php
 
eugenio

eugenio

Administrator
Staff member
There isn't an easier way, the alter view command is more or less like a drop + create.

Best,
 
You must log in or register to reply here.
Top