so if i want to creat another one on another server the same i just copy and run in elswhere.
how can i prin to the screen the table structure but by using a PHP code?
for example
CREATE TABLE /*!32300 IF NOT EXISTS*/ delivery (
del_id int(6) unsigned NOT NULL auto_increment,
region_id char(3) NOT NULL DEFAULT '' ,
date int(11) unsigned ,
driver_id int(4) unsigned ,
car float ,
weight float ,
closed enum('1','0') NOT NULL DEFAULT '0' ,
round_num tinyint(1) NOT NULL DEFAULT '0' ,
insert_time int(11) unsigned ,
which_place tinyint(1) unsigned ,
tota_money float NOT NULL DEFAULT '0' ,
total_weight float NOT NULL DEFAULT '0' ,
actual_weight float NOT NULL DEFAULT '0' ,
PRIMARY KEY (del_id,region_id,round_num),
UNIQUE del_id (del_id),
INDEX del_id_2 (del_id),
INDEX region_id (region_id)
);
thnaks in advance
peleg