binary |
| character_set_results| utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--++
Thanks,
Magne Westlie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
assemble
the query in the app layer.
>Also, I was moving the query into a stored procedure because I
wanted
to make
>the request fast, and the concatenating and string handling takes
some
of that away.
Unfortunately MySQL sprocs do not yet deliver this advantage.
PB
-
Magne We
ons of MySQL is to assemble
the query in the app layer.
>Also, I was moving the query into a stored procedure because I wanted
to make
>the request fast, and the concatenating and string handling takes some
of that away.
Unfortunately MySQL sprocs do not yet deliver this advantage.
PB
Hi,
Thanks a lot Peter, that was useful and it worked fine. The only problem
is that the query I actually want to use this in, is a 100 line query
with lots of arguments. I don't feel to good about creating it into a
bunch of strings (16) that I have to concatenate with the variables
inbetwee
g like this:
CREATE PROCEDURE get_users(uids "LIST") -- what type to use here?
BEGIN
SELECT * FROM user_test WHERE user_id IN uids;
END::
Thanks,
Magne Westlie
Working test code for getting one user only:
--
DROP TABLE IF EXISTS user_test;
CREA
