解决SQL2008中设计表字段及类型时无法保存的问题
摘要：
依次SQL Server 2008 Management Studio->工具->选项->Designers->表设计器和数据库设计器->去掉"阻止保存要求重新创建表的更改"前面的勾选，即可~ 阅读全文
posted @ 2011-12-27 14:44 伴老 阅读(305) 评论(0) 推荐(0) 编辑
处理MySQL更新表时ErrorCode:1175.You are using safe update mode and you tried to update a table without a WHERE that uses a KEY
摘要：
Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.Solution：SETSQL_SAFE_UPDATES= 0;update T set col = 'xxx' where condition ……; 阅读全文
posted @ 2011-12-27 10:59 伴老 阅读(1034) 评论(0) 推荐(0) 编辑