var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: create table select option Issue
I have created a copy of an exisitng table in the database as -
create table test1_temp as select * from test1 where 1=2;
The table was created w/o data.
But the problem is that the indexes and primary key of table "test1" are not copied to "test1_temp".
Since the table ddl is copied dynamically, I want to copy the indexes and primary keys also dynamically. How should I achieve this.
Originally Posted by Hello1
You must run a proper CREATE TABLE in primary an foreign keys.
And you must run a CREATE INDEX to defined non-pk indexes