Çë½ÌÒ»¸öСÎÊÌâ delphi+mysql sqlÓï¾äÎÊÌâ
ÎÒ±íÀïÓиö×Ö¶Î operator ÎÒÏëselect * from table where operator="" operator×Ö¶ÎΪ¿ÕÖµµÄ ÄÚÈÝ ÎªÊ²Ã´ÎÒÕâÓï¾äͨ¹ý²»ÁËÄØ ±íÀïÓкöàÊý¾Ý ÆäÖÐÓв¿·Öoperator×Ö¶ÎֵΪ¿Õ ×Ö¶ÎÀàÐÍΪstring ÇëÖ¸µãÏ лл
ͬ¥ÉÏ
Êý¾Ý¿âÀïµÄ¿ÕÖµºÍ¿Õ¸ñ²»ÊÇÒ»»ØÊ£¬ºÇºÇÓÃIS NULL
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
hongqi162¡¢windindance
´Ë2È˳¤ÆÚ²»ÔÚÏߣ¬ÌرðÊÇwindindance
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
hongqi162»¹ÊǾ³£ÉÏÀ´×ª×ªµÄ
ÒýÓÃ
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
ÆäʵҲ²»ÊÇʲôÄÜÁ¦µÄÔÒò£¬Ö÷Òª¿ÉÄÜÊÇʱ¼äÎÊÌâ°É
¹¤×÷µÄ»¹ÒªÉÏ°à£¬Ñ§Ï ......