Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular

SQLize.online is a free online SQL environment for quickly running, experimenting with and sharing code. You can run your SQL code on top of the most popular RDBMS including MySQL, MariaDB, SQLite, PostgreSQL, Oracle and Microsoft SQL Server.

Copy Format Clear
DELIMITER // CREATE PROCEDURE temp_cucumber_calc() BEGIN DECLARE dry_mass DECIMAL(10, 2); DECLARE new_weight DECIMAL(10, 2); SET dry_mass = (100 - 99) * 100 / 100; SET new_weight = dry_mass / ((100 - 98) / 100); SELECT new_weight AS result; END // DELIMITER ; CALL temp_cucumber_calc(); DROP PROCEDURE temp_cucumber_calc; -- ПРАВИЛЬНЫЙ вызов функции: SELECT calculate_cucumber_weight(100, 99, 98) AS new_weight;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear