LOCK TABLES X WRITE;
SELECT foo FROM Y;
INSERT INTO X (queries) VALUES ('SELECT foo FROM Y');
UNLOCK TABLES;