fork download
copy 
  1. DELIMITER $$
  2.  
  3. CREATE DEFINER=`root`@`localhost` PROCEDURE `getLiveSearchDataByInn`(queryString VARCHAR(255))
  4. BEGIN
  5.  
  6.     SELECT @countInn = COUNT(*) FROM test.userdata_extended WHERE `inn` LIKE queryString;
  7.  
  8. 	IF @countInn > 0
  9. 		THEN SELECT * FROM test.userdata_extended WHERE `inn` LIKE queryString;
  10. 	END IF;
  11.  
  12. END
Not running #stdin #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/S7SGI2
language:
SQLite (sqlite 3.27.2)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!