What is the small loophole in MySql2005?

This article is to share with you what the small loophole in MySql2005 is, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

If you create a table in MySql2005, a field in the table is defined as "float".

For example:

Create table test

(

Code integer

Num float

)

Insert into test values (1pr 0.8)

Using the code field as a condition, you can do anything with this table without problems.

However, it will be problematic to use the num field as a condition for operation.

For example:

Select * from test where num=0.8

No data to display will be displayed

It is no good to delete and modify.

However, in SQLSERVER2000, you can use fields of type "float" as conditions, and there is no problem with table operations.

This is only a small loophole and will not affect the running of the program. As long as you don't use a field of type "float" as a condition.

Other versions of Mysql haven't been tried yet.

You can have a try.

These are the small loopholes in MySql2005, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.