almightyegg Posted April 10, 2007 Share Posted April 10, 2007 in an INT column can you have decimal numbers? Quote Link to comment https://forums.phpfreaks.com/topic/46482-quick-question/ Share on other sites More sharing options...
kenrbnsn Posted April 10, 2007 Share Posted April 10, 2007 No, the INT refers to "integers". Ken Quote Link to comment https://forums.phpfreaks.com/topic/46482-quick-question/#findComment-226121 Share on other sites More sharing options...
almightyegg Posted April 10, 2007 Author Share Posted April 10, 2007 Is there a column specific to decimals? or would I use varchar? Quote Link to comment https://forums.phpfreaks.com/topic/46482-quick-question/#findComment-226125 Share on other sites More sharing options...
utexas_pjm Posted April 10, 2007 Share Posted April 10, 2007 doubles and floats are decimal numbers Quote Link to comment https://forums.phpfreaks.com/topic/46482-quick-question/#findComment-226128 Share on other sites More sharing options...
almightyegg Posted April 10, 2007 Author Share Posted April 10, 2007 What abou DECIMAL? lol! I'm assuming that does what it says on the tin? Quote Link to comment https://forums.phpfreaks.com/topic/46482-quick-question/#findComment-226132 Share on other sites More sharing options...
wildteen88 Posted April 10, 2007 Share Posted April 10, 2007 MySQL supports the DECIMAL data type. DECIMAL is basically an alias of DOUBLE They both hold a decimal of 24 to 53 digits FLOAT also holds a decimal but only 23 digits. Quote Link to comment https://forums.phpfreaks.com/topic/46482-quick-question/#findComment-226209 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.