How to do this??
-
Hi all, I am totally new to mysql and I have to do something like this. I am sending this '3$4$10$5' string to stored procedure in mysql. What I want is to insert this values into a table like this: 1 1 3 1 1 4 1 1 10 1 1 5 I have to split the above string and insert a record one by one into the table. Can someone please help me. Thanks in advance.
-
Hi all, I am totally new to mysql and I have to do something like this. I am sending this '3$4$10$5' string to stored procedure in mysql. What I want is to insert this values into a table like this: 1 1 3 1 1 4 1 1 10 1 1 5 I have to split the above string and insert a record one by one into the table. Can someone please help me. Thanks in advance.
use the replace function EX: select replace('1$2$3$','$',' ');
Rajesh B --> A Poor Workman Blames His Tools <--
-
use the replace function EX: select replace('1$2$3$','$',' ');
Rajesh B --> A Poor Workman Blames His Tools <--
Thanks for the reply. What I want is to insert multiple records. This is very small data but if data is huge then how can I do this. ike in SQL we can send XML to stroed procedure and then parse it in the stored procedure and insert the records. Can you please tell me how to do this in MYSQL? Thanks again.