Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Mysql create table based on another table including indexes

⇧
0
⇩
93 views

I need to create a table based on another table in MYsql including the constraints and indices.

I have following scenario:

Table A- exists probably with millions of rows. I want to create table B with exactly same as table A (including constraints and indices). Process data from A and some other source and insert to B. At the end of processing drop table A(drop indices associated with table A) and Rename table B to A including indices.

What is the best way to do this? Performance is my real concern.

Thanks

sql mysql database performance
asked January 25, 2011 7:09 pm CST
JavaTechie
posted via StackOverflow

0 Answers

Be the first to answer this question

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
How to create index in two table mysql?
January 13, 2011
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
Add a dynamic field to a MySQL table based on a functions value.
January 17, 2011
Change mysql table join based on field value
January 17, 2011
MySQL function-based indexes
January 21, 2011
Mysql create a table character sets
January 25, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
How to create mysql table with many hasMany association in CakePHP?
January 18, 2011
Using MySQL, I'm attempting to create a table in a db, and then insert into, but am getting a 'syntax' error
January 13, 2011
Limiting based on value selected from another table
January 19, 2011
How to use constants in SQL CREATE TABLE?
December 31, 2010
[Solved] SQL CREATE TABLE Error
January 9, 2011
Trigger: after insert create a new table
January 7, 2011
Removing rows from a SELECT based on columns in a different table
January 12, 2011
PHP / MySQL - Create array of distinct values, query db table for data associated with those values, and loop for each
January 25, 2011
Populating a table with a large amount of data from a temporary table - MySQL
January 5, 2011
PHP mysql multi-table search returning different table and field data row after row
January 13, 2011
Why taking too long time to insert rows in a mysql table even after using multithreading when table has some relationship
January 14, 2011
Hibernate: hbm2ddl.auto does not create table
December 28, 2010
Rails Migration Create Table Primary Key
January 22, 2011
MySQL: Select from table A, if ID matches 2 (or arbitrary n) rows in table B
January 19, 2011
MYSQL inserting records form table A into tables B and C (linked by foreign key) depending on column values in table A
January 7, 2011
Mysql: select all items from table A if not exist in table B
January 11, 2011
Foreign key constraints missing from SHOW CREATE TABLE output
December 28, 2010
BestPractise: Create a left join or add a few extra columns to a certain table?
January 24, 2011
Php / mysql - select id from one table excepting ids which are in another table
January 16, 2011
MySQL select with old table and new table query
January 22, 2011
Mysql count from same table and data from the other table
January 13, 2011