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

数据库mariadb删除表操作记录

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2022-10-26 09:58:51 | 显示全部楼层 |阅读模式
Database changed
9 X! x( P& O( z  X' N$ jMariaDB [zabbix]> show tables;! M. {  F# S' k( g" O2 [
+------------------+
) P4 X0 l' P% _0 B/ Y0 j, q( v| Tables_in_zabbix |$ C/ N" I. \- P3 Z! Q- N- e
+------------------+
, B) r2 S/ Z# ^: `8 r| group_discovery  |
" o8 l% @3 G( ~, }| group_prototype  |4 b% ]0 ]8 B6 @6 o' G: T; D
| groups           |: A) x  l) q; E4 A
| hosts            |
7 ^  \& \2 p$ G3 _) a2 b| maintenances     |
$ O- H+ B' u% g& J" c$ k| screen_user      |
4 W8 Q9 D% ^; `" q3 s% l5 G| screen_usrgrp    |
: b% v" f8 O, X! ]! f| screens          |
4 V$ G" a" M% x- A| screens_items    |8 [1 z" X1 {; O! a
| slideshows       |8 @: t0 Z' b5 }- u  I2 G; M
| users            |
) w0 a5 ]/ f- R+------------------+) |# \6 C0 p4 ?* C
11 rows in set (0.00 sec)! i; F9 f% }. q% A. K8 z( Q

: l6 L2 B/ F0 U; D; mMariaDB [zabbix]> drop tables group_discovery group_prototype;
' r1 u# u# e+ [7 wERROR 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 13 K( Z* r- [4 a  E/ Q
MariaDB [zabbix]> drop tables group_discovery,group_prototype;
9 E$ F4 O8 l; l0 `3 D. G+ s# sQuery OK, 0 rows affected (0.11 sec), n/ n0 M- _4 r

( y8 G. o9 W  m* GMariaDB [zabbix]> drop tables groups,hosts,maintenances, screen_user,screen_usrgrp,screens,screens_items,slideshows,users;
, z9 l9 K3 f; i3 m1 lQuery OK, 0 rows affected (0.28 sec)
7 C8 I3 u6 ]" ~6 ]& V* M/ [2 h( p) p0 _+ v
MariaDB [zabbix]> show tables;% @, t% o9 |4 R) ^& W
Empty set (0.00 sec)1 y$ x4 w1 n2 l2 j" u4 j
. z0 n8 v* ?" b1 X. [0 W3 t
& J" _- i  Z" v8 A1 I6 I
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2026-6-12 00:18 , Processed in 0.014290 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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