PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español 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, 20,ago. 2012 18:54 - 2 respuestas
#1
Miembro registrado
5 mensajes
Publicado el 20,agosto 2012 - 18:54
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 el 19,octubre 2012 - 17:34
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 el 22,noviembre 2012 - 09:44
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
→ Volver a WEBDEV 2024