mysql - Stored procedure with strings -
i'm trying figured out how use insert statement in stored procedure. want put data table
like (concept, a, b, c, d, e, f, g)
but want result this:
concept b concept c d concept d e concept f g
i think need string this? how can create string?
the question kinda vague should work need insert multiple values in table, indicate new row.
sample:
insert example (concept, element1, element2) values (concept,a,b), (concept,c,d), (concept,e,f), (concept,g,h);
output:
concept | element1 | element2 // table headers concept | | b concept | c | d concept | e | f //table elements concept | g | h
or here more :)
Comments
Post a Comment