mysql-create-table-from-select -memory 20141106 create table auto_increment

create table REPORT (DESCRIPTION CHAR(50),RECORDID  int(10) unsigned NOT NULL AUTO_INCREMENT,PRIMARY KEY (`RECORDID`));
ALTER TABLE REPORT ADD COLUMN DOC_NO INT;

INSERT INTO REPORT (DESCRIPTION) VALUES ('GRN OS');


select-from-select

CREATE TABLE CUSTOMER_OLD SELECT * FROM CUSTOMER;

create table merget as select * from table1 union select * from table2

create table price (id int, pricelist int) type=memory; 
create table if not exists tableName(
id (20) not null 
,firstname verchar(20) not null
,primary key (2d)) type memory; 

create table if not exists tableName(id (20) not null, firstName varchar(20) not null primary key(id) type = memory; 

CREATE TABLE suppliers
  AS (SELECT id, address, city, state, zip
      FROM companies


 create table ROLE (DESCRIPTION CHAR(50),RECORDID  int(10) unsigned NOT NULL AUTO_INCREMENT,PRIMARY KEY (`RECORDID`));