Create table test_jiudian (select term,index_averagefrom t_search_term_new where parent_id is null and term like '%酒店%' and index_average>0 order by index_average desc )
给你一个最简单直接的例子,比如你把a表的查询结果作为一个新表b,可以用一下代码:SELECT * INTO b FROM a
*是你要查询的选项,可以自己决定!
可以的。$sql="CREATE TABLE tmp_tb_name (
`xxx_id` INT( 9 ) NOT NULL ,
INDEX ( `xxx_i` , )
) ENGINE = INNODB"
$conn=db_connect()
$result=$conn->query($sql)
然后再对tmp_tb_name 进行insert
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)