List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 14 2005 8:37pm
Subject:Re: update row/tbl question...
View as plain text  
In the last episode (Oct 14), bruce said:
> a basic/new/curious question. i have the following sample tbl schema.
> i do the following update on the mysql command line and it updates
> for both cases. my question is why???
>
> update UserTBL set gid='25', usertype='Super Administrator11' where
> username='ADmin';
> update UserTBL set gid='25', usertype='Super Administrator11' where
> username='admin';
> 
> 'username' = 'admin' in the tabls...

Text fields are compared case-insensitively.

http://dev.mysql.com/doc/refman/4.1/en/case-sensitivity.html

-- 
	Dan Nelson
	dnelson@stripped
Thread
update row/tbl question...bruce14 Oct
  • Re: update row/tbl question...Dan Nelson14 Oct