 |  |  |  |  |  |  |  |
Simple SQL query
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I'm using the Brinkster control panel Database Manager to investigate a database on a site I just took over. I don't know anything about the database. I tried a SHOW TABLES and got an error. I also tried SHOW ALL. Do you think I need a ; after the command or something?
Thx
Thx
•
•
Join Date: Dec 2008
Posts: 94
Reputation: 
Solved Threads: 11
Junior Poster in Training
Since you have posted on MySQL Community, then it seems you are using MySQL.. Yes mysql demands its queries to be ended with a semicolon... Bt this mostly happens when you use the command line interface....
I dont think this should be an issue when you run a query on a database manager, it should give an error without a ;
So just try this once... no harm in it...
I dont think this should be an issue when you run a query on a database manager, it should give an error without a ;
So just try this once... no harm in it...
|
Similar Threads
- how to delete duplicate record in a table by using SQL query (MS SQL)
- sql query (MySQL)
- simple sql query (PHP)
- Format Number in Sql Query (Visual Basic 4 / 5 / 6)
- Sql Query Help (MySQL)
- SQL query problem with WHERE clause (ASP)
- Please help me out with MySQL query (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: How select Documents which contain more than n tag-specified words
- Next Thread: error:when special characters are inserted
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 email enter enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword kickfire laptop legal license licensing linux maintenance mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird virtualization
