A related question about mysqlNULL

Source: Internet
Author: User
For a question about mysqlNULL, I set the filed1 of the database table to not be empty, and set the filed2 field to null & nbsp; and then insert a piece of data, filed1 = 'test' filed2 remains unchanged. then I write a query statement selct * fromtablewherefile about mysql NULL.
I set the filed1 and filed2 fields of the database table to be empty.

Insert a piece of data, and filed1 = 'test' filed2 remains unchanged.

Then I write a query statement.
Selct * from table where filed2 = ''why cannot It be queried?
I changed filed2 to NULL or not.

At last, I set the filed2 structure not to be empty and I can find out what is going on?

------ Solution --------------------
Filed2 is NULL?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.