Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 帮忙改下一条查询语句,该怎么处理

帮忙改下一条查询语句,该怎么处理

WBOY
Release： 2016-06-13 13:34:38
Original
768 people have browsed it

帮忙改下一条查询语句
SHOW TABLES

显示的当前数据表名称，
但是这个结果集的列名称是"Tables_in_myoffice"，myoffice是我的数据库名，我想把它设定为一个常量字符串，比如
"tbnames"，应该怎么写到这个查询语句里去？
show tables as "tbnames";
好像不对呀

------解决方案--------------------
SHOW 不支持用 AS 。
不一定非要这样做，你完全可以按数字索引来取值 mysql_fetch_row() mysql_result();

Related labels：
quot
source：php.cn
Previous article： curl 无法解析主机解决方法 Next article： 求解PHP中遇到的有关问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
How to trigger render (with filter and pagination) on sort method in React? Here is my Sort.js style component: <SortWrapper><SortText>SortBy</SortText...
From 2024-04-06 21:28:37
0
1
2257
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template