Create new table from old table and add 2 new columns

debugcn Published at Dev

kerry

I have a query that is working fine, it creates one MySQL table from another based on selected fields.

My problem is I also want 2 new empty columns in the new table.

How do I create a new table based on an existing table, but with added empty columns?

$result = mysqli_query($mysqli,"CREATE TABLE matchstats SELECT hometeam, fthg, awayteam, ftag FROM results");
if (!$result) {
    die("Query to create table failed");
}

Amani Ben Azzouz

You can try this

CREATE TABLE table2 (
  new_column1 DECIMAL(5,2),
  new_column2 DECIMAL(5,2)
) SELECT * FROM table1 ;

see demo

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-21

Comments

0 comments

From Dev

SQL: How to create new table with both data from old table and new empty columns

From Dev

SQL: Create new table from old

From Dev

Create table or only add changed/new columns

From Dev

to alter or create a new table in cassandra to add new columns

From Dev

to alter or create a new table in cassandra to add new columns

From Dev

Script to add new columns to table

From Dev

Create multiple new data.table columns simultaneously, by dividing old columns

From Dev

Create new columns depending on the columns in a table

From Dev

mySQL - Create a New Table Using Data and Columns from Three Tables

From Dev

Create a new table from two existing table

From Dev

Need to create a new table from existing table

From Dev

Create a new table from two existing table

From Dev

mysql new table with repeated columns from 2 tables

From Dev

Data migration transferring from old table into new table, with Laravel 5

From Dev

Data migration transferring from old table into new table, with Laravel 5

From Dev

Creating new table from columns in multiple tables

From Dev

Compare 2 table columns and update new column

From Dev

subset data.table columns for calculation of new value but keep all old columns + new value

From Dev

Add new table in Magento Create New Order Section

From Dev

Add new Column to Android SQLite Database Create new table

From Dev

How can I create a copy of an Oracle table and add new columns to it in same statement?

From Dev

Cassandra - Import from CSV and create new table?

From Dev

Is it possible to create a new table from an unpivot results?

From Dev

Pandas: create new column from old, add values

From Dev

Pandas: create new column from old, add values

From Dev

Change architecture of User Table from old design to new

From Dev

Change architecture of User Table from old design to new

From Dev

Select Distinct from new tol old in same table

From Dev

SQL Insert new columns in table B from rows of table A

Related Related

Article