Converting 'INT' to 'BIGINT' with phpMyAdmin

Posted on 2009-05-01
Last Modified: 2013-12-12
I have one INT row on my SQL database that has officially reached its maximum capacity (2,147,483,647) for a few entries.

What is the most efficient way to convert this row to a BIGINT datatype?

Thanks in advance for the assist!
Question by:elbrian87
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    ALTER TABLE your_table MODIFY COLUMN columnname BIGINT

    Open in new window

    LVL 4

    Author Comment

    Angellll, will this convert the column (my mistake for calling it a row, before)? I have read that simply "changing" the column's DATATYPE will result in mathematical errors when my PHP scripts try processing the new numbers (IE- they will not convert properly).
    LVL 142

    Accepted Solution

    it will convert the column, indeed.
    in regards to php:

    php will eventually get a float data type for those large numbers...
    LVL 4

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Part of the Global Positioning System A geocode ( is the major subset of a GPS coordinate (, the other parts being the altitude and t…
    Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
    The viewer will learn how to count occurrences of each item in an array.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now