Why can't I insert it?

INSERT into ' category ' (' IDs ', (select Concat (Catpath, '-', id) as Abspath from category Order by Abspath) as Abspath, ' name ' ) VALUES (44, ' 0-1-2-11 ', ' website homepage ');

Why can't I insert

Reply to discussion (solution)

INSERT into ' category ' (' id ', ' abspath ', ' name ') VALUES
(44, ' 0-1-2-11 ', ' website homepage ');
The category parentheses are the fields. Why do you write SQL statements?

INSERT into ' category ' (' id ', ' abspath ', ' name ') VALUES
(44, ' 0-1-2-11 ', ' website homepage ');
The category parentheses are the fields. Why do you write SQL statements?

Insert it.

INSERT into ' category ' (' id ', ' abspath ', ' name ') VALUES
(44, ' 0-1-2-11 ', ' website homepage ');
The category parentheses are the fields. Why do you write SQL statements?

Then I'm going to have to implement my function.

INSERT into ' category ' (' id ', ' abspath ', ' name ') VALUES
(44, ' 0-1-2-11 ', ' website homepage ');
The category parentheses are the fields. Why do you write SQL statements? Come on, I'm still using the original method.

INSERT into ' category ' (' id ', ' catpath ', ' name ') VALUES
(Concat, (Catpath, '-', id) as Abspath from the category order by Abspath) as Abspath, ' website home ');
??？

Do not know what to do, your category table does not have a abspath field.

Is this field catpath to write wrong?

