← 返回教程列表
🐘 PostgreSQL 教程
常用操作
INSERT INTO users (name, data) VALUES ('张三', '{"age": 20}');
SELECT * FROM users WHERE data->>'age' = '20';
UPDATE users SET name = '李四' WHERE id = 1;
DELETE FROM users WHERE id = 1;INSERT INTO users (name, data) VALUES ('张三', '{"age": 20}');
SELECT * FROM users WHERE data->>'age' = '20';
UPDATE users SET name = '李四' WHERE id = 1;
DELETE FROM users WHERE id = 1;