Updation of some column values of a table in mysql procedure

Question

I have one procedure written in Mysql which i access from asp.net application. I have an update and insert query in it for some columns of a table and i want remaining column values as it is. what should i do? please HEEEEELLLLP.....

tejal bhesaniya · Answer

Hi Abumiyan whati understood is u want some default value in remaining column for that u can set some default vlaue by altering the table only

Abumiyan Muqri · Answer

Thanks for ur help Tejal.I had fixed it... juz change update query little bit.

tejal bhesaniya · Answer

then pass default values at the tym of creating table u have table created so now u can alter the table and pass some default value if ans is right then mark it as ans

Abumiyan Muqri · Answer

Yes Tejal...