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
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