Hi Guys : I wanted to insert a hashtable of name value pairs into mysql.
I know one way of doing this is to do
insert into myTable values (1,'jay'), (2,'jim') , etc...
but Id rather have a mysql stored procedure handle the creation
of this statement (so that
I can avoid having sql in my
java code).
Any ideas for a work around ?
Ideally, Id like to insert as a
String and have an SP handle the parsing...
call SP_param_insert('1=jay;2=jim;')