Mysql Procedure not working in mysql -


i have tried following procedure both ways.but through error. here need thecount of particular question categories.table 'questions'

create procedure questioncountjava() begin     select count(*) javaquestioncount     questions category='java' end 

***************other tried way********************

delimiter // create procedure questioncountjava() begin     select count(*) javaquestioncount     questions category='java' end // delimiter; 


Comments

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

javascript - oscilloscope of speaker input stops rendering after a few seconds -