MysqlȨÏÞ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVIEWµÄȨÏÞÊÔһϡ£
SQL code:
select RPAD(left(a.phone,b.ÏÔʾλÊý),11,'*') from µç»°±í a,ȨÏÞ±í b where b.ȨÏÞ=1 ...;
½¨Òé¼ÓÒ»ÕÅȨÏÞ±í£¬²»Í¬È¨ÏÞÏÔʾ²»Í¬µÄλÊý
ϵͳ±¾Éí²¢Ã»ÓÐÌṩÕâÑùµÄȨÏÞ¡£
MYSQLµÄȨÏÞÖ»ÊÇÉæ¼°µ½Á˹ÜÀí·½ÃæµÄȨÏÞ¡£ÄãµÄÐèÇó¿ÉÒÔÀûÓôúÂëÀ´ÊµÏÖ¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐÐ
µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
ÕâÊÇʲôÎÊÌ⣡£¡£¡
ÎÒÒѾ֪µÀÁË£¡
&n ......
//´¦Àí1285¸ö´úÀíʱ¼ä£º³¬Ê±
/*
$query = "
update proxy,worldip
set proxy.code = worldip.code
where proxy.ip > worldip.start and proxy.ip < worldip.end";
*/
......