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

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -