aeroswat Posted February 2, 2010 Share Posted February 2, 2010 I need a command that will give me a reference to just one table named tblOrders... what would that command look like? I can't find information on how to format it so I figured it might be something like this? SHOW TABLES WHERE TABLENAME='tblOrders' Link to comment https://forums.phpfreaks.com/topic/190719-mysql-show-tables/ Share on other sites More sharing options...
gizmola Posted February 2, 2010 Share Posted February 2, 2010 describe tblOrders. Link to comment https://forums.phpfreaks.com/topic/190719-mysql-show-tables/#findComment-1005775 Share on other sites More sharing options...
Orionsbelter Posted February 2, 2010 Share Posted February 2, 2010 $query="SELECT * FROM tblOrders": wouldn't that be it? Link to comment https://forums.phpfreaks.com/topic/190719-mysql-show-tables/#findComment-1005779 Share on other sites More sharing options...
Orionsbelter Posted February 2, 2010 Share Posted February 2, 2010 do you mean just show a set of results for one field in a table within the database. such as you have a table called SITE INFO in SITE INFO IS name domain description tlbOrders and you just want to show all from tlbOrders? Link to comment https://forums.phpfreaks.com/topic/190719-mysql-show-tables/#findComment-1005781 Share on other sites More sharing options...
gizmola Posted February 2, 2010 Share Posted February 2, 2010 I don't think we have any way of knowing. When someone brings ups the mysql show tables and asks about info for a specific table, I assume they're wanting the schema information. Link to comment https://forums.phpfreaks.com/topic/190719-mysql-show-tables/#findComment-1005807 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.