远程连接数据库后，连接数据库，在创建查询里面执行SQL:

  1. 创建游戏表

create table games (id int unsigned not null auto_increment primary key, gamePkgName char(255) not null, gameName char(255) not null, gameIconUrl char(255) not null, gameDownloadUrl char(255) null, gameSizeNick char(255) null, gameSizeByte int unsigned not null, gameDesc char(255) not null, gameVer char(255) not null, gameVerInt int unsigned not null, gameClassName char(255) not null, gameDownloadCountNick char(255) not null );

2.创建反馈表

create table feedback(id int unsigned not null auto_increment primary key, content char(255) not null, contact char(255) not null, remark char(255) not null, mac char(255) null, ip char(255) not null, imsi char(255) null, imei char(255) not null, androidVer char(255) not null, pkgname char(255) not null );

  1. 添加数据 添加4条数据

insert into games values( “, ‘com.clemu.captcommcla’, ‘名将’, ‘http://roms.qiniudn.com/captcomm.png', ‘http://roms.qiniudn.com/captcomm_CLA_qiniu.apk', ‘12.4M’, ‘12457000’, ‘名将是一款好玩的街机游戏’, ‘3.1’, ‘31’, ‘街机’, ‘1000+’);

insert into games values( “, ‘com.clemu.dinocla’, ‘恐龙快打’, ‘http://roms.qiniudn.com/dino.png', ‘http://roms.qiniudn.com/dino_CLA_qiniu.apk', ‘12.4M’, ‘12457000’, ‘恐龙快打是一款好玩的街机游戏’, ‘3.1’, ‘31’, ‘街机’, ‘1000+’);

insert into games values( “, ‘com.clemu.wofcla’, ‘三国志’, ‘http://roms.qiniudn.com/wof.png', ‘http://roms.qiniudn.com/wof_CLA_qiniu.apk', ‘12.4M’, ‘12457000’, ‘三国志是一款好玩的街机游戏’, ‘3.1’, ‘31’, ‘街机’, ‘1000+’);

insert into games values( “, ‘com.clemu.kof97cla’, ‘拳皇97’, ‘http://roms.qiniudn.com/kof97.png', ‘http://roms.qiniudn.com/kof97_CLA_qiniu.apk', ‘12.4M’, ‘12457000’, ‘拳皇97是一款好玩的街机游戏’, ‘3.1’, ‘31’, ‘街机’, ‘1000+’);