找回密码
 注册
查看: 466|回复: 0

数据库mariadb删除表操作记录

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2022-10-26 09:58:51 | 显示全部楼层 |阅读模式
Database changed2 S, @# ?/ O3 |+ u
MariaDB [zabbix]> show tables;5 h$ ?. U5 a7 k5 N! X, O( a7 b
+------------------+
; H9 \. i  E. e5 O/ b| Tables_in_zabbix |
5 h4 H+ v% {4 Q- C0 V+------------------+9 Y+ o& \" h3 z, _/ }% D
| group_discovery  |
% g6 s8 z% _6 P2 @| group_prototype  |
/ _) W& l2 ]4 k9 Y6 K2 K| groups           |6 T$ X" F6 v6 l( ]$ Q( O' c
| hosts            |
; U4 M" r5 d6 s8 W. t/ s. H: {3 F  k| maintenances     |4 V2 ^. Q; U% V5 N! K
| screen_user      |% n8 n& x- _0 Q0 y/ Y
| screen_usrgrp    |
" `. I. v' a! R+ J, ?- F| screens          |% f# ^8 |( M3 C/ R6 }1 i& b
| screens_items    |
/ T% d( M. [6 V$ H! g| slideshows       |# A  Q% P8 a6 ]5 \6 E, Q
| users            |& n9 f0 r2 ^8 `8 ]
+------------------+1 y9 k3 R' W$ ]9 s2 A
11 rows in set (0.00 sec)  _% \) _8 P$ h8 x4 ~- z6 Y
$ Q3 x/ _" G3 q" y& ?. w4 E
MariaDB [zabbix]> drop tables group_discovery group_prototype;7 j- V9 n4 v# \( o" j  }" n
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
% t& g& I6 V4 s/ @/ a1 |MariaDB [zabbix]> drop tables group_discovery,group_prototype;
4 q, _# w9 ~, \" R4 ]Query OK, 0 rows affected (0.11 sec)4 h# X+ k* \% x9 M3 Z: V

: F6 w: y5 h) y" y* AMariaDB [zabbix]> drop tables groups,hosts,maintenances, screen_user,screen_usrgrp,screens,screens_items,slideshows,users;2 {7 ?' f- ^8 ?' K; H
Query OK, 0 rows affected (0.28 sec)7 o& g3 J' k3 x- D3 x1 M

0 b% B$ V( }* F+ mMariaDB [zabbix]> show tables;7 p4 S% D, [  V
Empty set (0.00 sec)
+ k: k. x! T& _
9 T5 L! V1 \* g. v9 i$ D9 L* U+ E
. w4 w8 G  }0 I2 t  r7 O
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 02:29 , Processed in 0.020024 second(s), 21 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表