| EdsipeR | how 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 |
| chadmaynard | EdsipeR: SELECT ... FROM .... WHERE column IS NULL; |
| EdsipeR | the query "WHERE some_field=NULL" doesn't work |
| chadmaynard | UPDATE table SET column = 0 WHERE column IS NULL |
| EdsipeR | IS NULL , THANKS! |
| chadmaynard | EdsipeR: something can't = NULL in the traditional sense.... it can only be null |
| EdsipeR | ahh thanks |
| apolo | hi |
| the_wench | Greetings apolo |
| apolo | anybody 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 |
| chadmaynard | for the root user? |
| apolo | what should i do? |
| the_wench | depends.... |
| apolo | yes for root user |
| chadmaynard | restart mysql with --skip-grant-tables and fix it |
| Xgc | apolo: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html |
| chadmaynard | hi Xgc |
| Xgc | Evening. |
| apolo | Xgc does taht work? what is the latest job to do abou it? if u where me ?!?!? |
| chadmaynard | apolo: that's the manual.... |
| apolo | thxxxx |
| chadmaynard | apolo: what OS are you on? |
| apolo | ill back if i face to problem ubuntu |
| the_wench | Ubuntu is an ancient African word meaning 'I can't configure Debian' |
| chadmaynard | yep its easy. just make sure you stop mysql with /etc/init.d/mysqld stop then follow the instructions starting at step 3 |
| klingon | How do I have mysql order a row by number.. ie 1,3,6,8,10,12 not 1,10,13,2,20 etc.? |