sql – Only reading one statement from multiple insert statements
Your PhoneNumber
column appears to be using the int
data type, which has a max value of 2147483647. All but your 2nd insert statement have a number larger than this. You should change the data type to one that will accept those numbers, such as bigint
. However int/bigint is the wrong datatype for a phone number in the first place.
As an aside, you don’t need multiple INSERT
statements, you can put a comma after each row to insert such as:
INSERT INTO [table] (column1, column2, column3)
VALUES
(value1c1, value1c2, value1c3),
(value2c1, value2c2, value2c3)
...
Read more here: Source link