sql语句如下:
INSERT INTO `timeline_whu`(`uid`, `time`, `lat`, `lon`) select
`uid`,`time`,`lat`,`lon` from `timeline_new` where `lat`>30.50 and `lat`<30.60 and `lon`>114.30 and `lon`<114.40
注意:
引号必须用上面的这种格式,很奇怪
列必须对应
where中不用between语句
sql语句如下:
INSERT INTO `timeline_whu`(`uid`, `time`, `lat`, `lon`) select
`uid`,`time`,`lat`,`lon` from `timeline_new` where `lat`>30.50 and `lat`<30.60 and `lon`>114.30 and `lon`<114.40
注意:
引号必须用上面的这种格式,很奇怪
列必须对应
where中不用between语句