Skip to content

Instantly share code, notes, and snippets.

@quoidautre

quoidautre/gist:3800526

Created September 28, 2012 15:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save quoidautre/3800526 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save quoidautre/3800526 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL: Procédures stockées avec paramètres
Raw
gistfile1.sql
BEGIN
SET @mySelect:= 'SELECT * FROM CATEGORY ';
IF(param_id_category > 0) THEN
SET @mySelect:= CONCAT(@mySelect, 'WHERE CAT_ID=',param_id_category);
END IF;
prepare stmnt FROM @mySelect;
EXECUTE stmnt;
DEALLOCATE PREPARE stmnt;
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment