What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-02 19:50:09
create proc usong flyway example
DELIMITER $$ DROP PROCEDURE IF EXISTS upgrade_database_1_0_to_2_0 $$ CREATE PROCEDURE upgrade_database_1_0_to_2_0() BEGIN -- rename a table safely IF NOT EXISTS( (SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=... Add solution -
SQL 2021-10-29 15:12:21
create column that already exists mysql
DROP PROCEDURE IF EXISTS `?`; DELIMITER // CREATE PROCEDURE `?`() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END; ALTER TABLE `table_name` ADD COLUMN `column_name` INTEGER; END // DELIMITER ; CALL `?`(); DROP PROCEDURE `?`; Add solution -
SQL 2021-10-23 10:57:12
mysql get nested records
DROP PROCEDURE IF EXISTS famsubtree; DELIMITER go CREATE PROCEDURE famsubtree( root INT ) BEGIN DROP TABLE IF EXISTS famsubtree; CREATE TABLE famsubtree SELECT childID, parentID, 0 AS level FROM familytree WHERE parentID = root; ALTER TA... Add solution -
SQL 2021-10-22 14:39:07
procedures sql insert mysql
mysql> DELIMITER // ; mysql> Create PROCEDURE insert_studentinfo(IN p_id int, IN p_name varchar(20),IN p_Address Varchar(20), IN p_subject Varchar(20)) -> BEGIN -> insert into student_info(id, name, address, subject... Add solution -
SQL 2021-10-17 10:59:12
mysql procedure example
-- MySQL -- example DELIMITER $$ -- Changes delimiter to $$ so can use ; within the procedure CREATE PROCEDURE select_employees() BEGIN select * from employees limit 1000; -- Use the ; symbol within the procedure END$$ DELIMITER ; -- Resets the del... Add solution