Jump to content
  • 0

SQL Error Mob


Elysium

Question


  • Group:  Members
  • Topic Count:  41
  • Topics Per Day:  0.01
  • Content Count:  164
  • Reputation:   16
  • Joined:  03/15/12
  • Last Seen:  

Hi, i'm bit confuse now about this line that gives me error. kind please check this? which part is error?

 

 

REPLACE INTO `mob_db` VALUES (10000,'PORING','Poring','Poring', 255, 15000000, 100000, 500000, 500000, 6, 10000, 20000, 50, 5, 100, 1, 255, 400, 999, 1, 10, 10, 2, 7, 88, 1973, 100, 500, 768, 576, 13000, 0, 0, 0, 0, 0, 0, 501, 1, 501, 1, 673, 1, 505, 1, 503, 1000, 501, 1, 607, 1, 501, 1, 0, 0, 0, 0);
 

 

 

 

Script line: 1    Column count doesn't match value count at row 1
 

Link to comment
Share on other sites

3 answers to this question

Recommended Posts


  • Group:  Developer
  • Topic Count:  153
  • Topics Per Day:  0.04
  • Content Count:  2285
  • Reputation:   745
  • Joined:  06/16/12
  • Last Seen:  

u were importing /sql from PHPMyAdmin? if yes, maybe it just because the execution time out.

1. Increase the execution timeout, or

2. use remote client (MySQL Workbench maybe), or

3. Split the files

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  41
  • Topics Per Day:  0.01
  • Content Count:  164
  • Reputation:   16
  • Joined:  03/15/12
  • Last Seen:  

u were importing /sql from PHPMyAdmin? if yes, maybe it just because the execution time out.

1. Increase the execution timeout, or

2. use remote client (MySQL Workbench maybe), or

3. Split the files

 

 

No there's no related with importing with PMA, i just create a mob and  then when i excute the script query it gives error.

CHECK YOUR INBOX.

Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  153
  • Topics Per Day:  0.04
  • Content Count:  2285
  • Reputation:   745
  • Joined:  06/16/12
  • Last Seen:  

eh I didn't read the error msg.

well, as it said, the column count doesn't match. just recheck again :P

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...