Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysql-MySQL varchar与数字比较 进行查询的问题

mysql-MySQL varchar与数字比较 进行查询的问题

WBOY
Release： 2016-06-06 09:32:50
Original
1336 people have browsed it

mysqlsql

今天写sql的时候遇到一个问题，我在where语句里面写的是a.poruid = 0，这个字段是varchar类型的，结果返回的是全集，改为a.poruid = "0"的时候查出来的猜我我想要的结果，很奇怪，有数据库方面的大神能解答一下吗？varchar类型与数字比较的机制吗？我主要是想知道为什么不加引号的时候返回的是全集，，，

Related labels：
mysql sql
source：php.cn
Previous article：在安装mysql odbc 5.3的时候报错 Next article：mysql-最新版本的MySQL解压并且配置后发现没有默认的root用户，怎么办？
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2479
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2622
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
2212
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
2082
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
2187
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template