SQL CREATE TABLE 簡單使用
本次環境使用的是MySQL5.7版 1. 根據括弧內所輸入的欄位與資料類型建立表(table) CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ... ); mysql> CREATE TABLE Persons( PersonID int, -> LastName varchar(255), -> FirstName varchar(255), -> Address varchar(255), -> City varchar(255) -> ); Query OK, 0 rows affected (0.17 sec) 2.根據舊表欄位新增新表 CREATE TABLE newTableName As SELECT column1,column2 ... FROM oldTableName WHERE ...; mysql> CREATE TABLE Persons_copy As -> SELECT * -> FROM Persons -> Where PersonID=11; Query OK, 0 rows affected (0.20 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> INSERT INTO Persons_copy VALUES (11,"Lester","Mark","No","No"); Query OK, 1 row affected (0.03 sec) mysql> SELECT * FROM Persons_copy; +----------+----------+-----------+---------+------+ | PersonID | LastName | FirstName | Address | City | +----------+---------...