关于mysql NULL的一个有关问题
关于mysql NULL的一个问题
我把数据库table的filed1设置不为空,filed2字段设置为空
然后插入一条数据，filed1='test' filed2不变
然后我写个查询语句
selct * from table where filed2=''为什么查询不到？
我改成 filed2=NULL还是不行
最后我把filed2结构设置不为空 又可以查询到了这是怎么回事啊？
------解决方案--------------------
filed2 is NULL 呢？
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What is the difference between null and NULL in c language
Sep 22, 2023 am 11:48 AM
The difference between null and NULL in C language is: null is a macro definition in C language, usually used to represent a null pointer, which can be used to initialize pointer variables, or to determine whether the pointer is null in a conditional statement; NULL is a macro definition in C language A predefined constant in , usually used to represent a null value, used to represent a null pointer, null pointer array or null structure pointer.
What do undefined and null mean?
Nov 20, 2023 pm 02:39 PM
In JavaScript, both undefined and null represent the concept of "nothing": 1. undefined represents an uninitialized variable or a non-existent property. When a variable is declared but no value is assigned to it, the value of the variable is undefined , when accessing properties that do not exist in the object, the returned value is also undefined; 2. null represents an empty object reference. In some cases, the object reference can be set to null to release the memory it occupies.
When to use null and undefined
Nov 13, 2023 pm 02:11 PM
Both null and undefined indicate a lack of value or an undefined state. Depending on the usage scenario, there are some guiding principles for choosing to use null or undefined: 1. When you need to clearly indicate that a variable is empty or invalid, you can use null; 2. When a variable has been declared but not yet assigned a value, it will be set to undefined by default; 3. When you need to check whether a variable is empty or undefined, use the strict equality operator "===" to determine whether the variable is null or undefined. .
What is the difference between null and undefined
Nov 08, 2023 pm 04:43 PM
The difference between null and undefined is: 1. Semantic meaning; 2. Usage scenarios; 3. Comparison with other values; 4. Relationship with global variables; 5. Relationship with function parameters; 6. Nullability check; 7. Performance considerations; 8. Performance in JSON serialization; 9. Relationship with types. Detailed introduction: 1. Semantic meaning, null usually means knowing that this variable will not have any valid object value, while undefined usually means that the variable has not been assigned a value, or the object does not have this attribute; 2. Usage scenarios, etc.
What are the uses of null in java
Mar 01, 2024 am 10:10 AM
Usage: 1. Initialize the reference type variable to null, indicating that the variable does not currently point to any object; 2. Set the reference type variable to null, which can release the memory space of the object referenced by the variable and help the garbage collector to recover This object; 3. Use null to check whether a reference is empty. You can avoid the occurrence of NullPointerException by judging whether the reference is null. 4. Use null in conditional judgment to judge whether a reference is empty.
How to remove null from php array
Dec 23, 2022 am 10:27 AM
How to remove nulls from PHP arrays: 1. Use the "foreach($arr as $k=>$v){...}" method to remove null values from the array; 2. Use the while syntax structure to remove null values; 3. Use The array_filter function filters the array and removes null values.
How to use vue3 table component
May 12, 2023 pm 09:40 PM
Basic table Before developing the table component, first think about what style of API to use. Because the author uses element in production work, the styles of the previous components are similar to element, but this time I do not plan to use the element style. , I plan to change it and display it directly: We expect users to use it like this: constdataList=[{id:1,name:'"JavaEE Enterprise Application Practice"',author:'dev1ce',price:'10.22',desc:&# 3
How to add a row to table in jquery
May 29, 2023 pm 01:24 PM
How to add a row to a table with jquery: 1. Create an html sample file and reference the jQuery file; 2. Use "table", "tr", "td" tags to create a table; 3. Create a button button and bind the onclick click event , and then execute the "addhang()" function; 4. Define a variable tr within the function to save the table rows that need to be added. The $ symbol obtains the table object, and the "append()" method is used to add a row to the table.
