Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

Search: 

  Tutorial: Database Structured Query Language SQL SELECT INTO Tutorial

How to use the SELECT INTO statement to create backup copies of tables.

Tutorial Details:

SQL SELECT INTO Statement
HOME
SQL Basic
SQL HOME
SQL Intro
SQL Select
SQL Where
SQL Insert
SQL Update
SQL Delete
SQL Demo
SQL Try It
SQL Advanced
SQL Order By
SQL AND & OR
SQL In
SQL Between
SQL Aliases
SQL Join
SQL Union
SQL Create
SQL Drop
SQL Alter
SQL Functions
SQL Group By
SQL Select Into
SQL Create View
SQL Server
SQL Quick Ref
SQL Summary
SQL Quiz
SQL Quiz
SQL Exam
Selected Reading
Web Statistics
Web Glossary
Web Hosting
Web Quality
W3Schools Forum
SQL SELECT INTO Statement
The SELECT INTO Statement
The SELECT INTO statement is most often used to create backup copies of tables or for archiving records.
Syntax
SELECT column_name(s) INTO newtable [IN externaldatabase]
FROM source
Make a Backup Copy
The following example makes a backup copy of the "Persons" table:
SELECT * INTO Persons_backup
FROM Persons
The IN clause can be used to copy tables into another database:
SELECT Persons.* INTO Persons IN 'Backup.mdb'
FROM Persons
If you only want to copy a few fields, you can do so by listing them after the SELECT statement:
SELECT LastName,FirstName INTO Persons_backup
FROM Persons
You can also add a WHERE clause. The following example creates a "Persons_backup" table with two columns (FirstName and LastName) by extracting the persons who lives in "Sandnes" from the "Persons" table:
SELECT LastName,Firstname INTO Persons_backup
FROM Persons
WHERE City='Sandnes'
Selecting data from more than one table is also possible. The following example creates a new table "Empl_Ord_backup" that contains data from the two tables Employees and Orders:
SELECT Employees.Name,Orders.Product
INTO Empl_Ord_backup
FROM Employees
INNER JOIN Orders
ON Employees.Employee_ID=Orders.Employee_ID
Your browser does not support inline frames or is currently configured not to display inline frames.
What do you want your Web site to do today?
Ektron?s Web Content Management system gives you all the tools you need to create, deploy, and manage your Web site ? all rolled into one application.
Is your Web site interactive enough? Want new functionality to better engage visitors? Are your ready for Web 2.0? Ektron?s all-in-one CMS provides:
Content Management ? Author/edit content, manage navigation, menus, audit trails, workflow, approvals
Multilingual Support ? Integrated translation tools help you reach multiple audiences by speaking their language
Document Management ? Collaborate via the Web on Microsoft Word, PowerPoint, other documents, ?save as? PDF, publish to Web
Web Alerts ? Manage memberships and subscriptions and automatically email visitors when you add or update content that?s relevant to them
HTML Form Engine ? Create a two-way dialog with visitors using our wizard-like HTML form-building engine with validation and database support
Online Calendars ? Build and manage Web-based calendars and enable users to customize a view based on what?s important to them
Site Replication ? Automatically deploy site changes from a staging to production server and archive previous site versions
Easy to Extend ? Our well-documented API makes CMS400.NET completely extensible ? customize it to your exact needs
See why there are 15,000+ Ektron integrations worldwide.
Click here to learn more, then request a live online demo or download a FREE TRIAL.
Easy-to-Understand Books for Web Developers
Build your own website with PHP and MySQL
Build your own website with ASP.NET
Build your own website with Dreamweaver 8
Run your own webserver with Linux and Apache
XML web development with PHP
Flash: Cool effects and practical scripts
HTML: Designing without tables using CSS
CSS: 101 essential tips, tricks and hacks
DHTML: Modern web design using JavaScript and DOM
PHP anthology, volume I and volume II
Firefox web browser secrets
Web design business kit
Search engine marketing kit
We Help You For Free. You Can Help Us!
Make a donation. Help us stay free.
Tell your newsgroup or mailing list.
Link to us from your pages.
Help us correct errors and broken links.
Help us with spelling and grammar.
Jump to: Top of Page or HOME or Printer friendly page
What Others Say About Us
Does the world know about us? Check out these places:
Google Yahoo Alta Vista MSN Lycos Excite Ask Jeeves HotBot
World Wide Web Traffic Rank
W3Schools provides material for training only. We do not warrant the correctness of its contents. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy .
Copyright 1999-2006 by Refsnes Data. All Rights Reserved.
W3Schools was converted to XHTML in December 1999
SITE SEARCH
About W3Schools
W3Schools Forum
Ecommerce
Components
for ASP.NET
WEB HOSTING
$15 Domain Name
Registration
Save $20 / year!
UK Domain Names
Web Hosting
Registro de Dominios
Buy UK Domain Names
Register Domain Names
Cheap Domain Names
Cheap Web Hosting
Web Hosting - UK
Dedicated Servers
Best Web Hosting
Bulk Domain Names
WEB BUILDING
Website Templates
Flash Templates
Flash Web Templates
Web Templates
Custom Programming
BEST Flash Templates
Web Analytics
Web Design Forum
Programming Forum
Need A Programmer?
FREE Trial or Demo
Web Content Manager
Forms,Web Alerts,RSS
Easy Flash Gallery
HTML Exam
SHOPPING
UK Wholesalers
UK Wholesale
ONLINE DEGREE
Advance Your Career
with Drexel University
Bachelor's & Master's
Tech Degrees ONLINE


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
Database Structured Query Language SQL SELECT INTO Tutorial

View Tutorial:
Database Structured Query Language SQL SELECT INTO Tutorial

Related Tutorials:

Displaying 1 - 50 of about 2928 Related Tutorials.

SQL-introduction
stands for Structured Query Language. It is easy and allows you to create a database. It is an ANSI language which allows an user to write queries to access... SQL Tutorial SQL-introduction
 
SQL Example, Codes and Tutorials
: A brief Introduction SQL stands for Structured Query Language. It is easy and allows us to create a database. It is an ANSI language which allows an user to write... SQL Tutorials,Online SQL Tutorials,Free SQL Tutorials,SQL Server Tutorial
 
SQL
;    SQL SQL stands for Structured Query.... A database table consists of structured records divided into fields of data. SQL... version of Structured English Query Language (SEQUEL or SEQL) developed at IBM
 
Hibernate Query Language
the sql query and execute it against underlying database if HQL is used... Hibernate Query Language Hibernate Query...;   Hibernate Query Language or HQL for short is extremely
 
SQL Introduction
; Quick Introduction to SQL: SQL is Structure Query Language. This Query language is used to connect with the database. It is considered as standard language for relation database management systems according to (American National
 
Hibernate Query Language
against database. Hibernate automatically generates the sql query and execute... Hibernate Query Language Hibernate Query Language...;    Introduction to Hibernate Query Language
 
Online Mysql Training
; Introduction to Mysql SQL is Structured Query Language plays an important... database using SELECT statement. Delete or modify the table or row data. Simple... and History for SQL Commands Object Browser Script Editor Modify Date in SELECT
 
Database books Page1
; The SQL Tutorial The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL...), which has laid down certain rules for the language. SQL can be used
 
Database books
; Page-1 The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands through...(R) language. This book describes the "building blocks" of Transact-SQL, which
 
SQL SELECT DISTINCT Statement
with Example The Tutorial illustrates you an example from SQL Select Distinct... SELECT DISTINCT columnName(s) FROM tableName SQL SELECT DISTINCT Query... SQL SELECT DISTINCT Statement SQL SELECT DISTINCT
 
Database books
; Page-1 The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands through...(R) language. This book describes the "building blocks" of Transact-SQL, which
 
Mysql PHP Select
; Mysql PHP is used to execute the select statement using mysql_query ( ) function... with Example The Tutorial illustrate an example from 'Mysql PHP Select'. To understand... retrieve the records from table 'mytable' using select query. Now we make use
 
Select data from Table in Database
to retrieve the selected data from table in database. The select query in the database... Select data from Table in Database Select data...; The select query retrieve the record value of specified column in the syntax
 
SQL Select From
with Example The Tutorial illustrate an example from 'SQL Select From'. To understand... SQL Select From SQL Select From  ...'); Insert Into Stu values(5,'Santosh'); Query The select keyword
 
Mysql Nested Select
; Mysql Nested Select is a SELECT query that is nested within a Select, Update, Insert or Delete SQL query.  Understand with Example: The Tutorial...) Query for Mysql nested select: The Nested Query is used to return those records
 
PHP SQL Select Where
PHP SQL Select Where PHP SQL Select Where...; PHP SQL Select Where is used to provide the records from the table... query. Understand with Example This section of Tutorial illustrate an example
 
JDBC - Java Database Connectivity Tutorial
to manipulate data stored into the database. Here is the complete tutorial on JDBC... especially relational database by using the java programming language. It includes... a connection to a database.  The Driver Manager also helps to select the most
 
The SELECT statement for SQL
Select Statement in SQL, SQL Tutorial The SELECT statement for SQL        ...;     SELECT key word is used to select data from
 
MySQL PHP Query delete
query from a database table. MySQL PHP Query is used to delete the records from... with Example The Tutorial grasp you an illustrative example on 'MySQL PHP Query... not connect: ".mysql_error()); mysql_select_db($database,$link
 
Execute database query by using sql tag of JSTL SQL library
Execute database query by using sql tag of JSTL SQL library Execute database query by using sql tag of JSTL SQL library... 'mahendra' and table named 'employee_master' in same database by the sql query given
 
JDBC Execute Query
and execute SQL Statement to a backend database. 6)execute query (sql ) -  This method is used to retrieve the element from a database by accepting sql...; In this Tutorial we want to explain you an example from JDBC Execute query, For this we have
 
PHP SQL Query Where Clause
Php Sql Query Where Clause PHP SQL Query Where...; from the sql query execution, we have created whereClause.php page. First...;userName", "Password"), database is selected by mysql_select_db
 
PHP SQL Query
Php Sql Query PHP SQL Query  ...; This example illustrates how to create and execute the sql query in php application. Most...;userName", "Password"), selected the database by mysql_select_db("
 
MySQL Download
- SQL (Structured Query Language) is database server under GPL licence. It is world's most popular open source database server. Its architectural design makes it extremely fast and easy to customized database. MySQL is a key part of LAMP
 
Open Source SQL
(pronounced "ess-que-el") stands for Structured Query Language. SQL is used... the structure of a JDBC compliant database, browse the data in tables, issue SQL...;     Open source SQL database: One$DB One$DB
 
SQL Tutorials for Beginner
to SQL: SQL is Structure Query Language. This Query language is used to connect... data from table in database. The select query in the database retrieve selected... The Tutorial bring  a unique introductory  on SQL tutorial for a beginner
 
SQL Tutorials for Beginner
to SQL: SQL is Structure Query Language. This Query language is used to connect... data from table in database. The select query in the database retrieve selected... The Tutorial bring  a unique introductory  on SQL tutorial for a beginner
 
PHP SQL Query Insert
Php Sql Query Insert PHP SQL Query Insert... can be executed using mysql_query() method to insert values into the database...; This example illustrates how to execute insert query in php application
 
SQL Backup query with where statement
The Tutorial show you a example from 'SQL Backup query with where... SQL Backup query with where statement SQL Backup...;      SQL Backup query with where
 
Insert Data into Database Using Hibernate Native SQL
SQL for all database operations like insert, update, delete and select. ... Insert Data into Database Using Hibernate Native SQL Insert Data into Database Using Hibernate Native SQL  
 
SQL Example, Codes and Tutorials
Query Language or SQL for short is standard language to interact with the database... for Structured Query Language. It is easy and allows us to create a database... SQL Tutorials,Online SQL Tutorials,Free SQL Tutorials,SQL Server Tutorial
 
SQL PHP
="Select * from stu where id =".$value; $sql_result=mysql_query($sql... The Tutorial illustrate an example from 'SQL PHP'. To understand and elaborate... the records from database and print on your supporting browser.   sql_php.php
 
Mysql Date Select
database as fieldname 'DATE'. Query to select date  SELECT DATE...; The Tutorial elaborate an example from 'Mysql Date Select'. This section makes you easy to understand how to get the current date from your database. The SELECT
 
Use of Select Box to show the data from database
Use of Select Box to show the data from database Use of Select Box to show the data from database      ... of Select Box in a JSP page to show the data fetched from the database. We are using
 
PHP SQL Script
; and password to execute the SQL query in PHP. We create a MySQL database which... The Tutorial illustrate an example from 'PHP SQL Script'. To make use of sql query in PHP, we create sql_script.php begins with <?php and end with ?>
 
MySQL Tutorial - SQL Tutorials
Help for Beginners MySQL Tutorial - SQL Tutorials... and developed by MySQL AB. It is most popular open source SQL database... query that is used to select the data from more than one table
 
sql php code
;Select * from stu where id =".$value; $sql_result=mysql_query($sql... The Tutorial illustrate an example from 'SQL PHP'. To understand and elaborate...;Could not connect: ".mysql_error()); mysql_select_db($database
 
Retrieve data from database by using sql tag of JSTL SQL library
to database, now we are explaining how to execute sql query. To execute sql query... Retrieve data from database by using sql tag of JSTL SQL library Retrieve data from database by using sql tag of JSTL SQL library
 
Java Complete Hibernate 3.0 Tutorial Tutorial
, composition and the Java collections framework. The Hibernate Query Language, designed...;          Hibernate Query Language Introduction to Hibernate Query Language In this lesson you will learn
 
SQL _ Wildcards
in a database. The SQL wildcards substitute one or more character, whenever...; The Tutorial illustrate an example from SQL_Wildcards. To understand Wildcards... SQL % Wildcards Syntax SELECT ColumnName(s) FROM
 
Complete Hibernate 3.0 Tutorial
, composition and the Java collections framework. The Hibernate Query Language, designed...;          Hibernate Query Language Introduction to Hibernate Query Language In this lesson you will learn
 
SQL Average
with Example The Tutorial illustrate an example from 'SQL Average'. To grasp... SQl Average SQL Average   ...;            SQL
 
MySQL Nested Select Example
;   MySQL Nested Select is select query, that is nested inside... on the condition of nested select query specified in Where Clause. Understand with Example The Tutorial illustrate an example from 'MySQL Nested Select
 
SQL PHP
'stu' in database using select query. The echo print all the records values...()); $sql="Select * from stu "; $sql_result=mysql_query($sql,$connection...;Could not connect: ".mysql_error()); mysql_select_db($database
 
SQL Use
;         SQL Use Query is used to see the tables in database. Understand with Example The Tutorial... Database: To create and show tables in the database 'komal', we use a query
 
Mysql Date Query
in database.       Query to show Current date: mysql... Mysql Date Query Mysql Date Query...; Mysql Date Query Date Query is used to return the current date, month and year
 
Where Clause in SQL
;  The Where clause in SQL query is used  with the SELECT... The Tutorial illustrate an example from where clause in SQL. In this Tutorial we use a select query to retrieve the record from  table 'country
 
sql php array
array from MySQL database. Understand with Example  The Tutorial...()); mysql_select_db($database,$connection) or die("Error in selecting... ($array as $value){ $sql="Select * from stu where id =".$value
 
JDBC, JDBC Tutorial, JDBC Tutorials
to manipulate data stored into the database. Here is the complete tutorial on JDBC... especially relational database by using the java programming language. It includes... a connection to a database.  The Driver Manager also helps to select the most
 
SQL Union
is used to combine the query of two or more Select Statement. The Union Clause.... Understand with Example The Tutorial illustrate an example from 'SQL Union... UNION SQL Union    
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.