| 類型 | 說明 |
|---|---|
| NULL | 空值 |
| INTEGER | 有符號整數,1-8 字節自適應 |
| REAL | IEEE 754 雙精度浮點數 |
| TEXT | UTF-8/16BE/16LE 文本 |
| BLOB | 二進制原樣存儲 |
CREATE TABLE COMPANY (
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL
);
驗證:.tables、.schema COMPANY
INSERT INTO COMPANY (ID, NAME, AGE, ADDRESS, SALARY)
VALUES (1, 'Paul', 32, 'California', 20000.00);
INSERT INTO COMPANY VALUES (7, 'James', 24, 'Houston', 10000.00);
批量插入:
INSERT INTO COMPANY VALUES
(2, 'Allen', 25, 'Texas', 15000.00),
(3, 'Teddy', 23, 'Norway', 20000.00),
(4, 'Mark', 25, 'Rich-Mond', 65000.00),
(5, 'David', 27, 'Texas', 85000.00),
(6, 'Kim', 22, 'South-Hall', 45000.00);
-- 先插入一條測試行
INSERT INTO COMPANY VALUES (8, 'wirelessqa', 28, 'HZ', 20000.00);
-- 更新
UPDATE COMPANY SET ADDRESS = 'NanJing' WHERE NAME = 'wirelessqa';
-- 驗證
SELECT * FROM COMPANY WHERE NAME = 'wirelessqa';
-- 結果: 8|wirelessqa|28|NanJing|20000.0
DELETE FROM COMPANY WHERE ADDRESS = 'NanJing';
SELECT * FROM COMPANY WHERE ADDRESS = 'NanJing'; -- 空結果
SELECT 4+2, 4-2, 4*2, 4/2, 4%2; -- 6, 2, 8, 2, 0
| 運算符 | 含義 | 示例結果 |
|---|---|---|
| = / == | 等於 | (a=b) 假 |
| != / <> | 不等於 | (a!=b) 真 |
| >, <, >=, <= | 大小比較 | -- |