当前位置：Gxlcms >
数据库问题 >
mysql从一张表查出数据存到另一张表和inner join的用法
mysql从一张表查出数据存到另一张表和inner join的用法
时间：2021-07-01 10:21:17
帮助过：29人阅读
INTO test_table_public(class, name, geography)
SELECT class, name, geography
FROM test_table
WHERE id
>= 137181 AND id
<= 137214;
SELECT class, name, geography
FROM test_table
WHERE id
>= 137181 AND id
<= 137214;
SELECT t1.class, t1.name, t2.geography, t1.test
FROM test_table t1
INNER JOIN test_table_public t2
ON t1.name
= t2.name;
mysql从一张表查出数据存到另一张表和inner join的用法
标签：mysql color geo 用法 and bsp test 数据 sele
