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' Quote Link to comment Share on other sites More sharing options...
gizmola Posted February 2, 2010 Share Posted February 2, 2010 describe tblOrders. Quote Link to comment 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? Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.