JSON 和 SQL 之间的区别

JSON和SQL之间的区别

python
import json
# 创建一个JSON对象
data = {
    "name": "John",
    "age": 30,
    "city": "New York"
}
# 将JSON对象转换为字符串
json_str = json.dumps(data)
# 将JSON字符串转换为对象
json_obj = json.loads(json_str)
# 访问JSON对象的字段
print(json_obj["name"])
print(json_obj["age"])
print(json_obj["city"])

sql
-- 创建一个表格
CREATE TABLE students (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT,
    city VARCHAR(50)
);
-- 插入数据
INSERT INTO students (id, name, age, city)
VALUES (1, 'John', 30, 'New York'),
       (2, 'Alice', 25, 'London'),
       (3, 'Bob', 35, 'Paris');
-- 查询数据
SELECT name, age, city
FROM students
WHERE age > 30;