Èç¹ûÖ§³Ö ÈçºÎʹÓã¿
ÀýÈçÆ¥Åä " **testettestestes** ",*·ûºÅÔõÃ´ÅªÄØ£¿ Èç¹ûÕâ¸öº¯ÊýÄÜ×÷ £¬ÈçºÎдÕâ¸ösql£¿
makeup for this:
ysql> select ' 45testettestestes12' regexp ' [*][*]testettestestes[*][*] ';
+--------------------------------------------------------- ......
ÏîÄ¿ÖÐʹÓÃJavaÁ´½ÓMysql¡£ÓõÄÊÇÁ¬½Ó³Ø¡£Éæ¼°µ½´Ó±¾µØÏòÊý¾Ý¿â·þÎñÆ÷´«Êý¾Ý¡£
Õ⼸ÌìÓÉÓÚÎÒÊý¾Ý¿â·þÎñÆ÷³öÎÊÌ⣬Ôì³É±¾µØ³ÌÐòÊܵ½Ó°Ï죬Ҳ²»»á±¨´í£¬¾ÍÊǺÜÂý¡£
ÎÒµÄÒÉÎÊÊÇjavaÁ´½ÓMySQLÊý¾Ý¿â£¬Ëü»áÇëÇó¶à³¤Ê±¼ä£¬ÔÚÄDZßÎÞÓ¦´ðµÄÇé¿öÏ¡£
ÇëÎÊÓÐûÓÐÒ»ÖÖ·½·¨£¬¿ÉÒÔÉèÖÃÁ¬½ÓÊý¾Ý¿âµÄʱ¼ä£¬±ÈÈç˵5ÃëÖÓÃ»Ó ......
windows»·¾³Ï±àÒëºÃµÄ´úÂëÈçÏ£º
package po;
import java.sql.*;
public class Test {
public static void main(String[] args) throws ClassNotFoundException, InstantiationException, IllegalAccessException
{
String url="jdbc:mysql://127.0.0.1:3306/metro?user=root& ......
Îʸö²Ë²ËµÄÎÊÌ⣬ÎÒÏë¸üÐÂÄÚÈÝÖ´ÐÐÓï¾äupdate table set name=concat(name,"fff")£»µ«ÊÇconcatº¯Êý˵Ã÷²ÎÊýΪNULLʱ½«·µ»ØNULL£¬¶øÎҵıíÖÐnameµÄÖµ¿ÉÄÜÊÇNULL£¬ËùÒÔÖ´ÐкónameµÄֵΪNULL£¬²¢²»ÊÇfff,ÇëÎÊÎÒ¸ÃÔõô°ì£¿
pdate table set name=concat(COALESCE(name,''),"fff")
update table ......
CREATE TABLE hard (qu char (11) ,co char (11) ,je numeric(3, 0))
insert into hard values ('A','1',3)
insert into hard values ('A','2',4)
insert into hard values ('A','4',2)
insert into hard values ('A', ......
mysqlÖØÐ°²×°ÎÞ·¨°²×°Íê³É
°´ÕÕÍøÉϵĽéÉÜɾÁËwindowsϵÄmy.iniºÍ×¢²á±íÖеÄÏà¹ØÐÅÏ¢£¬µ«ÊÇ»¹ÊÇÔÚ×îºó°²×°µÄʱºò±»´ò¶Ï
ÓÐÄÄλ´óϺָ½ÌÒ»ÏÂ
лл
1. ÄãµÄ winodws °æ±¾¡£
2. ÄãÊÇÈçºÎ°²×°µÄ£¬°²×°µ½ÄÄÒ»²½³ö´í£¿´íÎóÌáʾÊÇʲô£¿
×î¼òµ¥µÄ·½·¨£¬Ö±½Óϸö ZIP°æÈ»ºóÖ±½ÓUNZIP¾Í¿ÉÒÔÓÃÁË¡£ ......