½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
ллÁË
×îеIJ»Ò»¶¨ÊÇ×îºÃµÄ..
ÎÒ¸ÕÂòÁËÈý±¾Ê黹ûµ½£º¡¶Oracle 9i&10g±à³ÌÒÕÊõ¡·¡¢¡¶Oracle¾«Ëè(µÚËİæ)¡·¡¢¡¶Oracle PL/SQL×î¼Ñʵ¼ù¡·
Ï£Íû¶ÔLZÓаïÖú£¡~ Good Luck£¡~
End_rbody_59955860//-->
¸Ã»Ø¸´ÓÚ2009-09-21 17:48:59±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
ojuju10
(ÓÀÖÝÖ®Ò°²úÒìÉß—ÓÀÖÝÒìÉߣ¡)
µÈ¡¡¼¶£º
#3Â¥ µÃ·Ö£º7»Ø¸´ÓÚ£º2009-09-21 19:43:55
Õâ±¾²»´í¡¶Oracle 9i&10g±à³ÌÒÕÊõ¡·
µÚÒ»±¾£¬²»´í¡£
MysqlµÄÎÒ¸Õ¸ÕÔÚ¿´Ò»±¾£¬itpub³öµÄ¡£ÍøÒ׵öDBAдµÄ ÉîÈëdz³ö Mysql Êý¾Ý¿â¿ª·¢£¬ÓÅ»¯Óë¹ÜÀí£¬ÈëÃŵϰ£¬¿ÉÒÔ¿´¿´¡£
Ïà¹ØÎÊ´ð£º
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......