Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysql判断查询结果是否存在，存在输出1不存在输出0

mysql判断查询结果是否存在，存在输出1不存在输出0

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-06 09:37:10
Original
2733 people have browsed it

mysql 

<code> IF EXISTS (SELECT * FROM table WHERE condition) SELECT '1' ELSE SELECT '0';</code>
Copy after login

类似这种语义，mysql中可以实现吗

Related labels：
mysql
Previous article：新浪云中mysql怎么连接 Next article：mysql-请问Jan 1, 2015 6:01:01 AM如何转化为datetime类型
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
The problem that mysql service cannot be restarted after mysql upgrade
From 1970-01-01 08:00:00
0
0
0
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
php - In wamp, how to use mysql installed by myself instead of wamp integrated mysql?
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
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