#mysql - Thu 22 Feb 2007 between 00:09 and 01:04

i'll take "languages who's names start with "p" for 100!"
... wait.
snooplsmhow 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 );
Xgcsnooplsm: Not unless you have an old version of MySQL: select version();
fr33mindIs it possible to have a second mysql server in backup and replicate the database every 10 minutes ?
is there some replication mechanism in mysql?
the_wenchreplication 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_wenchsee http://dev.mysql.com/doc/refman/5.0/en/replication.html
fr33mindreplication work well and is real time?
Too cool to be true... ;)
tWiZtErWHERE 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'
whats the best way to store a timestamp
unix time
i want to order by ity
litheumthe timestamp column would be a good place to start
SteveMarburydo i store it as a string?
when i insert
litheumthe timestamp data type
upgrayeddSteveMarbury: the timestamp format is the best way. You can index and sort using that index just fine
litheumyou can either use a function call, have it set the current timestamp automatically, provide a timestamp string, etc

Page: 2 9 16 23 30 37 44