I am trying to drop a table in a database with the following query statement:
mysql_query('DROP TABLE IF EXISTS "dbName.tableName"') or die(mysql_error());
But I keep getting an error. Does anyone know if开发者_Python百科 specifying the dbName.tableName is invalid?
mysql_query('DROP TABLE IF EXISTS `dbName`.`tableName`') or die(mysql_error());
You should use backticks instead of double quotes like this:
mysql_query('DROP TABLE IF EXISTS `dbName`.`tableName`');
You can't use double quotes to quote db/table names, instead you either leave them unquoted or use backticks. But to answer your question, yes it is perfectly valid to specify the database name.
DROP TABLE `dbName`.`tableName`
精彩评论