LinuxÖÐÈý»ùÉ«RGB°×ɫΪʲôÊÇ254£¬¶øWindows ÏÂÊÇ255£¿Çó½â¡£¡£¡£
²»ÄܰÑ
ʲô²»ÄÜ£¿
ÄãÔÚÄĶù¿´µ½Õâô˵µÄѽ
ÎÒÒ²²»ÏþµÃ¹þ£¬Ö»ÊÇÎÒÃÇÀÏʦ˵µÄ£¬È»ºóÈÃÎÒÃÇÕÒÔÒòµÄ£¬ÔÚÍøÉϸù±¾¾Í²é²»µ½
......
LinuxÏÂ×ö2¸öỊ̈߳¬Ò»¸öÿ¸ô0.5sÏÔʾ£¬ÁíÒ»¸öÿ¸ô0.8sÏÔʾ³öÀ´
1¸öCÏ·Å2¸öÏß³Ì
Ë»á×öµÄ£¬ËÙ¶È~~~~
ʹÓÃselect¾ÍOKÁË
pthread_create ´´½¨Ïß³Ì
timer Õû¸ö¶¨Ê±Æ÷
»¹ÊDz»Ì«Ã÷°×£¬ÓÐÍêÕûµÄ¹ý³Ìô
ÒýÓÃ
pthread_create ´´½¨Ïß³Ì
timer Õû¸ö¶¨Ê±Æ÷
ɶʱºò»ìÕâ±ßÁË£¿
5LÕæËÙ¶È£¬lzÕæÀÁ£¬¼ ......
Á½¸ö¶à±íÁª²é¶àÓï¾ä
µÚÒ»¸ö±íÊÇ A BÁ½±í²é³ö
ID
1
2
3
4
5
µÚ¶þ¸ö±íÉÌ A B CÈý±í²é³ö
3
4
5
ÎÊÈçºÎ°ÑʣϵÄ1£¬2Ò²²é³öÀ´
×îºÃÌù³öSQLÓï¾ä
union all ??
»òÕß×óÁ¬½Ó
SQL code:
select * from a left join b on a.id=b.id
°ï¶¥£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
Éæ¼°Êý¾Ý¿â±íµÄÉè¼Æ£¬Ä ......
Ò»±í
ÐÕÃû | 1 | 2 | 3 | 4 | 5 |¡£¡£¡£¡£¡£¡£
ÕÅÈý ʼ٠²¡¼Ù ʼ٠²¡¼Ù ²¡¼Ù¡£¡£¡£¡£¡£
ÀîËÄ »é¼Ù ³ö²î ³ö²î ³ö²î ³ö²î
ÈçºÎµÃ³ö
ÐÕÃû ʼ٠²¡¼Ù »é¼Þ ³ö²î¡£¡£¡£¡£
ÕÅÈý 2 3 0 0
ÀîËÄ 0 0 1 4
¼ÙÈçÐкÍÁеÄÄÚÈݶ¼Êǹ̶¨µÄ£¬¿ ......
ÇóÒ»ÌõSQLÓï¾ä¡£ÈçÏÂ
±í a
id Ö÷¼ü
²¿ÃÅ id
Ô±¹¤ÐÕÃû
ѧÀú
±í b
id Ö÷¼ü
²¿ÃÅÃû
±í c
ѧÀú id
ѧÀúÃû
Çó±í
²¿ÃÅa ²¿ÃÅb ²¿ÃÅc ²¿ÃÅd
³õÖÐ x x x x
¸ßÖÐ x x x x
´óר x x x x
´óѧ x x x x
ͳ¼Æ ÈËÊý
°ï¶¥~~
x x x x &n ......
дһ¸öSQlÓï¾äµÃµ½Ò»¸ö±íµÄ×îºóÒ»ÐеÄÖµ£¿
SQL code:
select top 1 * from tb order by id desc
Êý¾Ýû¹æÂÉ£¿1Â¥µÄÓï¾ä³ý·ÇÄãidÊÇ×ÔÔöÁС£·ñÔò²»ºÃ´¦Àí¡£
SQL code:
select top 1 * from tb order by id desc
Èç¹ûÓÐidµÄ»°¡£
Ó¦¸Ã°ÑÄãÕâ¸ö±íµÄÌØÕ÷˵³öÀ´£¬±ÈÈçÓÐʲô±È½ÏÌØÊâµÄ×ֶΡ£¡£±ÈÈç×ÔÔöÁеȡ£
Èç¹û ......