12.19 从其他表添加记录到一个表
作者:jvfans 日期:2007-12-19
1、创建一个新表存储新的记录：
=========
mysql> create table customer_sales_value(first_name varchar(30),surname varchar(
40),value int);
=========
使用insert ...select插入记录：
======
mysql> insert into customer_sales_value select first_name,surname,sum(value) fro
m sales natural join customer group by fi...
=========
mysql> create table customer_sales_value(first_name varchar(30),surname varchar(
40),value int);
=========
使用insert ...select插入记录：
======
mysql> insert into customer_sales_value select first_name,surname,sum(value) fro
m sales natural join customer group by fi...
标签: insert...select
