数据库mariadb删除表操作记录

admin

Database changed
MariaDB [zabbix]> show tables;
( k, u! f/ e% l- _$ N# P- ]4 n+------------------+
| Tables_in_zabbix |
/ A1 t  ~! p+ O! P% z7 ~+------------------+
. g- u; U% U$ S' r| group_discovery  |
| group_prototype  |
$ j6 I+ q$ w  _* y- \6 w, Q7 t| groups           |
. I4 f, @, Z$ x+ H+ t% }| hosts            |
| maintenances     |
& S7 @8 h& Z6 @- S- w| screen_user      |
| screen_usrgrp    |
) K* ^# L0 m+ i+ w2 Q| screens          |
8 J; v( r) }- v| screens_items    |
| slideshows       |
| users            |
7 F3 ~( B/ n( |+------------------+
11 rows in set (0.00 sec)

- @# ]0 T' l8 @* jMariaDB [zabbix]> drop tables group_discovery group_prototype;
" s9 b) n! c  X6 S# @9 qERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group_prototype' at line 1
4 a1 ]* i, q% c4 F2 G. C# cMariaDB [zabbix]> drop tables group_discovery,group_prototype;
, M+ f) J: C2 l- P. L2 o3 S+ UQuery OK, 0 rows affected (0.11 sec)
5 E/ C  I8 r' Q9 E7 @
MariaDB [zabbix]> drop tables groups,hosts,maintenances, screen_user,screen_usrgrp,screens,screens_items,slideshows,users;
Query OK, 0 rows affected (0.28 sec)

6 R7 F5 B2 A3 W( J  ^MariaDB [zabbix]> show tables;
Empty set (0.00 sec)
9 ?- g" S$ c4 d8 [+ ~6 v- w
1 e, X4 K7 A% p& w