Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

½éÉÜ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±à³ÌÒÕÊõ¡·

ÒýÓÃ
Õâ±¾²»´í¡¶Oracle 9i&10g±à³ÌÒÕÊõ¡·


µÚÒ»±¾£¬²»´í¡£

MysqlµÄÎÒ¸Õ¸ÕÔÚ¿´Ò»±¾£¬itpub³öµÄ¡£ÍøÒ׵öDBAдµÄ ÉîÈëdz³ö Mysql Êý¾Ý¿â¿ª·¢£¬ÓÅ»¯Óë¹ÜÀí£¬ÈëÃŵϰ£¬¿ÉÒÔ¿´¿´¡£


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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

MYSQL ÈçºÎÐÞ¸ÄBLOBÀàÐ͵ÄÊý¾Ý?

ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿

¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ