php – composer – Windows CLI instalace

  php -r „readfile(‚https://getcomposer.org/installer‘);“ > composer-setup.php php -r „if (hash(‚SHA384‘, file_get_contents(‚composer-setup.php‘)) === ’41e71d86b40f28e771d4bb662b997f79625196afcca95a5abf44391188c695c6c1456e16154c75a211d238cc3bc5cb47′) { echo ‚Installer verified‘; } else { echo ‚Installer corrupt‘; unlink(‚composer-setup.php‘); } echo PHP_EOL;“ php composer-setup.php php -r „unlink(‚composer-setup.php‘);“

mysqll – Show privileges

  mysql> show privileges; | Privilege | Context | Comment | | Alter | Tables | To alter the table | | Alter routine | Functions,Procedures | To alter or drop stored functions/procedures | |…

mysql – Procedura – ukázka

  CREATE DEFINER=`autor`@`localhost` PROCEDURE `proc_wpfb_kategorie`(IN `in_cat_id` INT, OUT `kategorie` VARCHAR(255)) begin   declare loc_cat_id INT DEFAULT 0;       declare loc_cat_parent INT DEFAULT 999999;       declare kategorie_temp varchar (255) default “;   set loc_cat_id…