数据库mariadb删除表操作记录

admin

Database changed
MariaDB [zabbix]> show tables;
0 m3 B; p$ F6 F4 l* x! ^$ a+------------------+
| Tables_in_zabbix |
+------------------+
  }& H/ y8 ^. m| group_discovery  |
| group_prototype  |
' a7 l8 H! L8 _1 Y  I8 t| groups           |
| hosts            |
  [" \# b/ r+ |8 c| maintenances     |
| screen_user      |
  ~" A' d( Q9 ]/ z* N| screen_usrgrp    |
6 j9 ?0 U) @7 \* z; g! U( f/ ?. N| screens          |
/ n( x1 ^4 ]& M7 _* u5 q| screens_items    |
; Q: y  }* x6 U9 U# T  Q4 i| slideshows       |
: h% h) r' N0 P/ `| users            |
# ?: i: W- L; M* _+ B0 r+------------------+
& S" Q4 _! q8 ^* N7 y* E11 rows in set (0.00 sec)

" e) B! a, C$ q# |# N; m$ P( hMariaDB [zabbix]> drop tables group_discovery group_prototype;
6 l5 X2 n/ x  l( M; {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)

MariaDB [zabbix]> drop tables groups,hosts,maintenances, screen_user,screen_usrgrp,screens,screens_items,slideshows,users;
$ v  u; j6 t% q; H% A& BQuery OK, 0 rows affected (0.28 sec)

MariaDB [zabbix]> show tables;
Empty set (0.00 sec)
8 T1 F0 q5 b$ Q% \$ B4 [& i6 O
4 G1 Z' i, P+ ]) ^0 d' y: C7 p, \
) e5 P) s' u' @5 |9 F