Hi Samuel, I am not sure if you can add a new column to a view, but why dont u create a new table test4 as
create table test4 AS SELECT nummer AS name, ip as content FROM jabix.spaces JOIN jabix.ves ON spaces.veid = ves.id; And then add the new column to test4. When ever any new data is added into jabix, also enter the data into test4. On 10/14/08, Samuel Vogel <[EMAIL PROTECTED]> wrote: > > Hey guys, > > I am trying to construct a specially crafted view for the powerdns > DNS-Server. > This is what I have so far: > CREATE VIEW test4 AS SELECT nummer AS name, ip as content FROM jabix.spaces > JOIN jabix.ves ON spaces.veid = ves.id; > > +--------+---------------+ > | name | content | > +--------+---------------+ > | 234235 | 11.46.3.22 | > | 345232 | 11.46.3.53 | > +--------+---------------+ > > But this is only a part of what powerdns expects as input table. > For example I would like to add a field namend 'domain_id', which is always > set to 1 or defaults to 1, without altering my existing tables. > > How would I achieve this? > > Regards, > Samy > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
