SQL insert into dont let me insert in more than 20 column

Asked Aug 06 '18 at 16:31

Active Aug 06 '18 at 16:40

Viewed 117 times

my problem is why sql doesn't let me make an insert into for a row with more than 20 column everythings works fine but when it reaches its 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
              ));

When i try to add another column it just does not insert the data without telling me any error "IS THE PDO METHOD" i really need your help

edited Aug 06 '18 at 16:40

RiggsFolly

93,638
21
103
149

asked Aug 06 '18 at 16:31

Jouhn code

What is the column name you are trying to add to this list? – RiggsFolly Aug 06 '18 at 16:37
pic_1, pic_2 (etc) 10 columns left – Jouhn code Aug 06 '18 at 16:40
And what is contained in those columns? A full image or a path to an image on disk – RiggsFolly Aug 06 '18 at 16:41
1

Maybe it would be useful to see the schema for this table – RiggsFolly Aug 06 '18 at 16:42
iD primary key more than 15 column varchar(255) ,INt columns TYNYINT(COLUMNS), LONGTEXT(COLUMNS) – Jouhn code Aug 06 '18 at 16:43
HOW DO I SEND YOU THE SQL? – Jouhn code Aug 06 '18 at 16:43
Numerical instances appended to a column name are usually a bad table design. You probably should have another table. Use the `edit` function of the question https://stackoverflow.com/posts/51712048/edit. Add the result of `show create table post;` – user3783243 Aug 06 '18 at 16:43
Edit your question and add in the text – RiggsFolly Aug 06 '18 at 16:46
CREATE TABLE `post` ( `id` int(15) NOT NULL AUTO – Jouhn code Aug 06 '18 at 16:50
Thats what appear only that – Jouhn code Aug 06 '18 at 16:50
That cannot be so! Do you use phpMyAdmin? [Read this](https://stackoverflow.com/questions/1498777/how-do-i-show-the-schema-of-a-table-in-a-mysql-database) – RiggsFolly Aug 06 '18 at 17:09
in your insert query you used only 19 columns – Mohit Kumar Aug 06 '18 at 17:24
yeah i know but my table has more than 25 columns and when i;m going in number 20 column the query (statement dosent worrk) – Jouhn code Aug 06 '18 at 17:57

SQL insert into dont let me insert in more than 20 column

0 Answers0