创建表
CREATE TABLE IF NOT EXISTS `material_tracking`(
`data_id` INT UNSIGNED AUTO_INCREMENT,
`inputMan1` VARCHAR(20) ,
`craftStage1` VARCHAR(100) ,
`craftState1` VARCHAR(40) ,
`procedure1` VARCHAR(40),
`mark1` VARCHAR(40) ,
`upImage1` VARCHAR(40) ,
PRIMARY KEY ( `data_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
删除表
DROP TABLE material_tracking;
删除表中的数据
DELETE FROM material_tracking WHERE data_id=3;
这个可以删除一行数据
如果没有WHERE,则删除表中所有数据
根据前台传回来的表单用node.js插入数据
var sqlconnection = mysql.createConnection({
host: '192.168.1.25',
user: 'a',
password: 'a',
database: 'a'
});
sqlconnection.connect();
var addsql = 'insert into material_tracking(inputMan1,craftStage1,craftState1,procedure1,mark1,upImage1) values(?,?,?,?,?,?)';
var addsqlparam = [req.query.inputMan1, req.query.craftStage1, req.query.craftState1, req.query.procedure1, req.query.mark1, req.query.upImage1];
sqlconnection.query(addsql, addsqlparam, function (err, result) {
if (err) {
res.send('[INSERT ERROR] - ', err.message);
return;
}
console.log('new Material-tracking:', addsqlparam);
res.send('插入数据成功');
});