Stored procedure showing only 1 result

Question

Trying to make a stored procedure using sql and phpMyAdmin. Here's what I got:

And that is the result:

Why this proc shows (or returns?) me only 1 row? There must be more than one result, for sure (I've tried to write a simply SELECT * FROM motherboards statement, result is the same, only 1 row but my table has some about 50 rows). How could I get all results of this proc? Thanks in advance!

no, there are more than one, for sure, I've tried to write a simply SELECT * FROM motherboards statement, result is the same, only 1 row, but there are some about 50 rows in my table — coldembrace, Oct 20 '17 at 19:06
the example you just gave suggests there is only one row in the table, why do you think there is more? — Hogan, Oct 20 '17 at 19:09
and as I said before, I get only 1 row independently of a query (even select * gives me only 1 result) — coldembrace, Oct 20 '17 at 19:13
@Burning I guess that it is similiar to https://stackoverflow.com/a/36424445/5070879 . Ie. one of letter is `Cyrillic` but glyph is the same as latin. — Lukasz Szozda, Oct 20 '17 at 19:13
Please try to copy one of values that does not match and paste here. — Lukasz Szozda, Oct 20 '17 at 19:15
@lad2025 my motherboards.full_name is also varchar(50), so I believe, that the problem isn't in there — coldembrace, Oct 20 '17 at 19:17
Found out that the problem is connected with IN paramentr, without the parametr it works perfect. — coldembrace, Oct 21 '17 at 07:41

score 0 · Answer 1 · answered Oct 21 '17 at 07:53

0

When I've tried to call that procedure in php I got expected result, so, I believe that was just a bug in myPhpAdmin.

answered Oct 21 '17 at 07:53

coldembrace

549
8
19

. . You should probably delete the question. – Gordon Linoff Oct 21 '17 at 19:13

Stored procedure showing only 1 result

1 Answers1