create table like--

[jenniferG]

we are running  mysql 4.0.25 and php 4.4  script line

 

CREATE TABLE ANYTABLE LIKE SISTOCK;

 

gives a syntax  error.

 

Thanks,

 

Jennifer

[Barand]

From manual

 

In MySQL 4.1, you can also use LIKE to create a table based on the definition of another table, including any column attributes and indexes the original table has:

 

CREATE TABLE new_tbl LIKE orig_tbl;