mysql nosql应用

-- 创建表
CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL
);

-- 插入数据
INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');

-- 查询数据
SELECT * FROM users WHERE email = 'john@example.com';

// 连接到MongoDB数据库
const MongoClient = require('mongodb').MongoClient;
const url = 'mongodb://localhost:27017';
const dbName = 'myproject';

MongoClient.connect(url, function(err, client) {
    if (err) throw err;

    const db = client.db(dbName);

    // 插入数据
    const myobj = { name: "John Doe", email: "john@example.com" };
    db.collection("users").insertOne(myobj, function(err, res) {
        if (err) throw err;
        console.log("文档插入成功");
        client.close();
    });

    // 查询数据
    db.collection("users").findOne({ email: "john@example.com" }, function(err, result) {
        if (err) throw err;
        console.log(result);
        client.close();
    });
});