快递单表设计及SQL语句示例

快递单表设计如下：

表名：express_order

字段：

• id: 快递单号，主键，自增
• sender_name: 寄件人姓名
• sender_phone: 寄件人电话
• sender_address: 寄件人地址
• receiver_name: 收件人姓名
• receiver_phone: 收件人电话
• receiver_address: 收件人地址
• weight: 快递重量
• price: 快递价格
• create_time: 创建时间
• update_time: 更新时间

SQL语句如下：

创建表：

CREATE TABLE express_order (
    id INT AUTO_INCREMENT PRIMARY KEY,
    sender_name VARCHAR(50),
    sender_phone VARCHAR(20),
    sender_address VARCHAR(100),
    receiver_name VARCHAR(50),
    receiver_phone VARCHAR(20),
    receiver_address VARCHAR(100),
    weight DECIMAL(5, 2),
    price DECIMAL(8, 2),
    create_time DATETIME,
    update_time DATETIME
);

插入数据：

INSERT INTO express_order (sender_name, sender_phone, sender_address, receiver_name, receiver_phone, receiver_address, weight, price, create_time, update_time)
VALUES ('John Doe', '1234567890', '123 Main St, City', 'Jane Smith', '0987654321', '456 Oak St, City', 2.5, 10.99, NOW(), NOW());

查询数据：

SELECT * FROM express_order;

更新数据：

UPDATE express_order
SET price = 12.99, update_time = NOW()
WHERE id = 1;

删除数据：

DELETE FROM express_order WHERE id = 1;