如何执行此查询..? [英] how can execute this query..?

问题描述

我的查询是

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.

这篇关于如何执行此查询..?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！