discuz mysql like_Discuz 添加选吧的一段MySQL监控

080727 15:16:00 27 Connect discuz@localhost on

27 Query SET character_set_connection=gbk, character_set_results=gbk, character_set_client=binary

27 Query SET sql_mode=''

27 Init DB discuz

27 Query SELECT * FROM uchome_session WHERE uid='1' AND password='c23f845b1ebdd7dd5c16621bee324c2b'

27 Query SELECT sf.note, sf.privacy, sf.friend, sf.feedfriend, sf.resideprovince, sf.residecity, s.* FROM uchome_space s

LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid

WHERE s.uid='1'

27 Query SELECT tagid, uid FROM uchome_tagspace WHERE uid='1'

27 Query SELECT * FROM uchome_mtag WHERE tagname IN ('tagschool','tagcity','tagbook')

27 Query INSERT INTO uchome_mtag (`tagname`, `fieldid`, `membernum`) VALUES ('tagschool', )

', '1')

27 Query INSERT INTO uchome_mtag (`tagname`, `fieldid`, `membernum`) VALUES ('tagcity', '2', '1')

27 Query INSERT INTO uchome_mtag (`tagname`, `fieldid`, `membernum`) VALUES ('tagbook', '3', '1')

27 Query INSERT INTO uchome_tagspace (tagid,uid,username) VALUES ('1','1','admin'),('2','1','admin'),('3','1','admin')

27 Quit