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°æ£¡
ÔÚÔËÐÐÖÐÊäÈëcmdºó,ÔÚÓÃnet start mysql
Ŷ лÀ²¡£¡£
......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table where instr('123456789' , ×ֶαí)
µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net ......
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 ......
¸Õ·¢µÄÌû×Ó²»¹»Ïêϸ£¬À´·¢¸öÏêϸµÄ¡£
1¡¢ÎÒÓô洢¹ý³Ì¶¯Ì¬Éú³ÉÊÓͼ¡£
2¡¢Ã¿¸ötableÔÚtime(ʱ¼ä´Á)×Ö¶ÎÉϾù×öÁËË÷Òý
3¡¢¸÷¸ötable½á¹¹Ò»Ñù£¬viewÀïÃæÓÃunion all£¬Ä¿µÄÊǰѼ¸ÕÅ±íÆ´³ÉÒ»ÕÅ¡°´ó±í¡±£¬Õâ¸öview¶ÔÍâ¾ÍÊDzéѯ±í¡£
ÏÂÃæÊǽ¨Á¢ÊÓͼµÄ´æ´¢¹ý³Ì£¬ÏêϸµÄÎҾͲ»½âÊÍÁË£¬ÏàÐÅÄܹ»»Ø´ðÎÒÕâ¸öÎÊÌâµÄ¶¼ ......
×î½üÔÚæ»îÒ»¸ö¿¼ÊÔϵͳ£¬ÓÉÓÚÌâ¿âÖÐÉæ¼°µ½Í¼Æ¬ÎÊÌ⣬²»ÖªµÀÈçºÎ½â¾ö£¡ÔÚ´ËÈõÈõµØÎÊһЩÎÊÌ⣬ϣÍû´óϺ²»Áߴͽ̣¡
1¡¢Ò»°ãÀ´Ëµ£¬Í¼Æ¬¶¼»á±»´æÔÚµ¥¶ÀµÄÒ»¸öÎļþ¼ÐÄÚ£¬Êý¾Ý¿âÖÐÖ»±£´æÍ¼Æ¬µÄ·¾¶¡£ÄÇô£¬Â·¾¶ÊDz»ÊÇÖ»ÄÜÓÃvarcharÐÍÄØ£¿
2¡¢¸ù¾ÝÉè¼ÆµÄÐèÒª£¬Ìâ¿âÀïµÄÊÔÌâ¶àÊýÊÇÖÐÎĵģ¬¿ÉÒÔÓÃtext¼òµ¥½â¾ö£¬µ«Í¼Æ ......