数据库mariadb删除表操作记录

admin

Database changed
" M. @+ [4 E3 c+ l. B  SMariaDB [zabbix]> show tables;
+------------------+
| Tables_in_zabbix |
+------------------+
| group_discovery  |
| group_prototype  |
| groups           |
| hosts            |
| maintenances     |
| screen_user      |
| screen_usrgrp    |
6 ^/ i- w( X5 [6 p& ?| screens          |
| screens_items    |
, l7 Y5 u; n) N+ A# M| slideshows       |
/ ?/ R; u, T; t7 K- R| users            |
4 w, R& B0 d( \  k' P+------------------+
11 rows in set (0.00 sec)
( Y5 z0 t6 t/ F/ e7 Q+ x0 L
, b# W" M4 k9 DMariaDB [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)
7 ]- G' s9 ]6 W! k
MariaDB [zabbix]> drop tables groups,hosts,maintenances, screen_user,screen_usrgrp,screens,screens_items,slideshows,users;
3 M) p# u' e2 }5 dQuery OK, 0 rows affected (0.28 sec)
# b% a5 N* x/ d# h% i  J
; y& V/ E; a: T- zMariaDB [zabbix]> show tables;
Empty set (0.00 sec)
; E$ K; ~  H$ ?" S; w# E
2 P2 B* |7 M& V/ X: M