dongli1920 2012-04-05 20:31
浏览 1553
已采纳

MySQL选择IS NOT NULL的多个字段不起作用

I have a query that transfers data from multiple slave tables into a single master table. Here's an example of one of my queries:

$insert = mysql_query("
INSERT IGNORE INTO master (title, description, keywords, url, uniqueid, city, state, zip, datetime, expiretime)
SELECT title, description, keywords, url, uniqueid, city, state, zip, datetime, expiretime
FROM slave1 WHERE zip IS NOT NULL AND keywords IS NOT NULL AND city IS NOT NULL") or die(mysql_error());

After running this query, rows of data are being inserted into master with either some or all of the fields NULL where I specified them to be NOT NULL (the fields being zip, keywords, and city)

It seems like mysql is completely ignoring the IS NOT NULL parameter. Does anyone know a solution?

  • 写回答

2条回答 默认 最新

  • doujiaozhan2413 2012-04-05 20:35
    关注

    Try replace zip IS NOT NULL to TRIM(zip) <> ""

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥50 wordpress项目注册报失败刷新后其实是成功状态,请求排查原因
  • ¥20 linxu服务器僵尸进程不释放,代码如何修改?
  • ¥15 pycharm激活不成功
  • ¥40 如果update 一个列名为参数的value
  • ¥15 基于51单片机的水位检测系统设计中LCD1602一直不显示
  • ¥15 OCS2安装出现问题,请大家给点意见
  • ¥15 ros小车启动launch文件报错
  • ¥15 vs2015到期想登陆但是登陆不上
  • ¥15 IPQ5018制作烧录固件,boot运行失败(操作系统-linux)(相关搜索:操作系统)(相关搜索:操作系统)
  • ¥20 icefall在librispeech基础上加入个人数据集