首页 > 解决方案 > SQL插入不要让我插入超过20列

问题描述

我的问题是为什么 sql 不允许我插入超过 20 列的行,一切正常,但是当它达到它的 limit()

$statement=$connection->prepare("INSERT INTO post
        ( id, short_name, title, fecha, author_id, 
          platform, general, size, type, views, 
          about, spain, english, japanese, italian, 
          french, other, genre, tutorial)
 VALUES ( :id, :short_name, :title, :fecha, :author_id, 
          :platform, :general, :size, :type, :views, 
          :about, :spain, :english, :japanese, :italian, 
          :french, :other, :genre, :tutorial)");

 $statement->execute(array(
               ':id'=>$null,
               ':short_name'=>$short_title,
               ':title'=>$title,
               ':fecha'=>$date,
               ':author_id'=>$mineid,
               ':platform'=>$platform,
               ':general'=>$general,
               ':size'=>$size,
               ':type'=>$type,
               ':views'=>$o,
               ':about'=>$about,
               ':spain'=>$spanish,
               ':english'=>$english,
               ':japanese'=>$japanese,
               ':italian'=>$italian,
               ':french'=>$french,
               ':other'=>$other,
               ':genre'=>$genre,
               ':tutorial'=>$videotutorial
              ));

当我尝试添加另一列时,它只是不插入数据而不告诉我任何错误“是 PDO 方法”我真的需要你的帮助

标签: phpsql

解决方案


推荐阅读