数据库mariadb删除表操作记录

admin

Database changed
6 v( a% `, B# @) M' jMariaDB [zabbix]> show tables;
: J! \$ ~5 Z8 Y+------------------+
| Tables_in_zabbix |
+------------------+
| group_discovery  |
3 T+ v8 o3 r% e| group_prototype  |
| groups           |
| hosts            |
2 C' l$ v+ a% w| maintenances     |
, ?- u/ m7 M  J| screen_user      |
2 X/ g2 p3 r) ]: I| screen_usrgrp    |
| screens          |
% }. n# `9 |: i4 d! o| screens_items    |
| slideshows       |
| users            |
+------------------+
11 rows in set (0.00 sec)

5 q9 X  N+ U* Z( Q6 ~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
( [( u9 K( p  Q4 lMariaDB [zabbix]> drop tables group_discovery,group_prototype;
Query OK, 0 rows affected (0.11 sec)
2 U1 O; c8 C8 c" |# |
MariaDB [zabbix]> drop tables groups,hosts,maintenances, screen_user,screen_usrgrp,screens,screens_items,slideshows,users;
Query OK, 0 rows affected (0.28 sec)

MariaDB [zabbix]> show tables;
4 B6 d( h* e- p" \6 m2 kEmpty set (0.00 sec)
7 s1 Q6 p% p9 f