mysql常用命令

创建表：CREATE TABLE table_name (column_name column_type);
删除表：DROP TABLE table_name ;
增：INSERT INTO table_name ( field1, field2,…fieldN )
VALUES
( value1, value2,…valueN );
查：SELECT column_name,column_name
FROM table_name
改：UPDATE table_name SET field1=new-value1, field2=new-value2
删：DELETE FROM table_name [WHERE Clause]

node.js连接mysql

var mysql      = require('mysql');
var connection = mysql.createConnection({

});

connection.connect();

connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results[0].solution);
});