Tuesday, 9 June 2020

how can I copy the database file or move the table or change the database folder

SELECT * INTO CustomersBackup2017
using this customers table get a backup wwith name customersbackup2017
FROM Customers;
SELECT * INTO CustomersBackup2017 IN 'Backup.mdb'
customers table copied to another database with name changing
FROM Customers;
SELECT CustomerName, ContactName INTO CustomersBackup2017
how to copy the only two columns and change the table name of copied file
FROM Customers;
SELECT * INTO CustomersGermany
FROM Customers
copy the whole table means some rows only where rows are matched
WHERE Country = 'Germany';
SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2017
FROM Customers
LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;



No comments:

Post a Comment