Error while running script in SQL

Question

This is my script to ask the user to input data values for each item, now my question is if the first values are

Criminal_ID Last First Street City   State Zip   Phone V_status P_status
1015       Fenter Jim       Chesapeake VA  23320           N      N

and there is no Street or phone listed how do I run this and not get an error. It also says No value needs to be entered at the prompt if it should be set to the DEFAULT column value.

INSERT INTO Criminals 
    VALUES ('&Criminal_ID', '&Last', '&First', '&Street', '&City','&State','&Zip', '&Phone', '&v_status', '&p_status');

japzdivino · Accepted Answer · 2015-09-28 07:20:00Z

5

Here's the INSERT Syntax

    INSERT INTO Criminals (ColName1, ColName2, ColName3... etc)
    VALUES (Value1, Value2, Value3... etc)

Make sure that the number of columns equals the number of values separated by commas.

edited Sep 28, 2015 at 7:20

user330315

answered Sep 28, 2015 at 2:22

japzdivino

1,7463 gold badges17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jarlh · Accepted Answer · 2015-09-28 07:15:50Z

0

Alternative answer, use DEFAULT in values-list:

INSERT INTO Criminals VALUES (Value1, Value2, DEFAULT, Value4, DEFAULT, ...)

answered Sep 28, 2015 at 7:15

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

Collectives™ on Stack Overflow

Error while running script in SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related