/    Sign up×
Community /Pin to ProfileBookmark

MySQL Data Types

What’s the difference between the following data types, as the maximum number of digits can be specified in the size parameter of all of them?

[LIST]

  • [*]

    int(size)


  • [*]

    smallint(size)


  • [*]

    tinyint(size)


  • [*]

    mediumint(size)


  • [*]

    bigint(size)


  • [/LIST]

    to post a comment
    PHP

    1 Comments(s)

    ×

    Success!

    Help @Dysan spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 BETA 6.16,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @nearjob,
    tipped: article
    amount: 1000 SATS,

    tipper: @meenaratha,
    tipped: article
    amount: 1000 SATS,

    tipper: @meenaratha,
    tipped: article
    amount: 1000 SATS,
    )...