Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting 5 instead of 4 Results back (eg) (MySQL)

 
Thomas Beiganz
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,

I hope this is the right place for my question.

I use a MySQL Database 5.5.22 for a WebApp.



That is my Query and this is my Query String



And the statement works, but I do get a weird output
Item1
Item2
Item3
Item4
[] <---- This is what i meant.

And I don't know from where it comes.



This is the output from MySQL Workbench.

Thanks in advance for you help.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
is id a mandatory column on your database? as it looks like row5 actually exists in the database.

If it isn't add mandatory/ not null to id and see if it will let you.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would assume the fifth row displayed in MySQL Workbench is simply a placeholder where you can enter values that will become a new row, after you're done editing them.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Martin Vajsar wrote:I would assume the fifth row displayed in MySQL Workbench is simply a placeholder where you can enter values that will become a new row, after you're done editing them.

I would also assume that, but his result set loop looks correct to me, so just double checking really.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic