Image insertion from SQL info

Posted by user528057 on Stack Overflow See other posts from Stack Overflow or by user528057
Published on 2010-12-22T10:40:25Z Indexed on 2010/12/22 10:54 UTC
Read the original article Hit count: 366

Filed under:
|

What does 'howard.jpg' do in the sql statement below & how do I insert the image into my android app?

CREATE TABLE IF NOT EXISTS employee ( 
    _id INTEGER PRIMARY KEY AUTOINCREMENT, 
    firstName VARCHAR(50), 
    lastName VARCHAR(50), 
    title VARCHAR(50), 
    department VARCHAR(50), 
    managerId INTEGER, 
    city VARCHAR(50), 
    officePhone VARCHAR(30), 
    cellPhone VARCHAR(30),  
    email VARCHAR(30), 
    picture VARCHAR(200)) 



    INSERT INTO employee VALUES(1,'Ryan','Howard','Vice President, North East', 
'Management', NULL, 'Scranton','570-999-8888','570-999-8887','[email protected]','howard.jpg')

© Stack Overflow or respective owner

Related posts about android

Related posts about sqlite