Simple SQL query

Expand Post »

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

Similar Threads

how to delete duplicate record in a table by using SQL query in MS SQL
sql query in MySQL
simple sql query in PHP
Format Number in Sql Query in Visual Basic 4 / 5 / 6
Sql Query Help in MySQL

squarkman

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Nov 2008

Permalink

Dec 18th, 2008

Re: Simple SQL query

Which database server you have with the hosting? The commands you are using are of MySQL.

mwasif

Reputation Points: 29

Solved Threads: 47

Posting Whiz

Offline

312 posts
since Dec 2007

Permalink

Dec 18th, 2008

Re: Simple SQL query

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...

sikka_varun

Reputation Points: 11

Solved Threads: 12

Junior Poster in Training

Offline

94 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: How select Documents which contain more than n tag-specified words

Next Thread in MySQL Forum Timeline: error:when special characters are inserted

DaniWeb Message

Cancel Changes

User Name
Password