mysql Á¬½Óorcal Êý¾Ý¿â OCIDefineByName
Oracle 8 資ÁÏ庫º¯Ê½庫
OCIDefineByName
讓 SELECT Ö¸Áî¿ÉʹÓà PHP 變數¡£
語·¨: boolean OCIDefineByName(int stmt, string ColumnName, mixed &variable, int [type]);
傳»ØÖµ: ²¼ÁÖÖµ
º¯Ê½種類: 資ÁÏ庫¹¦ÄÜ
內ÈÝ說Ã÷
±¾º¯Ê½ÓÃ來¶¨義Ö¸¶¨µÄ PHP 變數£¬Ê¹ÆäÄܹ© SQL Ö¸ÁîÖÐµÄ SELECT Ö¸ÁîʹÓá£ÔÚ´óС寫µÄ問題ÉÏҪעÒâһϣ¬Òò為 Oracle 資ÁÏ庫ÖеÄ欄λÃû稱Æä實¶¼ÊÇ´ó寫µÄÃû×Ö¡£參數 stmt ÊÇ經過 Oracle ½âÎö (OCIParse) ááµÄ×Ö´®Ö¸標¡£參數 ColumnName ÊÇ Oracle 資ÁϱíÉϵÄ欄λÃû稱¡£參數 variable Ç°ÃæÒ»¶¨Òª¼Ó & ·û號£¬±í PHP 變數λַ¡£參數 type ͨ³£Ê¡ÂÔ¡£ÖµµÃ×¢ÒâµÄÊÇÓûʹÓà Oracle 8 ÖÐÌØÓеÄÐÂ資ÁÏÐÍ態 LOB/ROWID/BFILE µÈ時£¬ÐèÒªÏÈ執ÐÐ OCINewDescriptor() º¯Ê½¡£執Ðб¾º¯Ê½³É¹¦則傳»Ø true Öµ¡£
ʹÓÃ範Àý
這個範ÀýÊÇ thies@digicol.de ËùÌá³öµÄ
<?php
$conn = OCILogon("scott","tiger");
$stmt = OCIParse($conn,"select empno, ename from emp");
/* ʹÓà OCIDefineByName ÒªÔÚ執ÐÐ OCIExecute ǰ */
OCIDefineByName($stmt,"EMPNO",&$empno);
OCIDefineByName($stmt,"ENAME",&$ename);
OCIExecute($stmt);
while (OCIFetch($stmt)) {
echo "empno:".$empno."\n";
echo "ename:".$ename."\n";
}
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
Ïà¹ØÎĵµ£º
MySQL·þÎñÆ÷²ÉÓÃÁËÄ£¿é»¯·ç¸ñ£¬¸÷²¿·ÖÖ®¼ä±£³ÖÏà¶Ô¶ÀÁ¢£¬ÓÈÆäÌåÏÖÔÚ´æ´¢¼Ü¹¹ÉÏ¡£´æ´¢ÒýÇæ¸ºÔð
¹ÜÀíÊý¾Ý´æ´¢£¬ÒÔ¼°MySQLµÄË÷Òý¹ÜÀí¡£Í¨¹ý¶¨ÒåµÄAPI£¬MySQL·þÎñÆ÷Äܹ»Óë´æ´¢ÒýÇæ½øÐÐͨÐÅ¡£Ä¿Ç°Ê¹ÓÃ×î¶àµÄÊÇMyISAMºÍInnoDB¡£
InnoDB±»OracleÊÕ¹ººó£¬MySQL×ÔÐпª·¢µÄд洢ÒýÇæFalcon½«ÔÚMySQL6.0°æ±¾Òý½ø¡£
MyISAMÒýÇæÊÇÒ ......
To shut down the cluster, enter the following command in a shell
on the machine hosting the management node:
shell> ndb_mgm -e shutdown
The -e
option here is used to pass a command to
the ndb_mgm
client from the shell. (See
Section 4.23, “ ......
If you set it in the cnf(it may be my.ini file) you will likely need to restart the server. Optionally, that is a dynamic variable and can be SET GLOBAL or SET SESSION from the command line as well.So just do as follows.
mysql>show variables like’max_allowed_packet’;
......
1,ÔÚwindow×Ô´øµÄ·À»ðǽÀïµÄÀýÍâÌí¼Ó3306¶Ë¿Ú£¬ÎªTCP
2£¬½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlºó£¬¸ ......
ÔÚlinuxÏÂÃæ°²×°mysql£¬Ê×ÏàÒª¸ù¾Ý²Ù×÷ϵͳµÄ°æ±¾£¬Ñ¡Ôñ¶ÔÓ¦µÄmysqlµÄ°æ±¾£¬¹Ù·½ÍøÕ¾ÉÏÓзdz£Ã÷È·µÄ·ÖÀà
http://dev.mysql.com/downloads/
ÔÚÕâÀïÎÒʵÑéµÄ²Ù×÷ϵͳÊÇredhat linux
mysql ÓÃÁËÁ½¸ö°²×°°ü£¬Ò»¸öÊÇserver¶Ë£¬Ò»¸öÊÇclient,ÎÒÓõÄÊÇrpm°ü£¬°²×°µÄÖ¸Áî±È½Ï¼òµ¥¡£
MySQL-server-community-5.1.42-0.rhel4.i38 ......