You need to insert multiple records, otherwise you won't be able to track message delivery for each recipient.
You need to form query for insertion or use LOAD FILE (which is faster than regular INSERT). 2012/11/20 Amin Mukhaimer <[email protected]> > Would this do the trick ?**** > > ** ** > > INSERT INTO example**** > > (example_id, name, value, other_value)**** > > VALUES**** > > (1, 'Name 1', 'Value 1', 'Other 1'),**** > > (2, 'Name 2', 'Value 2', 'Other 2'),**** > > (3, 'Name 3', 'Value 3', 'Other 3'),**** > > (4, 'Name 4', 'Value 4', 'Other 4');**** > > ** ** > > ** ** > > ** ** > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *alok srivastava > *Sent:* Tuesday, November 20, 2012 2:16 PM > *To:* [email protected] > *Subject:* Same message to multiple numbers using send_sms and sent_sms > table in single hit**** > > ** ** > > Dear list > i want to send same message to multiple numbers using send_sms table of > sqlbox, for that i have to insert separate records in send_sms table for > every number. Is there any way to send same message to multiple numbers on > single hit or insertion. > plz help. > thank you. > > regards > abhi**** >
