PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WEBDEV 2024 → How to insert (SQL) many records to the table a time?
How to insert (SQL) many records to the table a time?
Iniciado por Alexander S, ago., 20 2012 6:54 PM - 2 respostas
#1
Membro registado
5 mensagems
Publicado em agosto, 20 2012 - 6:54 PM
In WinDev, the INSERT statement is single-tuple: It only adds one record at a time.

The following query IS NOT accepted:
INSERT INTO CUSTOMER VALUES
(1, 'Doe', 'John')
(2, 'Wolff', 'Walter')
(3, 'Black', 'Roger')

But how to insert many records to the table a time? I think to insert one by one will be very slow, if we have about 15000 records.
#2
Publicado em outubro, 19 2012 - 5:34 PM
Depends on the database used, if the data is say in a CSV file, or
ascii file many DB's have a bulk loader like MSSQL does.

will need to know the DB your using

Andy <<Cowboy>> Stapleton
www.ccscowboy.com
Skype Andy_Ccscowboy
Skype WD chat group.






Alexander S formulated on Monday :
In WinDev, the INSERT statement is single-tuple: It only adds one record at a
time.

The following query IS NOT accepted:
INSERT INTO CUSTOMER VALUES
(1, 'Doe', 'John')
(2, 'Wolff', 'Walter')
(3, 'Black', 'Roger')

But how to insert many records to the table a time? I think to insert one by
one will be very slow, if we have about 15000 records.
#3
Publicado em novembro, 22 2012 - 9:44 AM
Hello it is very simple with somewhat identical structure of two different files like [a.Source] [b. target] try like in HF Control center Run SQL Like

INSERT INTO [b. target] SELECT * FROM [a. Source]

The identical data will copied into [b. target]

Thanks
SS-Biju
→ Voltar para WEBDEV 2024