Column name problem

dominant

I have a table that contains a column name like (rich people)

I cannot now retrieve any data from that table.

Any ideas on how to overcome this problem?

Selinaar

Fields in tables are not to be read case_sensitive from what I understand, e.g. it doesn't matter if RICHPEOPLE or richpeople or a mix of such.

However with spaces in fieldnames i'm not sure, you might want to try a - or a _ for example. Special Chars like ( or ) or [ should not be used or can't even be used, I remember to have read that once.

dominant

I cannot figure out this problem.

I used

select rich - people from table

but i revieved an error message.

If i put

select rich  people from table

It renames the rich field to people ( but still can;t retrieve any data from rich people field)

Selinaar

Try this :

SELECT rich_people FROM table

The fieldname in the table must be rich_people, not rich people.

If you do it like that, it would be :

SELECT rich,people FROM table

Means, you have _two_fields, one named rich and one named people.

Here is a link for you to get you an idea about MySQL queries :

http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Retrieving_data

Damien_Buttler

Why don't you try a query like "show columns from table" to see what it returns. It may give you the answer.

Damien.

dominant

I put the _ but notthing happend, i recieved error messages.

I ran a SHOW COLUMNS and the fieldname is rich people 🙁

I don't know what is going on, do you? 🙁

Selinaar

ALTER TABLE 'yourtable' CHANGE 'fieldname' 'rich_people' VARCHAR( 50 ) NOT NULL

Replace 'yourtable' with the name of the table where 'fieldname' is saved in - and 'fieldname' must be the current name of the field, then 'rich_people' will be the new name. VARCHAR (50) and NOT NULL is only the way the data is stored, replace these with the values you have in your table for that 'fieldname'.

Or try this :

SELECT 'rich people' from TABLE
SELECT "rich people" from TABLE

I'm still learning, so I do not know if it works if you put the fieldname into quotes.

dominant

SELECT 'rich people' from TABLE

It gives a field name with content rich people -> useless i think

I solved my problem vy renaming the field name from ruch people to ruchpeople