티스토리 뷰

공부

[mysql] use variables in query

승가비 2023. 8. 19. 23:48
728x90
SET @query = CONCAT('ALTER TABLE ', var_referenced_table_name, ' DROP FOREIGN KEY ', var_constraint_name, ';');
PREPARE stmt FROM @query; 
EXECUTE stmt; 
DEALLOCATE PREPARE stmt;

https://stackoverflow.com/questions/11687803/mysql-variables-in-alter-table-script

 

MySQL variables in ALTER TABLE script

Hello The following procedure will have to move all constraints from one table to the other however I am having some difficulties at the point where the constraint should be deleted. The problem: ...

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[maxosx] 미러링 전환 (cmd + f1)  (0) 2023.08.20
[npm] --yes  (0) 2023.08.19
[mysql] print message in procedure  (0) 2023.08.19
[sh] 메모리 사용량 정렬 `ps -ef --sort -rss; ps auxwww --sort -rss | head -5`  (0) 2023.08.19
[macosx] scutil --set HostName seunggabi-MacBookPro  (0) 2023.08.13
댓글