I have variables containing lists of values I'd like to insert into a table one
row at a time. For example: if I have a variable called "road" containing
three items: Miller lane, Pine street, Wilson blvd. How can I insert each of
the road names in separate columns in my table? Something like:
db eval {insert into myTable VALUES($roads)}
I understand I can split the list, save each road name in a variable, and
insert them by putting them into the table with something like
... VALUES($v1,$v2,$v3)
But I don't want to do that because I have over one hundred columns and don't
want to clutter my code.
Thanks!
________________________________
Disclaimer:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to which they are addressed. If
you are not the intended recipient or have received this email in error please
notify the system manager and destroy this email. Any unauthorized copying,
disclosure or distribution of the material in this e-mail is strictly
forbidden. Please note that any views or opinions presented in this email are
solely those of the author and do not necessarily represent those of the
company. Finally, the recipient should check this email and any attachments for
the presence of viruses. The company accepts no liability for any damage caused
by any virus transmitted by this email.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
