数据库mariadb删除表操作记录

admin

Database changed
' h$ r: `* u8 m8 C8 |( n7 b! oMariaDB [zabbix]> show tables;
+------------------+
5 w9 _' W- `1 S" _* g| Tables_in_zabbix |
+------------------+
| group_discovery  |
" l$ z. [! k5 ~" w7 Y: C$ w9 C& s5 F| group_prototype  |
7 Q# j0 _( [# p' h| groups           |
7 K( l, I9 e! || hosts            |
9 [' X& R& e6 G3 r| maintenances     |
% D3 E6 i1 ^( w" a, e| screen_user      |
# D# l7 ?# ?4 O% h4 H| screen_usrgrp    |
6 M5 Z4 l4 r  P, @| screens          |
9 V1 d0 ?/ e3 k7 p5 r4 l) I| screens_items    |
8 v' V! o+ {- o$ |- _0 l, k8 D| slideshows       |
2 T  S  F9 V$ _| users            |
$ v5 ~4 e7 ]9 {" s+------------------+
11 rows in set (0.00 sec)
6 h0 _7 k# g( R) }% h- [
MariaDB [zabbix]> drop tables group_discovery group_prototype;
ERROR 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
MariaDB [zabbix]> drop tables group_discovery,group_prototype;
Query OK, 0 rows affected (0.11 sec)

8 T: L- X! ?' T% `1 ^+ F2 |MariaDB [zabbix]> drop tables groups,hosts,maintenances, screen_user,screen_usrgrp,screens,screens_items,slideshows,users;
2 w2 q+ c+ `1 H  {+ J" G3 W) h& [Query OK, 0 rows affected (0.28 sec)
( t' a# r! w7 [% K3 H
4 \: w5 M/ M6 i9 hMariaDB [zabbix]> show tables;
Empty set (0.00 sec)

7 ^0 E+ a& ~0 P4 n7 C. c: Q3 a