Forum Moderators: coopster

Message Too Old, No Replies

error viewing table in mysql

         

esha_salz

5:59 am on Sep 23, 2004 (gmt 0)

10+ Year Member



I log in to mysql (via command prompt)
show databases.. i get a list..
I zoom in to test1.. it contains 1 table within it..
Personal info.. So how do i view the contents in personal info.. I keep gettin error msgs.. like it doesnt exist..

Birdman

11:57 am on Sep 23, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If the table is really named "Personal info", then the space between the words is most likely causing the trouble.

Try enclosing the table name with backticks:

select * from `Personal info`

esha_salz

2:24 am on Sep 24, 2004 (gmt 0)

10+ Year Member



still cant get it

jatar_k

7:25 pm on Sep 24, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



are you getting any error messages?