Insert

[nhlanhla]

I hope i make this simpler this time:

I have TABLE1 with column1(must remain the same on the insewrted row) , column2, column3, column4 .Want to insert into column2 and column3 values 2579,2579. On TABLE1, the other columns can be null, column2 and column3 differ from the original row.

I hope i made it clear this time.

[michaelb]

If your question is
"How to insert a row providing values only for some of the columns"
you should be able to use this syntax:

INSERT INTO TABLE1 (column2, column3) values (2579, 2579);
 

[michaelb]

... with column1 (must remain the same on the inserted row)

... and if you mean that column1 must always have the same value on all rows, and you want to omit it in the INSERT statement, the easiest way could be to assign a default value for this column:

You can do it on your table using this statement:

 
ALTER TABLE table1 MODIFY (column1 DEFAULT default_value);
 

[nhlanhla]

Thanx guys i forgot to mention that, the script must be ran for the different mills. Anyway thanx guys, i was able to get it working. I used a cursor and a for loop.

Thanx again guys!