使用”CREATE TABLE”创建表

首先我们创建一个customers的表

var mysql = require(mysql);var con = mysql.createConnection({   host: "localhost",   user: "yourusername",   password: "yourpassword",   database: "mydb" });con.connect(function(err) {   if (err) throw err;   console.log("Connected!");   var sql = "CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))";   con.query(sql, function (err, result) {     if (err) throw err;     console.log("Table created");   }); });

保存文件名”demo_create_table.js” 然后再运行

node demo_create_table.js

如果正确会出现