如何执行此查询..?

本文介绍了如何执行此查询..?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我的查询是

My query is

UPDATE EMPLOYEE_MASTER SET ADDRESS='anyone',CITY= 'anyone',STATE= 'Andaman and Nicobar (UT)',ZIPCODE= '123456' WHERE LOGIN_NAME='xyz'

现在的问题是STATE=''Andaman and Nicobar (UT)''何时无法执行， 但是当STATE=''Andaman Nicobar (UT)''可以执行... 在这里，我如何更新为STATE=''Andaman and Nicobar (UT)''

now problem is when STATE=''Andaman and Nicobar (UT)'' it can not execute, but when STATE=''Andaman Nicobar (UT)'' it can execute... Here how can i update as STATE=''Andaman and Nicobar (UT)''

推荐答案

您遇到什么错误? 首先检查您的州"字段的列长. IMO小于20，并且您正在传递长度为24的值. What error you are getting? First check your column length of State field. IMO its less than 20 and you are passing value that''s length is 24.

检查状态列的列长度，该值应该增加 您的查询没问题 check your column length of state column this should increase your query is ok

检查您的列大小. 您的查询是正确的. Check your column size. Your query is right.