Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Mar 2012
    Location
    Ontario, Canada
    Posts
    53
    Thanks
    9
    Thanked 0 Times in 0 Posts

    MYSQL Database limits

    Hello

    has anyone heard of a MySQL database having row limits? I have a database that was created for me, I created my tables and started inputting information and for some reason I am not able to input any new records after 127. I have manually tried inputting and entering 128 in the auto-increment ID field and I get the same error message "Duplicate Entry for '127' on Primary Key".

    I have asked the company that has created the database if they put any restrictions in their schemas to not allow more than 127 rows in a table. They claim no but I have two tables that won't allow more than 127 rows. I don't have a lot of fields per table.

    Could there be something in the setup or would this have to do with database size? Remember I didn't create the table and they won't allow me access to check the database creation.

    any help would be great.

  • #2
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,874
    Thanks
    2
    Thanked 164 Times in 159 Posts
    The error message is telling you that you already have a '127' entry in the ID field.

    Why are you trying to manually enter a value in an auto-increment field? Mysql will increment and add that entry for you.

    I didn't create the table and they won't allow me access to check the database creation
    If you can access the db and run queries, you can run the queries that show the statements used to create the db and tables.

    show create database db_name
    show create table table_name

  • #3
    New Coder
    Join Date
    Mar 2012
    Location
    Ontario, Canada
    Posts
    53
    Thanks
    9
    Thanked 0 Times in 0 Posts
    When I setup the table, I imported a spreadsheet that had 200 records but it stopped at 127 records. I tried to manually enter in records (first time, without entering a number in the ID field and the second time using the next number in the ID field) to test if I could manually enter a record.

    The table has stopped at 127 and won't allow me to enter any more records. Is there a reason why this is happening?

  • #4
    New Coder
    Join Date
    Mar 2012
    Location
    Ontario, Canada
    Posts
    53
    Thanks
    9
    Thanked 0 Times in 0 Posts
    when I run show create database this is what I get: CREATE DATABASE `brase_dbaccount` /*!40100 DEFAULT CHARACTER SET utf8 */

  • #5
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,874
    Thanks
    2
    Thanked 164 Times in 159 Posts
    What output do you get from:
    Code:
    show create table tablename;
    How did you import the spreadsheet?

    Is it truly an .xls spreadsheet or is it a .csv file?

    A .csv file IS NOT a spreadsheet, but spreadsheet applications can read/write plain text .csv files.

    Please post your "spreadsheet" file as an attachment, but make sure that you first obfuscate any private info.

  • #6
    Master Coder felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, Australia
    Posts
    6,642
    Thanks
    0
    Thanked 649 Times in 639 Posts
    It would stop at 127 if the field is a signed tinyint as that is the maximum value that field type can hold.
    Stephen
    Learn Modern JavaScript - http://javascriptexample.net/
    Helping others to solve their computer problem at http://www.felgall.com/

    Don't forget to start your JavaScript code with "use strict"; which makes it easier to find errors in your code.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •