update row/tbl question...

2005-10-14 Thread bruce
hi... 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??? it was my understanding that the two cases are different and shouldn't both be triggered.the value of 'username' in

Re: update row/tbl question...

2005-10-14 Thread Dan Nelson
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