Surprise! We've been running on hardware provided by BuyVM for a few months and wanted to show them a little appreciation.
Running a paste site comes with unique challenges, ones that aren't always obvious and hard to control. As such, BuyVM offered us a home where we could worry less about the hosting side of things and focus on maintaining a clean and useful service! Go check them out and show them some love!
Submitted on September 3, 2013 at 09:52 AM

Download - Report

Section 1 (Text)

123 
mysql> INSERT INTO list_email   (fname, lname, email_addr) SELECT ins.* FROM   ( SELECT 'bob' AS fname,             'schmoe' AS lname,             '[email protected]' AS email_addr     FROM dual   UNION ALL     SELECT 'mary', 'lamb', '[email protected]'     FROM dual   ) AS ins WHERE NOT EXISTS       ( SELECT 1          FROM list_email AS e          WHERE e.email_addr = ins.email_addr       )   AND NOT EXISTS       ( SELECT 1         FROM list_no_email AS ne          WHERE ne.email_addr = ins.email_addr       );
Query OK, 1 row affected (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0