| Ravi Malghan 2006-02-28, 8:28 pm |
| Hi: My database is mysql 4.1.14-standard. I have a
blob type field in a table1 with mutlple attributes
together in the field as shown below
table1.field1 value for a record is "abc=2 def=4
ghi=10"
I have table2 which has fields abc, def and ghi. I
want to be able to parse the table1.field1 and insert
values 2 for table2.abc, 4 for table2.def and 10 for
table2.ghi.
1. Is stored procedure the only way to do this?
2. 4.x does not support stored procedures. If this is
correct, is there any other way to accomplish this?
3. how do I extract values from a field based on a
pattern? Just looking for some pointers to get started
on this.
Thanks
Ravi
____________________
____________________
__________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|