Выбрать данные из одной таблицы и вставить в другую.

21.09.2008, 12:29. **Показов** 1490. **Ответов** 1

Author24 — интернет-сервис помощи студентам

neobhodimo vibrat is odnoi table opredelennie dannie
i zasunut ih v druguyu table

kogda delaju select poluchaju 2661 rows,
kogda insert to 2639. pochemu teraju chast strok?

vot queries:
1)strSelect='Select site_id,site_address from sites_ratings where site_id<>0 and not category is null' ;

2)strInsert='INSERT INTO sites_addresses(site_id,site_address) VALUES('& site_id & ','' & site_address & '')' ,gde

site_id=rs.fields('site_id').value, a site_address=rs.fields('site_address').value , poluchenie is predidushego zaprosa.

table sites_addresses sostoit is 2 fields(site_id,site_address) na oboih stoit primary key

table sites_ratings sostoit iz kuchi fields, na filde site_address stoit primery key.

u kogo kakie misli po povodu vozmozhnih oshibok?
spasibo zaranee.

@Roby · 21.09.2008, 15:48

Попробуй одним запросом:
INSERT INTO site_addresses (site_id,site_address) SELECT site_id,site_address from sites_ratings WHERE site_id<>0 AND NOT category IS NULL

bakss
		1
	Выбрать данные из одной таблицы и вставить в другую. 21.09.2008, 12:29. Показов 1490. Ответов 1 Метки нет (Все метки) neobhodimo vibrat is odnoi table opredelennie dannie i zasunut ih v druguyu table kogda delaju select poluchaju 2661 rows, kogda insert to 2639. pochemu teraju chast strok? vot queries: 1)strSelect='Select site_id,site_address from sites_ratings where site_id<>0 and not category is null' ; 2)strInsert='INSERT INTO sites_addresses(site_id,site_address) VALUES('& site_id & ','' & site_address & '')' ,gde site_id=rs.fields('site_id').value, a site_address=rs.fields('site_address').value , poluchenie is predidushego zaprosa. table sites_addresses sostoit is 2 fields(site_id,site_address) na oboih stoit primary key table sites_ratings sostoit iz kuchi fields, na filde site_address stoit primery key. u kogo kakie misli po povodu vozmozhnih oshibok? spasibo zaranee.

@Roby 0 / 0 / 0 Регистрация: 29.05.2007 Сообщений: 354
	21.09.2008, 15:48	2
	Попробуй одним запросом: INSERT INTO site_addresses (site_id,site_address) SELECT site_id,site_address from sites_ratings WHERE site_id<>0 AND NOT category IS NULL 0