Re: CREATE TABLE LIKE in MySQL 3.23

2005-08-17 Thread Konrad Billewicz
Jigal van Hemert spill.nl> writes: > http://dev.mysql.com/doc/mysql/en/show-create-table.html > > Use output of SHOW CREATE TABLE, modify name and execute that query. Superb solution. I didn't know that MySQL has such a command. My question was very basic. Sorry for bothering. Best regards, K

Re: CREATE TABLE LIKE in MySQL 3.23

2005-08-17 Thread Jigal van Hemert
Konrad Billewicz wrote: Hello, I would like to do thing exactly like CREATE TABLE a LIKE b. But... I have MySQL 3.23 and this command is available since 4.1. How would you handle this task using this, older MySQL? http://dev.mysql.com/doc/mysql/en/show-create-table.html Use output of SHOW C

CREATE TABLE LIKE in MySQL 3.23

2005-08-17 Thread Konrad Billewicz
Hello, I would like to do thing exactly like CREATE TABLE a LIKE b. But... I have MySQL 3.23 and this command is available since 4.1. How would you handle this task using this, older MySQL? Best regards, Konrad Billewicz -- MySQL General Mailing List For list archives: http://lists.mysql.c