mysql数据库溢出

-- 创建表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    bio TEXT
);

-- 插入数据
INSERT INTO users (name, bio) VALUES ('John Doe', 'A very long text...');

-- 检查bio字段的长度
SELECT LENGTH(bio) AS bio_length FROM users WHERE id = 1;

ALTER TABLE users MODIFY COLUMN bio TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 创建一个新的表来存储长文本
CREATE TABLE user_bio (
    user_id INT,
    bio TEXT,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

-- 将长文本移动到新表
INSERT INTO user_bio (user_id, bio) SELECT id, bio FROM users WHERE LENGTH(bio) > 65535;

-- 清空原表中的长文本
UPDATE users SET bio = NULL WHERE LENGTH(bio) > 65535;