Bug #62679 Flow control in SQL scripts
| Submitted: | 11 Oct 2011 10:36 | Modified: | 11 Oct 2011 12:09 |
|---|---|---|---|
| Reporter: | Richard Crawshaw | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S4 (Feature request) |
| Version: | OS: | Any | |
| Assigned to: | CPU Architecture: | Any |
[11 Oct 2011 12:09]
Valeriy Kravchuk
This is a duplicate of Bug #48777. There are also other bug reports (in various statuses) asking for the same feature actually.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Can we have flow control statements in SQL scripts, rather than only within SPs / Functions. Without IF THEN ELSE IF ELSE END IF it is excessively difficult to produce maintenance scripts to manage a remote system. I want to be able to do things like: Create table if not exists IF primary key exists on wrong column THEN Drop primary key END IF IF primary key does not exist THEN Create primary key END IF IF index exists on wrong column THEN Drop index END IF IF index does not exist THEN Create index END IF IF foreign key exists on wrong columns THEN Drop foreign key END IF IF foreign key does not exist THEN Create foreign key END IF [END OF EXAMPLE] A script like this can be run to create a database from scratch or it can be used to make small changes to an existing database without having to have individual scripts for every different aspect. How to repeat: Any IF THEN ELSE IF THEN ELSE END IF throws an error unless it is inside a SP or Function.