本文整理汇总了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;
}
}