1SELECT 1,2,3 INTO OUTFILE 'MYSQL_TMP_DIR/regular'; 2ERROR HY000: File 'MYSQL_TMP_DIR/regular' already exists 3SELECT 1,2,3 INTO OUTFILE 'MYSQL_TMP_DIR/fifo'; 41 2 3 5CREATE PROCEDURE p1() BEGIN WHILE ISNULL(LOAD_FILE('MYSQL_TMP_DIR/trigger')) DO SELECT SLEEP(1); END WHILE; SELECT 1,2,3 INTO OUTFILE 'MYSQL_TMP_DIR/socket'; END// 6CALL p1(); 7DROP PROCEDURE p1; 8SELECT 1,2,3 INTO DUMPFILE 'MYSQL_TMP_DIR/regular'; 9SELECT 1,2,3 INTO DUMPFILE 'MYSQL_TMP_DIR/fifo'; 10123CREATE PROCEDURE p1() BEGIN WHILE ISNULL(LOAD_FILE('MYSQL_TMP_DIR/trigger')) DO SELECT SLEEP(1); END WHILE; SELECT 1,2,3 INTO DUMPFILE 'MYSQL_TMP_DIR/socket'; END// 11CALL p1(); 12DROP PROCEDURE p1; 13