#mysql - Sun 15 Apr 2007 between 00:07 and 00:23



EdsipeRhow can I do a query looking for NULL fields?
I want to update my table, and some rows had NULL values, I would like to replace them with a zero value
chadmaynardEdsipeR: SELECT ... FROM .... WHERE column IS NULL;
EdsipeRthe query "WHERE some_field=NULL" doesn't work
chadmaynardUPDATE table SET column = 0 WHERE column IS NULL
EdsipeRIS NULL , THANKS!
chadmaynardEdsipeR: something can't = NULL in the traditional sense.... it can only be null
EdsipeRahh
thanks
apolohi
the_wenchGreetings apolo
apoloanybody here?
thanks god u r here
i need ur kind help
i have changed the password in user table in mysql database, stupidityyyy
now im trying to connect to mysql i can not
chadmaynardfor the root user?
apolowhat should i do?
the_wenchdepends....
apoloyes
for root user
chadmaynardrestart mysql with --skip-grant-tables and fix it
Xgcapolo: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
chadmaynardhi Xgc
XgcEvening.
apoloXgc does taht work?
what is the latest job to do abou it?
if u where me
?!?!?
chadmaynardapolo: that's the manual....
apolothxxxx
chadmaynardapolo: what OS are you on?
apoloill back if i face to problem
ubuntu
the_wenchUbuntu is an ancient African word meaning 'I can't configure Debian'
chadmaynardyep its easy.
just make sure you stop mysql with /etc/init.d/mysqld stop
then follow the instructions
starting at step 3
klingonHow do I have mysql order a row by number.. ie 1,3,6,8,10,12 not 1,10,13,2,20 etc.?

Page: 2 9 16 23 30 37 44 

IrcArchive