在MySQL中动态检查和创建表 - Dynamically Check and Create Table in MySQL

Dynamically Check and Create Table in MySQL

本文关键字：创建检查和动态 MySQL | 更新日期: 2023-09-27

我在数据库中创建动态表时遇到问题。如果数据库中已经存在该表，则不应该创建新表。

if( mysqli_num_rows(mysqli_query("SHOW TABLES LIKE abc")) == 1){
    echo "Already Exit";    
} else {
    //echo "not exit";
    $sql="CREATE TABLE `decoration`.`newtable` (`id` INT NOT NULL AUTO_INCREMENT ,`company_id` VARCHAR( 20 ) NOT NULL ,`list_name` VARCHAR( 50 ) NOT NULL ,`created` INT NOT NULL ,`modified` INT NOT NULL ,`status` INT NOT NULL ,PRIMARY KEY (  `id` )) ENGINE = INNODB";
    if ($con->mysqli_query($sql)){
        echo "created";
    } else {
        echo "not created";
    }
}

您可以使用下面的查询

CREATE TABLE IF NOT EXISTS `schema`.`Employee` (
`idEmployee` VARCHAR(45) NOT NULL ,
`Name` VARCHAR(255) NULL ,
`idAddresses` VARCHAR(45) NULL ,
PRIMARY KEY (`idEmployee`) ,
CONSTRAINT `fkEmployee_Addresses`
FOREIGN KEY `fkEmployee_Addresses` (`idAddresses`)
REFERENCES `schema`.`Addresses` (`idAddresses`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin

IF NOT EXISTS将检查表是否存在，如果表在数据库中存在，则不创建新表。

Ref: http://dev.mysql.com/doc/refman/5.7/en/create-table.html

希望这对你有帮助!