查询mysql时出错[关闭]

Question

Here is my query to create a table using mysql and php.

<?php
$con=mysql_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysql_connect())
  {
  echo "Failed to connect to MySQL: " . mysql_error();
  }

// Create table
$sql="CREATE TABLE student(Name CHAR(30),Email CHAR(30),Age INT,)";

// Execute query
if (mysql_query($con,$sql))
  {
  echo "Table persons created successfully";
  }
else
  {
  echo "Error creating table: " . mysql_error($con);
  }
?>

I am getting the Error as Check your Syntax

How can I resolve this error ?

Answer 1

You are using , after INT

  $sql="CREATE TABLE student(Name CHAR(30),Email CHAR(30),Age INT,)";

use as

  $sql="CREATE TABLE student(Name CHAR(30),Email CHAR(30),Age INT)";

And if you remove your error is solved.

I recommend you to use mysqli and not to use mysql. Because this extension is deprecated as of PHP 5.5.0, and is not recommended for writing new code as it will be removed in the future. Instead, either the mysqli or PDO_MySQL extension should be used.

Source : http://www.php.net/manual/en/intro.mysql.php

Here is the mysqli code for you.

<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

// Create table
$sql="CREATE TABLE student(Name CHAR(30),Email CHAR(30),Age INT)";

// Execute query
if (mysqli_query($con,$sql))
  {
  echo "Table persons created successfully";
  }
else
  {
  echo "Error creating table: " . mysqli_error($con);
  }
?>