Answers for "add image in mysql database"

SQL
0

add image in mysql database

CREATE TABLE 'sample'.'picture' ( 
'idpicture' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, 
'caption' VARCHAR(45) NOT NULL, 
'img' LONGBLOB NOT NULL, 
 PRIMARY KEY('idpicture')) TYPE = InnoDB;
Posted by: Guest on April-28-2022
0

add image in mysql database

INSERT INTO xx_BLOB(ID,IMAGE) VALUES(1,LOAD_FILE('E:/Images/jack.jpg'));
Posted by: Guest on April-28-2022

Code answers related to "add image in mysql database"

Code answers related to "SQL"

Browse Popular Code Answers by Language