Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

C#Á¬½ÓMYSQL£¬¶ÁÈ¡ÖÐÎÄÎÊÌâ

MySQLConnection DBConn;
DBConn = new MySQLConnection(new MySQLConnectionString("localhost" , "admin" , "root" , "123456" , 3306).AsString);
DBConn.Open();
MySQLCommand DBComm;
DBComm = new MySQLCommand("select * from tb1" , DBConn);
My ......

mysql...

ÔÚMySQLµÄÖ¸Áî´°ÀïÃæÊäÍêÃÜÂëºó È»ºóÉÁÒ»ÏÂÖ¸Áî´°¾ÍûÁË
ʲôԭÒò°¡£¿
ÐÂÊÖ°¡ Íü¸÷λǰ±²Ö¸µ¼Ó´¡£¡£¡£
ÎÊ´íµØ·½ÁË£¬È¥MYSQL°æ£¡


ÔÚÔËÐÐÖÐÊäÈëcmdºó,ÔÚÓÃnet start mysql

Ŷ  лÀ²¡£¡£
......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table where instr('123456789' , ×ֶαí)



µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net ......

mysql²éѯsqlÓï¾ä

mysqlÓбíA:

id  num
1    4
2    9
3    14
4    20
5    25


±íB:

id start end
1  0    5
2  6    10
3  11    15

ÔõôÄܲéѯµ½´æÔÚÓÚ±íBÖÐÈÎÒ»µÄsta ......

mysqlÈçºÎÈÃÊÓͼÀûÓÃË÷Òý£¿

¸Õ·¢µÄÌû×Ó²»¹»Ïêϸ£¬À´·¢¸öÏêϸµÄ¡£

1¡¢ÎÒÓô洢¹ý³Ì¶¯Ì¬Éú³ÉÊÓͼ¡£
2¡¢Ã¿¸ötableÔÚtime(ʱ¼ä´Á)×Ö¶ÎÉϾù×öÁËË÷Òý
3¡¢¸÷¸ötable½á¹¹Ò»Ñù£¬viewÀïÃæÓÃunion all£¬Ä¿µÄÊǰѼ¸ÕÅ±íÆ´³ÉÒ»ÕÅ¡°´ó±í¡±£¬Õâ¸öview¶ÔÍâ¾ÍÊDzéѯ±í¡£

ÏÂÃæÊǽ¨Á¢ÊÓͼµÄ´æ´¢¹ý³Ì£¬ÏêϸµÄÎҾͲ»½âÊÍÁË£¬ÏàÐÅÄܹ»»Ø´ðÎÒÕâ¸öÎÊÌâµÄ¶¼ ......

¹ØÓÚmysql´æÈ¡Í¼Æ¬µÄÎÊÌâ

×î½üÔÚæ»îÒ»¸ö¿¼ÊÔϵͳ£¬ÓÉÓÚÌâ¿âÖÐÉæ¼°µ½Í¼Æ¬ÎÊÌ⣬²»ÖªµÀÈçºÎ½â¾ö£¡ÔÚ´ËÈõÈõµØÎÊһЩÎÊÌ⣬ϣÍû´óϺ²»Áߴͽ̣¡

1¡¢Ò»°ãÀ´Ëµ£¬Í¼Æ¬¶¼»á±»´æÔÚµ¥¶ÀµÄÒ»¸öÎļþ¼ÐÄÚ£¬Êý¾Ý¿âÖÐÖ»±£´æÍ¼Æ¬µÄ·¾¶¡£ÄÇô£¬Â·¾¶ÊDz»ÊÇÖ»ÄÜÓÃvarcharÐÍÄØ£¿

2¡¢¸ù¾ÝÉè¼ÆµÄÐèÒª£¬Ìâ¿âÀïµÄÊÔÌâ¶àÊýÊÇÖÐÎĵģ¬¿ÉÒÔÓÃtext¼òµ¥½â¾ö£¬µ«Í¼Æ ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [240] [241] [242] [243] 244 [245] [246] [247] [248] [249]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ