Automatically Increment ID

[Dysan]

I have the following code that creates a table.

Can the ID field be made as an auto-incrementing field?

 

mysql_select_db("DB", $con);
$sql = "CREATE TABLE Data 
(
ID int,
Firstname text,
Lastname text,
Age int,

)";
mysql_query($sql,$con);

[pocobueno1388]

I believe you would just add AUTO_INCREMENT to the line.

 

$sql = "CREATE TABLE Data 
(
ID int AUTO_INCREMENT,
Firstname text,
Lastname text,
Age int,
)";