你不知道的sql小知识

1、sql别名使用

把一个表中若干列组合成新的列

SELECT CustomerName, Address+', '+City+', '+PostalCode+', '+Country AS Address
FROM Customers;

用concat函数连接

SELECT CustomerName, CONCAT(Address,', ',City,', ',PostalCode,', ',Country) AS Address
FROM Customers;

2、表复制

SELECT *
INTO CustomersBackup2013
FROM Customers;

把Customers备份到CustomersBackup2013

SELECT *
INTO CustomersBackup2013 IN 'Backup.mdb'
FROM Customers;

把Customers备份到另一个数据库Backup.mdb中的表CustomersBackup2013

3、INSERT 和SELECT联合插入

INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers;

把Suppliers的俩列插入Customers 的俩个字段中