Insert > 2499

From: The Magnet <art_at_unsu.com>
Date: Wed, 21 Jul 2010 14:23:13 -0700 (PDT)
Message-ID: <ba42132f-7e8b-446f-bf8b-b690b481971d_at_u26g2000yqu.googlegroups.com>

I have some insert statements with values that are > 2500 characters. I cannot make it a .CSV because the text has commas in it. It is a bunch of HTML. Any suggestions?

Example:

INSERT INTO MESSAGES (message_id, sec_id, variables, name, body, created, last_changed, created_by, changed_by, status) VALUES(5, 5, '{ADID}', 'Premium Login Default $99', '<table border="0" cellspacing="0" cellpadding="0" width="575" align="center">\r\n <tbody>\r\n <tr>\r\n <td style="padding-bottom: 8px; line-height: 18px; padding-left: 8px; padding-right: 8px; font-size: 14px; padding-top: 8px">\r\n <p><style type="text/css">\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<!--\r\n.Headline {\r\nfontfamily:

Helvetica, sans-serif;\r\n	font-size: 26px;\r\n	font-style:
normal;\r\n	line-height: 32px;\r\n	font-weight: bold;\r\n	color:

#000000;\r\n}\r\n--></style><span

class="Headline"><script>utmx_section("BODY_HEADLINE")</script>Get
Free Access<br />\r\n            to Premium Now </span></p>\r


\n            <p>Now you can unlock the Premium icon<img alt="ZP"

width="18" height="14" src="/images/premium_small.gif" />, and

discover its secrets, including the best stocks to buy and sell for free.&nbsp; Premium lets you apply the full force of Rank earnings information even in this trying market.</p>\r\n <p>When you subscribe to Premium for 30 days free, you&rsquo;ll have an entire month to:</p>\r\n <ul>\r\n
<li><strong>Buy<strong> the best stocks</strong></strong> with our list of #1 Rank Strong Buys. Over 20 years, it&nbsp;triples the S&amp;P 500, averaging an amazing +28% yearly gain.<br />\r
\n &nbsp;</li>\r\n <li
class="mktgcopy"><strong>Sell<strong> the worst stocks</strong></ strong> after scanning the list of #5 Rank Strong Sells.<br />\r
\n &nbsp;</li>\r\n

<li><strong>Target<strong> today''s hottest industries</strong></ strong> with daily updates of Industry Rank.<br />\r\n

&nbsp;</li>\r\n                <li><strong>Be<strong> alerted</
strong></strong> to fast-breaking buy and sell opportunities.<br />\r


\n                &nbsp;</li>\r\n                <li><strong>Get <em>

7 Best Stocks for the Next 30 Days. </em></strong>It''s packed with picks, facts, and stats that are expected to blast off in the days ahead.</li>\r\n </ul>\r\n <p>This free trial offer may be withdrawn at anytime. So please sign-up below right now.</

p>\r\n            <script>utmx_section("FREE_TRIAL")</script><center>\r


\n            <table border="0" cellspacing="0" cellpadding="0"

width="300">\r\n                <tbody>\r\n                    <tr>\r


\n                        <td align="center"><a href="https://

www.zk.com/registration/premium/trial/&#63;adid={ADID}"><img border="0" hspace="5" alt="Free Trial" width="114" height="55" src="https://woas.zk.com/adv/images/zp_freetrialBtn.gif" /></a></td>\r
\n <td align="center"><a href="https://
www.zk.com/registration/premium_more_info.php&#63;adid={ADID}"><img border="0" hspace="5" alt="Learn More" width="114" height="55" src="https://woas.zk.com/adv/images/zp_learnmoreBtn.gif" /></a></td>\r
\n <!--\r\n <td
align="center"><a href="https://www.zk.com/registration/ premium_more_info.php&#63;adid={ADID}"><img border="0" hspace="5" alt="Learn More" width="114" height="55" src="https://woas.zk.com/adv/ images/zp_learnmoreBtn.gif" /></a></td>\r\n -->\r
\n </tr>\r\n </tbody>\r\n
</table>\r\n </center></td>\r\n </tr>\r\n </tbody>
\r\n</table>', '2005-11-21 12:17:10', '2010-03-17 14:20:34', 'joseph',
'fabre', 'ONLINE'); Received on Wed Jul 21 2010 - 16:23:13 CDT