Copy table with calculation : Copy Table « Table Index « SQL / MySQL






  1. SQL / MySQL
  2. Table Index
  3. Copy Table

Copy table with calculation

       

INSERT INTO dst_tbl (i, s) SELECT COUNT(*), name FROM src_tbl GROUP BY name;








Related examples in the same category

1.Copy Table Demo
2.Copy Table with Condition
3.Copying a Table
4.Use NULL in where clause
5.Copy table with conditions
6.Only copy records
7.Using the INSERT Statement to Copy Data
8.Using the REPLACE Statement to Copy Data
9.Copy a table
10.Only copy certain columns
11.Copy one row of data
12.Copy data to temporary table
13.Creating New Tables with SELECT Results
14.Copying Only Selected Data from a Table
15.Copying Data into a New Table
16.MySQL truncates the data during copying