Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚmysql×Ó²éѯµÄÎÊÌâ¡£

ÎÒµÄsqlÓï¾äÈçÏ£º
select uid  from UserSource us  where us.SourceID = '6c19a70397ed4770'£¬ »áÓÐÈçϽá¹û£º
13637,14147,14270,14659,14708,14926,15117,15150,15796,16104,16217,16247,16271,17858,17877,18088,18282,18316,18438,18504,18811,19213,19499,19799,19855,19857,20110,20355,20384,20428,20537,21402,21560,21561,21562,21563,21564,21565,21566,21567,21568,21569,21570,21571,21572,21573,21574,21575,21576,21577,21578,21579,21580,21581,21583,21584,21585,21586,21587,21588,21589,21590,21591,21592,21594,21595,21596,21598,21599,21600,21601,21602,21603,21606,21609,21610,21611,21612,21613,21616,21617,21618,21619,21620,21621,21622,21623,21624,21625,21626,21627,21628,21629,21631,21632,21633,21634,21635,21636,21637
Ò»¹²ÊÇ100¸ö¡£

ÎÒÈç¹ûд
select * from Users where id in(13637,14147,14270,14659,14708,14926,15117,15150,15796,16104,16217,16247,16271,17858,17877,18088,18282,18316,18438,18504,18811,19213,19499,19799,19855,19857,20110,20355,20384,20428,20537,21402,21560,21561,21562,21563,21564,21565,21566,21567,21568,21569,21570,21571,21572,21573,21574,21575,21576,21577,21578,21579,21580,21581,21583,21584,21585,21586,21587,21588,21589,21590,21591,21592,21594,21595,21596,21598,21599,21600,21601,21602,21603,21606,21609,21610,21611,21612,21613,21616,21617,21618,21619,21620,21621,21622,21623,21624,21625,21626,21627,21628,21629,21631,21632,21633,21634,21635,21636,21637)
ÄÇô¿ÉÒÔÕý³£²éѯ

µ«ÊÇÈç¹ûÎÒд³É£ºselect * from Users wh


Ïà¹ØÎÊ´ð£º

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

mysqlÖкóÍËÃüÁ

mysql>create book(
    ->id varchar(20) not null,g
    ->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......

MYSQL 5.0£¬ÊÂÎñ»Ø¹öµÄÎÊÌâ

½¨±í£º²å¼Ç¼
SQL code:

create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ