[解决]如何更新表格中的整列？ [英] [Solved]How to update entire column in table....?

问题描述

我想更新一个包含26934条记录的整个列，当我尝试简单的更新语句时，它不会工作..

解决方案

删除你的索引表首先然后更新它，当你每次索引更新时尝试更新它时会发生什么...这需要很长时间///首先删除索引然后更新然后再添加索引

嗨朋友，谢谢你的答案，但我找到了解决方案..我首先删除触发器然后更新表并再次添加触发器...现在它工作正常...谢谢../

I want to update one entire column which contains 26934 records, When i try for simple update statement , it wont work ..

解决方案

Drop the indexes of your table first and then update it , what happend is when you try to update it each time indexes also gets updated .. which take long time ///drop indexes first and then update and then add indexes again

Hi friends thank you for your answers but i find the solution .. I first remove trigger and then update the table and again added the trigger ... now it is working fine... Thank you../

这篇关于[解决]如何更新表格中的整列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！