Nishant kumar

Software Developer

About Me

gfhgf
View my complete profile

Wednesday, 5 August 2015

MySQL Stored Procedure

DELIMITER //
CREATE PROCEDURE aff2_2015
(IN con longtext, IN mob bigint)
BEGIN
  SELECT * FROM affidavitdata_2015
  WHERE studentFirstName = con and studentmobilenumber=mob;
END //
DELIMITER ;
CALL aff2_2015('nishant','7503485910');
Posted by gfhgf at 02:39
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Nishant Kumar Rai

Nishant Kumar Rai

Blog Archive

  • ►  2013 (1)
    • ►  November (1)
  • ►  2014 (4)
    • ►  January (1)
    • ►  June (3)
  • ▼  2015 (22)
    • ►  April (5)
    • ►  May (1)
    • ►  July (4)
    • ▼  August (11)
      • Email Validation check from regex code in vb.net
      • Validate Email in Vb.net
      • Email Send Class in Vb.net
      • sort string as alphabetical in vb.net
      • String Abribiation in vb.net
      • How create setup file in vb.net
      • MySQL Stored Procedure
      • How To Convert database to UTF8 in my sql
      • How to Set background color of Combobox item in vb...
      • store processior in my sql
      • how to check store procedure exist or not
    • ►  November (1)
  • ►  2016 (4)
    • ►  April (1)
    • ►  July (1)
    • ►  December (2)
  • ►  2018 (1)
    • ►  March (1)
  • ►  2020 (1)
    • ►  August (1)

Total Pageviews

Nishant kumar rai. Picture Window theme. Powered by Blogger.