after MySQL looks up data, for example, the following data is returned after executing a lookup statement:
RowDataPacket {
ID: 1,
issue: "704929",
userName: "",
group: "",
oper: "",
num: "6",
score: "50",
time: 2018-09-20T09:56:39.000Z,
bonusFlag: 0,
bonusScore: "0",
flag: 0 }
what should I do if I want to remove the field name and keep only the data? The fields are removed as follows:
RowDataPacket {
1,
"704929",
"",
"",
"",
"6",
"50",
2018-09-20T09:56:39.000Z,
0,
"0",
0 }
if so, it seems that the data without the field name can only be an array:
//js:
let RowDataPacket = {
ID: 1,
issue: '704929',
userName: '',
group: '',
oper: '',
num: '6',
score: '50',
time: '2018-09-20T09:56:39.000Z',
bonusFlag: 0,
bonusScore: '0',
flag: 0 }
//js
var objArr = [];
Object.keys(RowDataPacket).forEach(function(key){
objArr.push(RowDataPacket[key]);
});
console.log(":",objArr);
:
objArr = [ 1,'704929','','','','6','50','2018-09-20T09:56:39.000Z',0,'0',0]:Object.values();
objArr = Object.values();query results(obj)just take the val outobject is in the form of
key:valyou have a problem with the above request result
as shown in the figure, every time I create data, it returns at a strange time adding this has no effect timezone: +08:00 ...
1 br Nodejs inserts data into the data 2mysqlutf8mb43, the front end uses react+redux, 4. I guess the problem lies in the character encoding here ....
where is there a problem? ...
var a = "12714 " select * from table where id in ${a} Why does this sql return only one piece of data for advice ...
how does Node.js get the value of the out parameter after executing the mysql stored procedure with the out parameter? I want to get the values of the two parameters _ totalcount,_pagecount, but the return value is not in rows. The code is as follows: ...
The sql statement executed by is let getOrder=(userId,orderType)=>{ let _sql=`select remark,goodsNumber,orderlist.goodsSize,goods.goodsName, goods.goodsImgArr from orderlist ,goods where userId="${userId}" and orderType=&quo...
code tables and tag tables are many-to-many relationships code Table model use strict ; module.exports = function(sequelize, DataTypes) { var code = sequelize.define( code , { markdown: DataTypes.TEXT, title:DataTypes.STRING },...
[problem description]: the individual uses vue+axios+node+mysql for development, uses vue as the front end, and node as the server end to connect to MySQL [question]: how to obtain the back-end data required for this page when jumping to a route through...
[problem description]: when the front end uses Vue.js, to modify user information, some modules have common components; when the user enters a module (figure 2), click the Save button to update the database; the backend uses the same SQL (update ...
which orm framework is better for node + koa + mysql. I hope you can let me know if you have used it. Thank you very much ....
< H2 > problem, want to find out a data set similar to Taobao shopping cart < H2 > A user has a shopping cart, there are multiple stores under one shopping cart, and there are multiple items under one store linked table query 1. Check out the shop...
problem description how does koa+mysql, implement batch update and batch insert, realized batch deletions sql id let cartDelectById = (id) => { let sql = `delete from cart where cart_id = ${id};` return query(sql) } ...
above: this is the time in the database sql (?) in addition, my mysql uses the mysql database of esayPHP linked by navicat, and the local computer does not have a mysql database. Will this also have an impact? ...
problem description the foreground uploads the file, and the background uses the fast-csv module to read the file and insert it. I hope it will be returned to the foreground after the insertion is completed, so I adopted promise, but it didn t seem t...
use sequelizejs to control mysql transactions. How to encapsulate or design transactions across methods and service? The framework of application is express + sequelizejs,. In the service layer, it often appears in one method to call other service met...
when you associate with mysql, you can use id to associate, and you can store two tables during the same database operation. Because the primary key id can be self-increasing and is not affected by other factors, the two tables can be associated with id,...
the code is as follows the database is created as follows class HyperParameters(models.Model): graph = models.ForeignKey(Graph) train_times = models.PositiveIntegerField(default=10) save = models.BooleanField(default=True) learnin...
in sequelize-cli, sequelize db:seed:all executes all seeder in the seeders folder. if you only want to execute a certain seeder, such as the 20180906061439-user2.js file, how do you write it on the command line? $ sequelize --help Sequelize CLI...
how can the data generated on one server be shared with other servers? I am now in the background of the program is written in node js, are there any examples or ideas for reference? ...
question: why is the node.js seen on the Internet used to manipulate databases are generally non-relational databases, relational databases (mysql) is rare? ...