MysqlȨÏÞ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVIEWµÄȨÏÞÊÔһϡ£
SQL code:
select RPAD(left(a.phone,b.ÏÔʾλÊý),11,'*') from µç»°±í a,ȨÏÞ±í b where b.ȨÏÞ=1 ...;
½¨Òé¼ÓÒ»ÕÅȨÏÞ±í£¬²»Í¬È¨ÏÞÏÔʾ²»Í¬µÄλÊý
ϵͳ±¾Éí²¢Ã»ÓÐÌṩÕâÑùµÄȨÏÞ¡£
MYSQLµÄȨÏÞÖ»ÊÇÉæ¼°µ½Á˹ÜÀí·½ÃæµÄȨÏÞ¡£ÄãµÄÐèÇó¿ÉÒÔÀûÓôúÂëÀ´ÊµÏÖ¡£
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......
mysql¶¨Ê±±¸·Ý ÔÚwindowsÉÏ
¿ÉÒÔÏÂÔØÒ»¸ö Navicat for MySQL£¬ÀïÃæÓиö¶¨Ê±±¸·Ý¹¦ÄÜ£¬·Ç³£ºÃÓá£
дһ¸öphpµÄ±¸·Ýº¯Êý.È»ºóÀûÓÃwindowsµÄ¼Æ»®ÈÎÎñÖ´Ðб¸·Ý³ÌÐò!
Navicat¡£¡£ÀïÃæ¿ÉÒÔд±¸·Ý¼Æ»®µÈ
ÊDz»ÊÇÓà ......
ÈçÌâ¡£Äܲ»Äܸø¸öÀý×Ó£¬·Ç³£¸Ðл
°²×°mysqlʱ¼ÇµÃ×° Àà¿â£¬ÀïÃæÓÐ mysqlÌṩµÄº¯Êý½è¿Ú£¬ÓÃËüÀ´Á¬mysqlºÜ·½±ã
ºÃ¶«Î÷£¬¹²Í¬Ñ§Ï°
mysql++ À࣬ºÜ·½±ãºÜºÃÓã¡
ÌùÓÊÏ䣬·¢Äã
1.mysql api
2.myodbc
......