Styjun

Maximum likelihood parameters deviate from posterior distributions

What is the word for reserving something for yourself before others do?

Why do I get two different answers for this counting problem?

Do I have a twin with permutated remainders?

Filter any system log file by date or date range

NMaximize is not converging to a solution

Two films in a tank, only one comes out with a development error – why?

What defenses are there against being summoned by the Gate spell?

Important Resources for Dark Age Civilizations?

Convert two switches to a dual stack, and add outlet - possible here?

Why are electrically insulating heatsinks so rare? Is it just cost?

Why is 150k or 200k jobs considered good when there's 300k+ births a month?

Operational amplifier as a comparator at high frequency

RSA: Danger of using p to create q

Is it inappropriate for a student to attend their mentor's dissertation defense?

What's that red-plus icon near a text?

Why is Minecraft giving an OpenGL error?

Uncaught TypeError: 'set' on proxy: trap returned falsish for property Name

Horror movie about a virus at the prom; beginning and end are stylized as a cartoon

Can you really stack all of this on an Opportunity Attack?

When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?

What's the point of deactivating Num Lock on login screens?

What doth I be?

"You are your self first supporter", a more proper way to say it

MySQL Node.js INSERT INTO statement with SELECT DISTINCT and defined VALUES

Insert into … values ( SELECT … FROM … )Which MySQL data type to use for storing boolean valuesHow can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL?Finding duplicate values in MySQLHow to 'insert if not exists' in MySQL?Insert into a MySQL table or update if existsMySQL with Node.js'IF' in 'SELECT' statement - choose output value based on column valuesSQL select only rows with max value on a columnReference - What does this error mean in PHP?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

-1

I'm new to stack overflow but I'll just get straight to the point.

I am trying to run SQL queries in Node.js and am pulling request data from an incoming text message. The message is then parsed for the communication date also known as 'comm_time'. The goal is to insert a SQL statement using two columns selected from another table and populate the other necessary fields with defined values. Note that the '?' value allows me to use the timestamp of the incoming message with body-parser.

`INSERT INTO supermsp.communication (contact_id, project_id, create_user, comm_time, comm_type, direction)
 SELECT DISTINCT contact_id, project_id, '13', ?, '99', '1' FROM contacts_meta JOIN contacts
 ON contact_id = contacts.id WHERE meta_id IN (9, 11) AND VALUE = '7854228463';`

mysql sql node.js

share|improve this question

asked Mar 21 at 22:42

ItsTnTgItsTnTg

1

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  What is your question exactly ?
  
  – WebRookie
  Mar 21 at 22:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry for the confusion. I'm inserting only contact_id and project_id from the contacts_meta table and can't insert the other columns because those are defined outside of the contacts_meta table. I don't know if this needs to be broken down to two INSERT INTOs or something else to insert data from two sources.
  
  – ItsTnTg
  Mar 22 at 18:28
  

  
  
  
  

add a comment | 

-1

I'm new to stack overflow but I'll just get straight to the point.

I am trying to run SQL queries in Node.js and am pulling request data from an incoming text message. The message is then parsed for the communication date also known as 'comm_time'. The goal is to insert a SQL statement using two columns selected from another table and populate the other necessary fields with defined values. Note that the '?' value allows me to use the timestamp of the incoming message with body-parser.

`INSERT INTO supermsp.communication (contact_id, project_id, create_user, comm_time, comm_type, direction)
 SELECT DISTINCT contact_id, project_id, '13', ?, '99', '1' FROM contacts_meta JOIN contacts
 ON contact_id = contacts.id WHERE meta_id IN (9, 11) AND VALUE = '7854228463';`

mysql sql node.js

share|improve this question

asked Mar 21 at 22:42

ItsTnTgItsTnTg

1

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  What is your question exactly ?
  
  – WebRookie
  Mar 21 at 22:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry for the confusion. I'm inserting only contact_id and project_id from the contacts_meta table and can't insert the other columns because those are defined outside of the contacts_meta table. I don't know if this needs to be broken down to two INSERT INTOs or something else to insert data from two sources.
  
  – ItsTnTg
  Mar 22 at 18:28
  

  
  
  
  

add a comment | 

I'm new to stack overflow but I'll just get straight to the point.

I am trying to run SQL queries in Node.js and am pulling request data from an incoming text message. The message is then parsed for the communication date also known as 'comm_time'. The goal is to insert a SQL statement using two columns selected from another table and populate the other necessary fields with defined values. Note that the '?' value allows me to use the timestamp of the incoming message with body-parser.

`INSERT INTO supermsp.communication (contact_id, project_id, create_user, comm_time, comm_type, direction)
 SELECT DISTINCT contact_id, project_id, '13', ?, '99', '1' FROM contacts_meta JOIN contacts
 ON contact_id = contacts.id WHERE meta_id IN (9, 11) AND VALUE = '7854228463';`

mysql sql node.js

share|improve this question

asked Mar 21 at 22:42

ItsTnTgItsTnTg

1

`INSERT INTO supermsp.communication (contact_id, project_id, create_user, comm_time, comm_type, direction)
 SELECT DISTINCT contact_id, project_id, '13', ?, '99', '1' FROM contacts_meta JOIN contacts
 ON contact_id = contacts.id WHERE meta_id IN (9, 11) AND VALUE = '7854228463';`

share|improve this question

asked Mar 21 at 22:42

ItsTnTgItsTnTg

1

share|improve this question

asked Mar 21 at 22:42

ItsTnTgItsTnTg

1

asked Mar 21 at 22:42

ItsTnTgItsTnTg

1

asked Mar 21 at 22:42

ItsTnTgItsTnTg

1