2008年7月21日星期一

[fw-db] executing .sql file using zend_db

Hello, is it possible to load and execute .sql files using zend_db? The
following is what i am trying to achieve:

$db->beginTransaction();
try {
$db->query('DROP TABLE ? LIMIT 1', $tableName);
$db->query('LOAD DATA INFILE ?', $fullPathname);
$db->commit();
}catch (Exception $e){
$db->rollBack();
echo $e->getMessage();
}
Is that possible? If not, how would i go about executing .sql files?
Thanks.
--
View this message in context: http://www.nabble.com/executing-.sql-file-using-zend_db-tp18569584p18569584.html
Sent from the Zend DB mailing list archive at Nabble.com.

没有评论: