DROP PUBLICATION

Description

DROP PUBLICATION can delete the existed publication.

Syntax

1. DROP PUBLICATION pubname;

Explanations

• pubname: The name of an existing publication whose definition is to be deleted.

Examples

1. create account acc0 admin_name 'root' identified by '111';
2. create account acc1 admin_name 'root' identified by '111';
3. create account acc2 admin_name 'root' identified by '111';
4. create database t;
5. create publication pub3 database t account acc0,acc1;

7. mysql> show publications;
8. +------+----------+
9. | Name | Database |
10. +------+----------+
11. | pub3 | t        |
12. +------+----------+
13. 1 row in set (0.00 sec)

15. mysql> drop publication pub3;
16. Query OK, 0 rows affected (0.01 sec)

18. mysql> show publications;
19. Empty set (0.00 sec)