[SQL] Refer to another field value to affect a new one in MySQL w/Node.js

thanks for reading. I have a table with 3 fields, one is the ID, which autoincrements and I can´t access it from my Node.js server since it's added by MySql. Another field contains a string, and the last field should be the sum of the 3 first letters of the string field, added to the id. The thing is, when I do my query I can't just add them up because the id doesn´t exist until the query is sent to the DB. What should I do? It'd be such an inconvenience to handle the ID autoincrement from the API. Thanks for your time!

Continue reading...