回答編集履歴
1
INSERT追加
test
CHANGED
|
@@ -30,11 +30,23 @@
|
|
|
30
30
|
|
|
31
31
|
|
|
32
32
|
|
|
33
|
-
alasql('ALTER TABLE sample ADD COLUMN adding');
|
|
33
|
+
alasql('ALTER TABLE sample ADD COLUMN adding STRING');
|
|
34
34
|
|
|
35
35
|
console.log(alasql('SELECT * FROM sample;'));
|
|
36
36
|
|
|
37
37
|
// [{id: 1, word: "W1-1", word2: "W1-2", word3: "W1-3", adding: undefined}, {id: 2, word: "W2-1", word2: "W2-2", word3: "W2-3", adding: undefined}]
|
|
38
|
+
|
|
39
|
+
console.log(alasql('SHOW COLUMNS FROM sample;'));
|
|
40
|
+
|
|
41
|
+
// [{columnid: "id", dbtypeid: "INT", dbsize: undefined}, {columnid: "word", dbtypeid: "STRING", dbsize: undefined}, {columnid: "word2", dbtypeid: "STRING", dbsize: undefined}, {columnid: "word3", dbtypeid: "STRING", dbsize: undefined}, {columnid: "adding", dbtypeid: undefined, dbsize: undefined}]
|
|
42
|
+
|
|
43
|
+
|
|
44
|
+
|
|
45
|
+
alasql("INSERT INTO sample VALUES (3, 'W3-1', 'W3-2', 'W3-3', 'a');");
|
|
46
|
+
|
|
47
|
+
console.log(alasql('SELECT * FROM sample;'));
|
|
48
|
+
|
|
49
|
+
// [{id: 1, word: "W1-1", word2: "W1-2", word3: "W1-3", adding: undefined}, {id: 2, word: "W2-1", word2: "W2-2", word3: "W2-3", adding: undefined}, {id: 3, word: "W3-1", word2: "W3-2", word3: "W3-3", adding: "a"}]
|
|
38
50
|
|
|
39
51
|
console.log(alasql('SHOW COLUMNS FROM sample;'));
|
|
40
52
|
|