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

MysqlȨÏÞ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVIEWµÄȨÏÞÊÔһϡ£


SQL code:
select RPAD(left(a.phone,b.ÏÔʾλÊý),11,'*') from µç»°±í a,ȨÏÞ±í b where b.ȨÏÞ=1 ...;

½¨Òé¼ÓÒ»ÕÅȨÏÞ±í£¬²»Í¬È¨ÏÞÏÔʾ²»Í¬µÄλÊý


ϵͳ±¾Éí²¢Ã»ÓÐÌṩÕâÑùµÄȨÏÞ¡£

MYSQLµÄȨÏÞÖ»ÊÇÉæ¼°µ½Á˹ÜÀí·½ÃæµÄȨÏÞ¡£ÄãµÄÐèÇó¿ÉÒÔÀûÓôúÂëÀ´ÊµÏÖ¡£


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

MySql Hibernate ²éѯÓï¾äÎÊÌâ - Java / Java EE


hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐР
 µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
  ÕâÊÇʲôÎÊÌ⣡£¡£¡

ÎÒÒѾ­ÖªµÀÁË£¡
&n ......

ÖØ´óÎÊÌ⣬mysql¸øÎÒ³öÁ˸ö´óÄÑÌâ - PHP / »ù´¡±à³Ì

//´¦Àí1285¸ö´úÀíʱ¼ä£º³¬Ê±
/*
$query = "
update proxy,worldip
set proxy.code = worldip.code
where proxy.ip > worldip.start and proxy.ip < worldip.end";
*/
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ