how to create mysql schema in nodejs

Question

I am using nodejs, express framework and mysql for my database. I would like to know how can I replicate this mongoose code using mysql. I cannot find a way to write my sql schema in a nodejs file. Do I have to use workbench for this? Thanks!

var mongoose = require('mongoose');

var userSchema = mongoose.Schema({
    local: {
            username: String,
            password: String
         }
 });

module.exports = mongoose.model('User', userSchema);

check this: blog.ragingflame.co.za/2014/7/21/using-nodejs-with-mysql — malyy
– malyy, Commented Dec 2, 2015 at 9:53
One thing I don't really understand: why are you using Mongoose? If you enter Mongoose's site it clearly says: mongoose: elegant mongodb object modeling for node.js — charliebrownie
– charliebrownie, Commented Dec 2, 2015 at 10:14
@charliebrownie i was following a tutorial series where he used this code. But I like mysql better so thats why i was looking for an alternative. — Safwan Ull Karim
– Safwan Ull Karim, Commented Dec 2, 2015 at 12:36
Oh, all right, I thought you were trying to use mongoose on a MySQL database. In this case, you will have to use a MySQL driver like this one (node-mysql). — charliebrownie
– charliebrownie, Commented Dec 2, 2015 at 13:00

President James K. Polk · Accepted Answer · 2025-02-14 02:50:26Z

10

You can use any of:

bookshelf
knex
objection
form
sequelize

See this comparison between them:

This tutorial may help you to use sequelize: Creating a Role-Based User Authentication System with Angular, Express and MySQL

edited Feb 14 at 2:50

President James K. Polk

42.2k34 gold badges113 silver badges149 bronze badges

answered Sep 15, 2017 at 19:13

MAN

4751 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MD JULHAS HOSSAIN Over a year ago

its not working when I click that sequelize link.

MAN Over a year ago

This is Old training but if you want, can read it in: hisk.io/…

Programming With KhiZi · Accepted Answer · 2024-02-25 16:02:03Z

MySQL does not have a built-in schema definition language like Mongoose, so you'll have to create tables manually using SQL queries.

note must require mysql2 at top and install it npm i mysql2 : const mysql = require('mysql2/promise');

Step:01 Create a pool connection

const pool = mysql.createPool({
host: 'localhost',
user: 'root',
password: 'password',
database: 'your_database_name'
});

Step:02 Function to create user table

async function createUserTable() {
const connection = await 
pool.getConnection();
try {
    // Create user table
    await connection.query(`
        CREATE TABLE IF NOT EXISTS users (
            id INT AUTO_INCREMENT PRIMARY KEY,
            username VARCHAR(255) NOT NULL,
            password VARCHAR(255) NOT NULL
        )
    `);
    console.log('User table created successfully');
} catch (error) {
    console.error('Error creating user table:', error);
} finally {
    connection.release();
}

}

Step:03 Call the function to create the user table

createUserTable();

Collectives™ on Stack Overflow

how to create mysql schema in nodejs

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related