本文整理匯總了PHP中MDB2_Driver_Common::getOption方法的典型用法代碼示例。如果您正苦於以下問題：PHP MDB2_Driver_Common::getOption方法的具體用法？PHP MDB2_Driver_Common::getOption怎麽用？PHP MDB2_Driver_Common::getOption使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類MDB2_Driver_Common的用法示例。
在下文中一共展示了MDB2_Driver_Common::getOption方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: switch
function _setupSQLStatements()
{
switch ($this->oDBH->dbsyntax) {
case 'mysql':
$engine = $this->oDBH->getOption('default_table_type');
$this->aSQLStatements['table_copy_all'] = "INSERT IGNORE INTO %s SELECT * FROM %s";
//$this->aSQLStatements['table_copy_cols'] = "INSERT IGNORE INTO (%s %s) VALUES (SELECT %s FROM %s)";
$this->aSQLStatements['table_update_col'] = "UPDATE IGNORE %s SET %s = %s.%s";
$this->aSQLStatements['table_copy'] = "CREATE TABLE %s ENGINE={$engine} (SELECT * FROM %s)";
$this->aSQLStatements['table_copy_temp'] = "CREATE TEMPORARY TABLE %s ENGINE={$engine} (SELECT * FROM %s)";
$this->aSQLStatements['table_rename'] = "RENAME TABLE %s TO %s";
$this->aSQLStatements['table_select'] = 'SELECT %s FROM %s';
$this->aSQLStatements['table_insert'] = 'INSERT INTO %s (%s) VALUES %s';
break;
case 'pgsql':
$this->aSQLStatements['table_copy_all'] = 'INSERT INTO "%s" SELECT * FROM "%s"';
$this->aSQLStatements['table_update_col'] = 'UPDATE "%s" SET %s = "%s".%s';
$this->aSQLStatements['table_copy'] = 'CREATE TABLE "%1$s" (LIKE "%2$s" INCLUDING DEFAULTS); INSERT INTO "%1$s" SELECT * FROM "%2$s"';
$this->aSQLStatements['table_copy_temp'] = 'CREATE TABLE "%1$s" (LIKE "%2$s" INCLUDING DEFAULTS); INSERT INTO "%1$s" SELECT * FROM "%2$s"';
$this->aSQLStatements['table_rename'] = 'ALTER TABLE "%s" RENAME TO "%s"';
$this->aSQLStatements['table_select'] = 'SELECT %s FROM "%s"';
$this->aSQLStatements['table_insert'] = 'INSERT INTO "%s" (%s) VALUES %s';
break;
default:
'';
break;
}
}