sql数据库添加网站

-- 创建数据库
CREATE DATABASE website_db;

-- 使用数据库
USE website_db;

-- 创建表
CREATE TABLE websites (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    url VARCHAR(255) NOT NULL,
    description TEXT
);

-- 插入示例数据
INSERT INTO websites (name, url, description) VALUES
('Google', 'https://www.google.com', 'A popular search engine'),
('GitHub', 'https://github.com', 'A code hosting platform for version control');

-- 查询所有网站信息
SELECT * FROM websites;

-- 使用INSERT IGNORE
INSERT IGNORE INTO websites (name, url, description) VALUES ('Google', 'https://www.google.com', 'A popular search engine');

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO websites (id, name, url, description) VALUES (1, 'Google', 'https://www.google.com', 'A popular search engine')
ON DUPLICATE KEY UPDATE name='Google', url='https://www.google.com', description='A popular search engine';

-- 增加索引
CREATE INDEX idx_name ON websites(name);

-- 分页查询
SELECT * FROM websites LIMIT 10 OFFSET 20;