PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WEBDEV 2024 → How to insert (SQL) many records to the table a time?
How to insert (SQL) many records to the table a time?
Débuté par Alexander S, 20 aoû. 2012 18:54 - 2 réponses
#1
Membre enregistré
5 messages
Posté le 20 août 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
Posté le 19 octobre 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
Posté le 22 novembre 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
→ Revenir à WEBDEV 2024