云服务器 数据库语言

-- 创建表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

-- 插入数据
INSERT INTO users (id, name, email) VALUES (1, 'Alice', 'alice@example.com');

-- 查询数据
SELECT * FROM users WHERE id = 1;

// 连接到MongoDB
const { MongoClient } = require('mongodb');
const uri = "your_mongodb_connection_string";
const client = new MongoClient(uri, { useNewUrlParser: true, useUnifiedTopology: true });

async function run() {
    try {
        await client.connect();
        const database = client.db('testdb');
        const collection = database.collection('users');

        // 插入数据
        const user = { name: 'Bob', email: 'bob@example.com' };
        const result = await collection.insertOne(user);
        console.log(`Inserted document with _id: ${result.insertedId}`);

        // 查询数据
        const query = { name: 'Bob' };
        const userDoc = await collection.findOne(query);
        console.log(userDoc);
    } finally {
        await client.close();
    }
}
run().catch(console.dir);