Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

mysql regexp_replaceÊÇ·ñÖ§³ÖÕýÔò±í´ïʽ

Èç¹ûÖ§³Ö ÈçºÎʹÓã¿

ÀýÈçÆ¥Åä " **testettestestes** ",*·ûºÅÔõÃ´ÅªÄØ£¿ Èç¹ûÕâ¸öº¯ÊýÄÜ×÷ £¬ÈçºÎдÕâ¸ösql£¿

makeup for this:
ysql> select ' 45testettestestes12' regexp ' [*][*]testettestestes[*][*] ';
+--------------------------------------------------------- ......

JavaÁ´½ÓMysqlµÄСÒÉÎÊ

ÏîÄ¿ÖÐʹÓÃJavaÁ´½ÓMysql¡£ÓõÄÊÇÁ¬½Ó³Ø¡£Éæ¼°µ½´Ó±¾µØÏòÊý¾Ý¿â·þÎñÆ÷´«Êý¾Ý¡£

Õ⼸ÌìÓÉÓÚÎÒÊý¾Ý¿â·þÎñÆ÷³öÎÊÌ⣬Ôì³É±¾µØ³ÌÐòÊܵ½Ó°Ï죬Ҳ²»»á±¨´í£¬¾ÍÊǺÜÂý¡£

ÎÒµÄÒÉÎÊÊÇjavaÁ´½ÓMySQLÊý¾Ý¿â£¬Ëü»áÇëÇó¶à³¤Ê±¼ä£¬ÔÚÄDZßÎÞÓ¦´ðµÄÇé¿öÏ¡£
ÇëÎÊÓÐûÓÐÒ»ÖÖ·½·¨£¬¿ÉÒÔÉèÖÃÁ¬½ÓÊý¾Ý¿âµÄʱ¼ä£¬±ÈÈç˵5ÃëÖÓÃ»Ó ......

LinuxÏÂÎÞ·¨¶ÁÈ¡mysqlÇý¶¯

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& ......

MYSQL CONCATÎÊÌâ

Îʸö²Ë²ËµÄÎÊÌ⣬ÎÒÏë¸üÐÂÄÚÈÝÖ´ÐÐÓï¾ä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 ......

mysql ÃæÊÔÌâ


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°²×°ÎÊÌâ


mysqlÖØÐ°²×°ÎÞ·¨°²×°Íê³É
°´ÕÕÍøÉϵĽéÉÜɾÁËwindowsϵÄmy.iniºÍ×¢²á±íÖеÄÏà¹ØÐÅÏ¢£¬µ«ÊÇ»¹ÊÇÔÚ×îºó°²×°µÄʱºò±»´ò¶Ï
ÓÐÄÄλ´óϺָ½ÌÒ»ÏÂ
лл


1. ÄãµÄ winodws °æ±¾¡£
2. ÄãÊÇÈçºÎ°²×°µÄ£¬°²×°µ½ÄÄÒ»²½³ö´í£¿´íÎóÌáʾÊÇʲô£¿

×î¼òµ¥µÄ·½·¨£¬Ö±½Óϸö ZIP°æÈ»ºóÖ±½ÓUNZIP¾Í¿ÉÒÔÓÃÁË¡£ ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [145] [146] [147] [148] 149 [150] [151] [152] [153] [154]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ