Create Table With Default Values

[Dysan]

Hello! I have the following code that creates a table structure. How do I give Age a default value of 0

 

mysql_select_db("DB", $connection);
$sql = "CREATE TABLE Person
(
Name text,
Age text,
Sex text
)";

[pocobueno1388]

You cannot set a default value to a TEXT type field.

 

To do it to another type field though, you use the keyword DEFAULT.

 

EX

CREATE TABLE Person
(
Name text,
Age int(3) DEFAULT '0',
Sex text
)