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

数据库mariadb删除表操作记录

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2022-10-26 09:58:51 | 显示全部楼层 |阅读模式
Database changed
5 w7 w; d0 v; }$ r: A% xMariaDB [zabbix]> show tables;
4 ^, @0 X+ s/ l9 I( U0 P+------------------+
0 ^! q& U/ ?4 {0 p| Tables_in_zabbix |
% a  n# k1 }( Q4 F9 B( y. {+------------------+
* M. {8 K; @/ \0 R$ u| group_discovery  |
1 n- r0 ]9 v& V4 m- i# `; U2 z) \| group_prototype  |3 d' p; J8 ]; l) E4 O1 o# ^8 O6 K0 n
| groups           |
& f1 X$ @$ r) L  d( a| hosts            |
5 e* v2 [( k1 j: y. n0 b7 ]| maintenances     |7 u) ]. P+ m! Z
| screen_user      |
% m$ _) N% Q+ i, R| screen_usrgrp    |
3 t$ B1 q8 o; S0 d6 O- M| screens          |, P" x7 w/ g) ^6 R8 X5 F* r
| screens_items    |
1 z8 {; @4 v+ H. Y, @) {| slideshows       |
) K6 X$ Q# [5 ^# Q| users            |
/ C4 v1 T" o( q+------------------+, q- k) T* L* m1 d/ A3 f
11 rows in set (0.00 sec)
* m, B. [  s) K6 }+ _
! ?0 S( x$ e: h$ U/ CMariaDB [zabbix]> drop tables group_discovery group_prototype;. y; |( \& r; i5 q* 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, z# c/ ~& t' y; d$ V5 ?, h: O+ |
MariaDB [zabbix]> drop tables group_discovery,group_prototype;
- L2 t1 `6 r; J- a9 D4 }* F5 DQuery OK, 0 rows affected (0.11 sec): T, X$ {+ l$ P( k

/ ?; r$ C1 J  |MariaDB [zabbix]> drop tables groups,hosts,maintenances, screen_user,screen_usrgrp,screens,screens_items,slideshows,users;! j3 a7 H8 Z4 j
Query OK, 0 rows affected (0.28 sec)
* \6 V' v" H& y% ]
( A! p* F/ X7 W8 RMariaDB [zabbix]> show tables;
; h/ `7 W/ I# U8 ^Empty set (0.00 sec)9 L: g3 ]- {/ X  e
; s5 y; U" e9 \8 H2 c; s

! q2 O( S3 N, T
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

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

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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