如何从MySQL中的数据库检索表名？
要从MySQL中的数据库检索表名，语法如下-
show tables from yourDatabaseName;
让我们实现上述查询，以便从MySQL中的数据库检索表名-
mysql> show tables from hb_student_tracker;
这将产生以下输出-
+------------------------------+ | Tables_in_hb_student_tracker | +------------------------------+ | demotable192 | | demotable193 | | demotable194 | | demotable195 | | demotable196 | | demotable197 | | demotable198 | | demotable199 | | demotable200 | | demotable201 | | demotable202 | | demotable203 | | demotable204 | | demotable205 | | demotable206 | | demotable207 | | demotable208 | | demotable209 | | demotable210 | | demotable211 | | demotable212 | | demotable213 | | demotable214 | | demotable215 | | demotable216 | | demotable217 | | demotable218 | | demotable219 | | demotable220 | | demotable221 | | demotable223 | | demotable224 | | demotable225 | | demotable226 | | demotable227 | | demotable228 | | demotable229 | | demotable230 | | demotable231 | | demotable232 | | demotable233 | | insertcurrentdate | | reorderintegerexcept0 | | student | +------------------------------+ 44 rows in set (0.00 sec)
热门推荐
1 如何训练狗狗不叫
2 训练狗狗不叫
3 训练狗狗随行
4 怎么训练狗狗不叫
7 训练比熊狗狗教程
10 上海狗狗训练
11 怎么训练狗狗上厕所
12 训练狗狗趴下
13 狗狗服从训练
14 训练狗狗拒食
15 训练狗狗笑
16 训练狗狗大便
17 训练狗狗立
18 训练狗狗捡东西