PHP mysql_query()函数用于创建表。从PHP 5.5开始,不推荐使用 mysql_query()函数。现在建议使用两种替代方法之一。
$host = 'localhost:3306'; $user = ''; $pass = ''; $dbname = 'test'; $conn = mysqli_connect($host, $user, $pass,$dbname); if(!$conn){ die('Could not connect: '.mysqli_connect_error()); } echo 'Connected successfully<br/>'; $sql = "create table emp5(id INT AUTO_INCREMENT,name VARCHAR(20) NOT NULL, emp_salary INT NOT NULL,primary key (id))"; if(mysqli_query($conn, $sql)){ echo "Table emp5 created successfully"; }else{ echo "Could not create table: ". mysqli_error($conn); } mysqli_close($conn);
输出:
Connected successfully Table emp5 created successfully
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)