0

Hello,
can you please help me to see what's wrong?

INSERT INTO jobs (priority, date, deadline, material, status) VALUES (?, ?,?,?,? ) select customerID from Customer where CustomerID =?"
3
Contributors
4
Replies
6
Views
5 Years
Discussion Span
Last Post by stultuske
0

i have two table linked by a foreign key, however I don't know how to insert data :(

0

I am implementing the program in java I am also using mysql(in netbeans)

0

which still doesn't make it java, this is an sql matter.

jobs (priority, date, deadline, material, status) VALUES (?, ?,?,?,? ) select customerID from Customer where CustomerID =?"

seems to me you have two sql statements and try to run them as one.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.