| ily | ^^ |
| yoonil | php |
| wladek_ | python |
| _Steve_ | perl i'll take "languages who's names start with "p" for 100!" |
| wladek_ | pascal! |
| torm3nt | PROGRAMMING ... wait. |
| wladek_ | d'oh |
| snooplsm | how do I clear the mysql shell? so that it flushes my screen and makes it perty anything wrong w/ select p.pname from parts p where p.pid in ( select c.pid from catalog c ); |
| Xgc | snooplsm: Not unless you have an old version of MySQL: select version(); |
| fr33mind | Is it possible to have a second mysql server in backup and replicate the database every 10 minutes ? is there some replication mechanism in mysql? |
| Xgc | replication |
| the_wench | replication is restore from a backup and then an ongoing application of the binary log. You can think of replication as a constantly running recovery. |
| predder | !man replication |
| the_wench | see http://dev.mysql.com/doc/refman/5.0/en/replication.html |
| fr33mind | replication work well and is real time? Too cool to be true... ;) ? |
| tWiZtEr | WHERE CHAR_LENGTH(lastname)+CHAR_LENGTH(firstname) > 180 how do i do a query like that? i got it that worked ;) |
| u-p-g-r-a-y-e-d- | aw... it didn't get the second "D' |
| SteveMarbury | hey whats the best way to store a timestamp unix time i want to order by ity |
| litheum | the timestamp column would be a good place to start |
| SteveMarbury | do i store it as a string? when i insert |
| litheum | the timestamp data type |
| SteveMarbury | '$time' |
| upgrayedd | SteveMarbury: the timestamp format is the best way. You can index and sort using that index just fine |
| litheum | you can either use a function call, have it set the current timestamp automatically, provide a timestamp string, etc |
| SteveMarbury | right |