create a table employer in sql in javascript

index.tsx
// require the mysql package
const mysql = require('mysql');

// create a connection to the database
const connection = mysql.createConnection({
  host: 'localhost', // change this to your MySQL server IP or hostname
  user: 'root',      // change this to your MySQL username
  password: 'secret', // change this to your MySQL password
  database: 'mydb', // change this to your MySQL database name
});

// define the SQL query to create the employer table
const createEmployerTableQuery = `
CREATE TABLE employer (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL,
  phone VARCHAR(20),
  address VARCHAR(255),
  salary DECIMAL(10, 2)
)
`;

// execute the query to create the employer table
connection.query(createEmployerTableQuery, (err, results, fields) => {
  if (err) {
    console.error(err);
  } else {
    console.log('Employer table created successfully.');
  }
});

// close the database connection
connection.end();
975 chars
35 lines