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: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of alok srivastava Sent: Tuesday, November 20, 2012 2:16 PM To: users@kannel.org 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