[Gllug] MySql problem...

[Jason Clifford]

On Tue, 20 May 2003, Kristian Davies wrote:

> I have managed to get mysql up and running and I have created a few
> tables... But.... I seem to have done something I shouldn't and it seems to
> have let me..
> 
> I have created a field within a table with a dot in it. i.e.. Within Table
> "users" a field called "user.name" instead of "user_name" 
> 
> When I open the table for edit, it allows me to press delete and it
> disappears but then when I try an exit I get "[MyHost] ERROR 1091: Can't
> DROP 'name'. Check that column/key exists" and thus it wont let me save.  I
> have also tried a few things from the command line which more or less give
> the same error.

Where you have created a field with a name that does not fit with standard 
mysql clients due to an invalid character you need to quote the field in 
all query statements.

You do this like so, using backticks to quote the invalid field:

select `user.name` from table where condition = 'whatever';

Jason Clifford
-- 
UKFSN.ORG		Finance Free Software while you surf the 'net
http://www.ukfsn.org/			Sign up now
UKPOST.COM	 	           get your @ukpost.com address now...
http://www.ukpost.com/	 	   professional hosting and colocation



-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug