ÈçÌ⣬ÓÐÒ»¸öÁÐÀïÃæ´æ´¢µÄÊÇemail£¬ÎÒÏë°ÑÀïÃæµÄemailµÄ¡®@¡¯Ç°ÃæµÄÖµ¶¼´æ´¢µÄеÄÒ»ÁÐÀïÃæ£¬±ÈÈçÀïÃæÓиöemail£º123@qq.com£¬ÏÖÔÚÏë°Ñ123Ìá³öÀ´·Åµ½ÐµÄÁÐÖУ¬ÇëÎÊ´ó¼ÒÓÐʲô°ì·¨°¡£¿Ð»Ð»°¡¡¡
update t set new_mail = substr(1,instr(email,'@')-1);
Èç¹ûemailÁÐÀï×î¶àÖ»´æÒ»¸ö£¬Ôò¿ÉÓãº
update tabl ......
ÎÒÊÂÐÂѧµÄ
»·¾³ÊÇ×Ô¼º¼Ò±Ê¼Ç±¾~*¡£*
°²×°µÃÊÂoralce 10g Ex £¨ÆäËûʲô¶¼Ã»×°£©
×î½ü¿´µ½ÓйØÓÚÀäÈȱ¸·ÝÎÊÌâËùÒÔÏëѧϰÏÂ
----------------------
ÎÊÌâÊÇ
1 ÈçºÎÀäÈȱ¸·Ýѽ¡£¡£¡£¡£
2 ÎÒÓ¦¸ÃÔõôÏÂÒ»²½Ñ§Ï°oralceѽ ~~~
ÎÒ¸ÕÑ§Íæ select alter table create table µÈÓï¾ä
Ã÷Ì쿼 ......
ÎÒÔÚASP.NETÖзÃÎÊOracleÊý¾Ý¿âÊÇ£¬ÖÐÍøÒ³ÖÐÏÔʾÆä±íÖÐÓÐÄÚÈÝ£¬ºº×ÖÏÔʾΪÂÒÂ룬ÇëÖ¸½Ì¸ÃÈçºÎÕý³£ÏÔʾºº×ÖÄØ£¿ÊÇ×Ö·û¼¯µÄÎÊÌâÂð£¿ÎҵĿͻ§¶Ë×Ö·û¼¯ÒÑÉèÖÃΪANSI×Ö·û¼¯ÁË¡£Ð»Ð»£¡
°ïÄã¶¥Ò»ÏÂ
up
ÒýÓÃ
Äãµ÷ÊÔµÄʱºò¿´Ò»Ï£¬¶Á³öÀ´µÄÊý¾ÝÊÇ·ñÊÇÂÒÂ룬Èç¹ûÊÇÄǾÍÊÇÒ³Ãæ±àÂëÎÊÌâÁË£¬Èç¹û²»ÊÇ¡£¡£¡£²»ÖªµÀÁË
±àÂë¸ ......
²»ÓÃ±íµ¥ºÍajaxÄÜ·ñ´«µÝ²ÎÊý£¿
ÈçÎÒÒª´«µÝ $(".test").html() ×÷Ϊ²ÎÊý$my_htmlµ½test.phpÎļþ£¬ÒòΪhtmÎļþºÍphpÊÇÒìÓò£¬ÓÃajaxºÃÏñ±È½ÏÂé·³¡£ÔÚhtmÎļþÉϼÓÉÏ±íµ¥Ö¸¶¨actionµØÖ·¿ÉÒÔ´«²Î£¬µ«ÓÐûÓв»ÐèÒª±íµ¥µÄ·½Ê½´«²ÎµÄÄØ£¿
<body>
<div class="test">ÄãºÃ </di ......
ÎÒÓÃcalssÀ´´¥·¢$("a.calssname").click(function() {...})£¬
ÎÊÌâÊÇÕâ¸öÄÚÈÝÊÇÔÚ±¾Ò³ÃæµÄʱºòûÓÐÎÊÌ⣬ҪÊÇÎÒÓÃajax¼ÓÔØ½øÀ´µÄµã»÷¾ÍûÓз´Ó¦ÁË£¬ÎªÊ²Ã´ÕâÑù£¿Ôõô½â¾ö£¿
ÊDz»ÊÇÒªÖØÐÂ$(document).ready(function() ³õʼ»¯£¿Ôõôд³õʼ»¯´úÂ룿
<a class="calssname">asfdddsdsg ......
RT£¡
xmlHttpRequest.send("Ìá½»²ÎÊýÃû=Öµ&Ìá½»²ÎÊýÃû1=Öµ");
var date={"Êý¾Ý1":"Êý¾Ý1Öµ","Êý¾Ý2":"Êý¾Ý2Öµ","Êý¾Ý3":"Êý¾Ý3Öµ"};
xmlHttpRequest.send(date);
{{ ......