mysql>mysql> delimiter $$mysql>mysql> CREATE PROCEDURE filesize(in_file_name VARCHAR(128)) -> -> BEGIN -> DECLARE mytext TEXT; -> SET mytext=LOAD_FILE(in_file_name); -> SELECT in_file_name||' contains '||length(mytext)||' bytes' -> AS output; -> END$$Query OK, 0 rows affected (0.00 sec)mysql>mysql> delimiter ;mysql> call filesize("a.txt");+--------+| output |+--------+| NULL |+--------+1 row in set (0.00 sec)Query OK, 0 rows affected, 2 warnings (0.00 sec)mysql> drop procedure filesize;Query OK, 0 rows affected (0.00 sec)mysql>mysql>
Name (required)
email (will not be published) (required)
Website