Shulou(Shulou.com)06/01 Report--

Editor to share with you how to re-edit the table by mysql. I hope you will gain a lot after reading this article. Let's discuss it together.

The method of mysql re-editing the table: first enter the command describe to view the current data table structure information; then use the command "alter...add..." Add new field information; finally, modify the field information through the "alter change" command.

First enter the command describe datasheet name to view the current datasheet structure information

If you want to add new field information, then use the command alter... Add... Add

After adding the new field information, and then looking at the structure of the data table, you can see that the field with field type date has been added.

If you want to change the existing field information, then use the command alter... Change..., make changes

After the modification is completed, look at the structure of the data table again, and you can see that the default value of score has been changed to 0

Insert information to see if the information can be entered correctly by using the command insert into

By commanding select to view the contents of the data table, you can find that the data is correctly entered into the data table

After reading this article, I believe you have a certain understanding of the method of mysql re-editing the table, want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.