Skip to content

Instantly share code, notes, and snippets.

@underdown

underdown/sendy.sql

Last active November 14, 2018 00:37
Show Gist options
  • Save underdown/633652328ccdf07d3955cd07a6cd8b0a to your computer and use it in GitHub Desktop.
Save underdown/633652328ccdf07d3955cd07a6cd8b0a to your computer and use it in GitHub Desktop.
Download ZIP
some queries
Raw
sendy.sql
INSERT INTO subscribers (email, name, list, confirmed)
SELECT email, name, "1", "1" FROM tmp1;
UPDATE `subscribers` SET `list`=3, `confirmed`=1 WHERE 1
INSERT INTO subscribers (email, name, list, confirmed)
SELECT email, name, "1", "1" FROM tmp1
UPDATE `subscribers` SET `bounced` = '1' WHERE `subscribers`.`id` < 150000 AND `subscribers`.`id` >127000
UPDATE `subscribers` SET `unsubscribed` = '1' WHERE `subscribers`.`id` < 120000 AND `subscribers`.`id` >126584
Update `subscribers` SET `timestamp` =
UNIX_TIMESTAMP('2018-05-30 14:53:27') + FLOOR(0 + (RAND() * 6666666))
WHERE `subscribers`.`id` < 120000 AND `subscribers`.`id` >126584
UPDATE `subscribers` set timestamp, join_date =
unix_timestamp('1527404723')
+floor(rand()* (`1555200`) ) WHERE `timestamp` = '1542145878'
UPDATE `subscribers` set `join_date` =
unix_timestamp("2018-05-02 08:49:43")
+floor(rand()* ("1555200") ) WHERE `timestamp` = '1542145878'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment