· 9 years ago · Nov 26, 2016, 05:26 PM
1CREATE TABLE IF NOT EXISTS `build` (
2 `ID` int(11) NOT NULL AUTO_INCREMENT,
3 `Version` varchar(20) NOT NULL,
4 `Date` datetime DEFAULT NULL,
5 PRIMARY KEY (`ID`)
6) ENGINE=InnoDB DEFAULT CHARSET=utf8;
7
8IF EXISTS(select 1 from build where Versao = '1.1') THEN select "yes";
9
10SELECT CASE WHEN EXISTS (SELECT 1 FROM build WHERE Versao = '1.1')
11 THEN "yes"
12 ELSE "no"
13 END
14LIMIT 1
15
16SELECT IF(EXISTS(SELECT 1 FROM build WHERE Versao = '1.1'), 'yes', 'no') AS test;