" /> Password <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
PDF 

1
2
3

SELECT *
INTO  [IN ]
FROM old_tablename
 

1
2
3

SELECT column_name(s)
INTO  [IN ]
FROM old_tablename

Пример

For this we use this query:

1
2
3

SELECT *
INTO Persons_Backup
FROM Persons
 

1
2
3

SELECT *
INTO Persons_Backup IN 'Backup.mdb'
FROM Persons
 

1
2
3

SELECT LastName,FirstName
INTO Persons_Backup
FROM Persons

- С Условием WHERE

1
2
3
4

SELECT LastName,Firstname
INTO Persons_Backup
FROM Persons
WHERE City=

- Joined Tables

1
2
3
4
5

SELECT Persons.LastName,Orders.OrderNo
INTO 
FROM Persons
 JOIN Orders
ON Persons.P_Id=Orders.P_Id

Comments

 
0 #1 Lirriella 2011-06-22 16:42 Oh, how different otvet Odin ticket:)
Thank you very much, great site you have, find everything you need, and is described briefly and clear! Quote
 
 
+2 #2 ывав 2011-10-11 10:06 and how to choose the field "all but ..."? Quote
 
 
+3 #3 Nikolas 2011-11-07 10:03
and how to choose the field "all but ..."?






 Quote
 
 
+3 #4 Nikolas 2011-11-07 10:05 Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Advertisement
© 2009 ageent.ru.