Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

insert multiple values into a single column

 
Romeo Ranjan
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I want to insert eight values(rows) into a single column of my table.How do i do that??

This INSERT statement allows to insert a single record or multiple records into a table.


but what i want is


How do i go about doing this??
Trying this format


or


gives me the following error.


 
Sona Patel
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranjan,

You will have to write different insert statements for all column values as below..

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic