阅读背景:

creating a table and inserting data

来源:互联网 
/** Grocery list: 
Bananas (4)
Peanut Butter (1)
Dark Chocolate Bars (2)
**/

CREATE TABLE groceries (id INTEGER PRIMARY KEY, name TEXT, quantity INTEGER );

INSERT INTO groceries VALUES (1, "Bananas", 4);
INSERT INTO groceries VALUES (2, "Peanut Butter", 1);
INSERT INTO groceries VALUES (3, "Dark chocolate bars", 2);
SELECT * FROM groceries;
/** Grocery list: 
Bananas (4)
Peanut Butte



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: