Create Table With Primary Key

[Anon]

How To Create Table and create Primary key
For Exam.
$sql = "CREATE TABLE stock_raw_temp (edate varchar(8) NOT NULL, ";
$sql .= "factory_code varchar(8) Not NULL,";
$sql .= "location_code varchar(7) Not NULL, ";
$sql .= "location_name varchar(20), ";
$sql .= "capacity varchar(8), ";
$sql .= "amount int(9), ";
$sql .= "weight float(10,2), ";
$sql .= "lock_id varchar(15), ";
$sql .= "product_code varchar(12) NOT NULL, ";
$sql .= "product_name varchar(40), ";
$sql .= "fdate varchar(8) NOT NULL, ";
$sql .= "truck_id varchar(15))";
If I want to create key Can I Modify this variable by any way....Thank you for your answer...:-)

[Anon]

hi!

This is correct: (PRIMARY KEY)

$sql = "CREATE TABLE stock_raw_temp (edate varchar(8) NOT NULL PRIMARY KEY, ";
$sql .= "factory_code varchar(8) Not NULL,";
$sql .= "location_code varchar(7) Not NULL, ";
$sql .= "location_name varchar(20), ";
$sql .= "capacity varchar(8), ";
$sql .= "amount int(9), ";
$sql .= "weight float(10,2), ";
$sql .= "lock_id varchar(15), ";
$sql .= "product_code varchar(12) NOT NULL, ";
$sql .= "product_name varchar(40), ";
$sql .= "fdate varchar(8) NOT NULL, ";
$sql .= "truck_id varchar(15))";

or modify after:

alter table stock_raw_temp
ADD PRIMARY KEY (index_col_name,...)

read MySQL reference!