Relative Content

Tag Archive for c#sqlmysqlinline

SQL inline query insertinto

INSERT INTO ServiceID_302 (Services) VALUES ( (‘Preliminaries’), (‘Demolition’), (‘DRAINAGE_AND_REFUSE_DISPOSAL’), (‘GAS_DISTRIBUTION-COMPRESSED_AIR’), (‘SPACE_COOLING-CHILLED_WATER’), (‘SPACE_HEATING-LOW_PRESSURE_HOT_WATER’), (‘VENTILATION_&_AIR_CONDITIONING’), (‘OTHER_MECHANICAL_SERVICES’), (‘Sprinkler’), (‘Dayworks’), (‘COMMERCIAL_DISCOUNT’), (‘VARIATIONS’) ); I am trying to insert this using inline query it throws an error : There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES […]