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...
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...