Member Avatar for london-G

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
  • 180 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by stultuske
Member Avatar for london-G

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

Member Avatar for JamesCherrill

Is this a Java question? You may be in the wrong forum. Try the databases forum

Member Avatar for london-G

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

Member Avatar for stultuske

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.