mysql数据表的建立、表编码设置、复制表结构

建立数据表，设置id为主键递增，编码为utf8

create table if not exists cargoship(
	id int(11) not null auto_increment,
	MMSI varchar(20) not null,
    shipType varchar(50) default null,
    nacStatusEN varchar(50) default null,
    length double default 0,
    width double default 0,
    draught double default 0,
    heading double default 0,
    course double default 0,
    speed double default 0,
    dest varchar(50) default null,
    unixTime long not null,
    lon_d double default 0,
    lat_d double default 0,
    seaRange int default 0,
    tonnage double default 0,
    tonnage_level double default 0,
    draught_level double default 0,
    primary key(id) )
    default charset=utf8
    collate=utf8_bin;

将主键递增设置为从1开始

alter table test2 AUTO_INCREMENT = 1;

复制表结构

create table if not exists Other
like cargoship202008;