Home mysql how to change the field type

how to change the field type

Author

Date

Category

It is necessary to make the field so that you can record the number of type 65.5 , and now you can only write integers.


Answer 1, Authority 100%

alter table `table`
Change column `column_name`` column_name` Float;

table – the name of your table
column_name – Your field name

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions