Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

LOAD_FILE(file_name)

The file size must be less than max_allowed_packet bytes. If the file does not exist or cannot be read, the function returns NULL. UPDATE myTable SET text_col=LOAD_FILE('/tmp/picture');