On Sun, 2 Jan 2022 at 20:42, ourdiaspora <ourdiaspora@xxxxxxxxxxxxxx> wrote: > On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte <folarte@xxxxxxxxxxxxxx> wrote: > > Inherits does not copy things. LIKE on creation does, but AFAIK it can > > copy nearly everything except data. > Thanks, had read that part of the documentation. > So far it seems that functions 'joins' may be used to view data, whilst the functions 'views' is unable to be used with data entry. > Please, any suggestions of an alternative function to use? I would first suggest you try to describe what you are trying to achieve, just to avoid https://xyproblem.info. If what you want to achieve is copying what is in table PARENT when you create table CHILD the solution is easy, providing all the extra columns have DEFAULT values, just use a CREATE LIKE followed by an INSERT INTO CHILD SELECT * FROM PARENT, it is a simple two liner that you can wrap in a function if you need to use it a lot in your work flow. If you want to see the rows of BOTH when you select from CHILD you need a VIEW, as PARENT has missing columns. As you have not stated what you want to achieve, even in the examples, not much can be suggested, hence the cite of XYproblem. Francisco Olarte.
