1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to insert decimals in MySQL?

Discussion in 'PHP' started by EGS, Mar 20, 2007.

  1. #1
    Hi.

    How do I have the ability to insert decimical numerical characters into a MySQL database? Currently I have it set as INT but it's not showing the decimal and then other the number after the decimal.

    Please help.
    Thanks.
     
    EGS, Mar 20, 2007 IP
  2. Darkhodge

    Darkhodge Well-Known Member

    Messages:
    2,111
    Likes Received:
    76
    Best Answers:
    1
    Trophy Points:
    185
    #2
    I'm not sure about how to store something like "5.00" in a field set as INT.

    However what you could do is:

    • Set the field as a VARCHAR and store "5.00" etc... that way.
    • Store the number as an INT, e.g. "5", and then format the number using "number_format()"

    Hope that helps :)
     
    Darkhodge, Mar 20, 2007 IP
  3. TwistMyArm

    TwistMyArm Peon

    Messages:
    931
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Your question is a little vague: do you want to store integers and then show them with decimal places (which would always be zeros after the decimal place), or do you want to store numbers that have decimal components? If the latter (which is almost the only question that makes sense) you need to use the DECIMAL or DOUBLE type/s.
     
    TwistMyArm, Mar 20, 2007 IP
  4. EGS

    EGS Notable Member

    Messages:
    6,078
    Likes Received:
    438
    Best Answers:
    0
    Trophy Points:
    290
    #4
    That's, got it using VARCHAR! :)
     
    EGS, Mar 20, 2007 IP
  5. Darkhodge

    Darkhodge Well-Known Member

    Messages:
    2,111
    Likes Received:
    76
    Best Answers:
    1
    Trophy Points:
    185
    #5
    Hehehe I'm glad that helped :D
     
    Darkhodge, Mar 20, 2007 IP
  6. jitesh

    jitesh Peon

    Messages:
    81
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Select FLOAT instead of INT
    and mention lenght 10,2

    2 is the number of digits after .
     
    jitesh, Mar 20, 2007 IP
  7. ruby

    ruby Well-Known Member

    Messages:
    1,854
    Likes Received:
    40
    Best Answers:
    1
    Trophy Points:
    125
    #7
    Correct use the FLOAT datatype to store data in the table field.



    MySQL Datatypes

    CHAR[Length]
    Length bytes
    A fixed-length field from 0 to 255 characters long.


    VARCHAR(Length)
    String length + 1 bytes
    A fixed-length field from 0 to 255 characters long.


    TINYTEXT
    String length + 1 bytes
    A string with a maximum length of 255 characters.


    TEXT
    String length + 2 bytes
    A string with a maximum length of 65,535 characters.


    MEDIUMTEXT
    String length + 3 bytes
    A string with a maximum length of 16,777,215 characters.


    LONGTEXT
    String length + 4 bytes
    A string with a maximum length of 4,294,967,295 characters.


    TINYINT[Length]
    1 byte
    Range of -128 to 127 or 0 to 255 unsigned.


    SMALLINT[Length]
    2 bytes
    Range of -32,768 to 32,767 or 0 to 65535 unsigned.


    MEDIUMINT[Length]
    3 bytes
    Range of -8,388,608 to 8,388,607 or 0 to 16,777,215 unsigned.


    INT[Length]
    4 bytes
    Range of -2,147,483,648 to 2,147,483,647 or 0 to 4,294,967,295 unsigned.


    BIGINT[Length]
    8 bytes
    Range of -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 or 0 to 18,446,744,073,709,551,615 unsigned.


    FLOAT
    4 bytes
    A small number with a floating decimal point.


    DOUBLE[Length, Decimals]
    8 bytes
    A large number with a floating decimal point.


    DECIMAL[Length, Decimals]
    Length + 1 or Length + 2 bytes
    A DOUBLE stored as a string, allowing for a fixed decimal point.


    DATE
    3 bytes
    In the format of YYYY-MM-DD.


    DATETIME
    8 bytes
    In the format of YYYY-MM-DD HH:MM:SS.


    TIMESTAMP
    4 bytes
    In the format of YYYYMMDDHHMMSS; acceptable range ends inthe year 2037.


    TIME
    3 bytes
    In the format of HH:MM:SS


    ENUM
    1 or 2 bytes
    Short for enumeration, which means that each column can haveone of several possible values.


    SET
    1, 2, 3, 4, or 8 bytes
    Like ENUM except that each column can have more than one ofseveral possible values.
     
    ruby, Mar 21, 2007 IP
  8. ketan9

    ketan9 Active Member

    Messages:
    548
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    58
    #8
    USE the type

    UNSIGNED DECIMAL (10,2) - you can from 0.00 to 99,999,999.99

    DECIMAL(11,2) - you can save from -99,999,999.99 to 99,999,999.99
     
    ketan9, Mar 21, 2007 IP