MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:August 17 2005 9:13am
Subject:Re: CREATE TABLE LIKE in MySQL 3.23
View as plain text  
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 CREATE TABLE, modify name and execute that query.

Regards, Jigal.
Thread
CREATE TABLE LIKE in MySQL 3.23Konrad Billewicz17 Aug
  • Re: CREATE TABLE LIKE in MySQL 3.23Jigal van Hemert17 Aug
  • Re: CREATE TABLE LIKE in MySQL 3.23Konrad Billewicz17 Aug