PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WEBDEV 2024
→
How to insert (SQL) many records to the table a time?
How to insert (SQL) many records to the table a time?
Started by Alexander S, Aug., 20 2012 6:54 PM - 2 replies
Connect yourself…
Alexander S
#1
Registered member
5 messages
Posted on August, 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.
Report
0
0
Andy Stapleton
#2
Posted on October, 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.
Report
0
0
Biju
#3
Posted on November, 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
Report
0
0
→ Go back to WEBDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text