MySQL Create a table with select columns from Another Table

Vote count:

0

I'm trying to break down a GPS point in a new table since the old table is in CHAR my new table will be set to INT.

Drop Table LoopTest1;

CREATE TABLE LoopTest1 (

Account Number char(32) NULL ,

Latitude decimal(30,2) NULL ,

LatDegree int(2) NULL ,

LatMinutes int(2) NULL ,

LatSeconds decimal(5,2) NULL ,

LatDecimal decimal(30,6) NULL ,

Longitude decimal(30,2) NULL ,

LongDegree int(2) NULL ,

LongMinutes int(2) NULL ,

LongSeconds decimal(5,2) NULL ,

LongDecimal decimal(30,6) NULL );

set

    LoopTest2.`Account Number` = LoopTest1.`Account Number`,

    LoopTest2.Latitude = LoopTest1.Latitude,

    LoopTest2.Longitude =LoopTest1. Longitude

FROM

    LoopTest2

This will only be a temp table since I will update LoopTest2 with the changes made in LoopTest1

asked 25 secs ago

Matt B

1

MySQL Create a table with select columns from Another Table