смотрите. у меня на сайте есть разные бд и в таблице разные названия колонок, как мне адаптировать и перенести эту базу данных по названия колонок в другой бд? короче если не понятно я лучше завтра скринами кину что именно хочу
помощь по переносу базы данных
- Автор темы mmsqn
- Дата начала
Решение
How to import data from one table to another table in sql
I have two database there is two table both databse how to import data from database table to another database table in sql2008 standard edition. I have tried to export/import function but no luck .
Insert all values of a table into another table in SQL
I am trying to insert all values of one table into another. But the insert statement accepts values, but i would like it to accept a select * from the initial_Table. Is this possible?
McLore
Известный
- 548
- 271
How to import data from one table to another table in sql
I have two database there is two table both databse how to import data from database table to another database table in sql2008 standard edition. I have tried to export/import function but no luck .
Insert all values of a table into another table in SQL
I am trying to insert all values of one table into another. But the insert statement accepts values, but i would like it to accept a select * from the initial_Table. Is this possible?
Решение
Не особо понял как пользоватьсяHow to import data from one table to another table in sql
I have two database there is two table both databse how to import data from database table to another database table in sql2008 standard edition. I have tried to export/import function but no luck .stackoverflow.com
Insert all values of a table into another table in SQL
I am trying to insert all values of one table into another. But the insert statement accepts values, but i would like it to accept a select * from the initial_Table. Is this possible?
SQL:
INSERT INTO new_table (Foo, Bar, Fizz, Buzz)
SELECT Foo, Bar, Fizz, Buzz
FROM initial_table
-- optionally WHERE ...все разобрался, спасибо!
Последнее редактирование:
