|
I have a problem here. I have about 13K rows of data that I want to put into a mysql database. What I notice is that if the row is "short" the insert will happen but if it is long, it fails. I have been trying to figure this out all day and I'm about ...
Started by Jim on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
", I can insert both lines of data without.
PRIMARY KEY ( id ) ....
That, provided your query is "....
|
|
I'm trying to insert this array into a database:
Array ( [0] => 1 [1] => 2376 [2] => 1804229942 53 [3] => 99 [4] => 120510105 5525 [5] => 99 [6] => 21581237 622 [7] => 99 [8] => 46612404 3 [9] => 99 [10] => 174284497 8...
Started by Andrieux on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You can user a FOR to build you query in a string
if your query is to big and mysql will fail to run it:
you can insert just 10 fields, then return the inserted ID' Table.field2 := 'V45:10V46:175' .....
Typing $array[1], $array[2]...
|
|
I'm looking for a good way to perform multi-row inserts into an Oracle 9 database. The following works in MySQL but doesn't seem to be supported in Oracle.
INSERT INTO TMP_DIM_EXCH_RT (EXCH_WH_KEY, EXCH_NAT_KEY, EXCH_DATE, EXCH_RATE, FROM_CURCY_CD, TO...
Started by Jamey on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
( source )
If you have the values that you want to insert in another table already, then you can Insert....
This works in Oracle:
insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE) select 8000,0 is to use the from dual statement.
|
Ask your Facebook Friends
|
I'm trying to speed up my code and the bottleneck seems to be the individual insert statements to a Jet MDB from outside Access via ODBC. I need to insert 100 rows at a time and have to repeat that many times.
It is possible to insert multiple rows in...
Started by Thierry on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Use a code = conn.CreateCommand()) { cmd.CommandText....
The insert in a transaction and don't close the connection between each call (eg--pass the command as a parameter) then it is orders of magnitude quicker than open()->INSERT->close() is.
|
|
I am using an HTML form which sends
<input type=hidden name=longdesc value='SMARTNET%^" 8X5XNBD'>
this is done by the following javascript code:
function masinsert(id) { var currentTime=new Date(); var button = document.getElementById("m"+id); button...
Started by phill on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you're using PreparedStatement, why aren't you using bound variables?
insert("INSERT INTO itemdescription (longdesc) values(?)"); ps.setString(1, itemdescription.
|
|
First Observation, limitation with this BCP format file Data File: (Continuous up to three lines)
1;a;b;c;d;e;f;; 2;d;e;f;g;h;i;; 3;g;h;i;j;k;l;; 4;j;k;l;m;n;o;; 5;m;n;o;p;q;r;; 6;p;q;r;s;t;u;;What bcp format file that I'm gonna used to insert 59 columns...
Answer Snippets (Read the full thread at stackoverflow):
Hidden characters in the data file.
In any case, some things to try:
From here
Check your line termination options .
I suspect a problem with the -c -r and -t options .
Lots of good detail, but you are missing the actual bcp command that you are using .
|
|
I would like to use SSIS to create database table flat file exports then import them in to variously distributed SQL Express installs. As you may guess, SSIS is not available in the Express version. When I do the bulk insert, it errors with:
Msg 4866,...
Started by Dr. Zim on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Ideas why this would be the case?
9.0
29
1 SQLCHAR 0 12 "\t" 1 Record_ID ""
2 SQLCHAR 0 498 "\t" 2 SQL_Latin1_General_CP1_CI_AS
6 SQLCHAR 0 498 "\t" 6 Volume SQL_Latin1_General_CP1_CI_AS
7 SQLCHAR 0 Directory_Path SQL_Latin....
|
|
LISTING CAN BE REMOVED - divided and moved to fitteds and inserts marketplace
FOR SALE:
- 2 EUC Little Beetle OV size 3 [SOLD]
- 6 Almost new Mother-Ease Sandy's Bamboo Terry Inserts [AVAILABLE!]
- 8 BRAND NEW, never washed Applecheeks 2 layer bamboo ...
Started by gardenmama76 on
, 9 posts
by 2 people.
Answer Snippets (Read the full thread at diaperswappers):
Bububebes in pic
Still available: Applecheeks inserts, 3 remaining bububebes, 6 fireflies Traded the white.
|
|
Here is my sample data: 1;a;b;c;; 2;d;e;f;; 3;g;h;i;; 4;j;k;l;; 5;m;n;o;; 6;p;q;r;;
Here is my sample format file (BCP 9): 9.0 7 1 SQLCHAR 0 0 "" 0 x Latin1_General_CI_AS 2 SQLCHAR 0 0 ";" 2 i Latin1_General_CI_AS 3 SQLCHAR 0 0 ";" 3 s Latin1_General_...
Answer Snippets (Read the full thread at stackoverflow):
2;d;e;f;; 3;g;h;i;; 4;j;k;l;; 5;m;n;o;; 6;p;q;r;;
Each line was terminated with a return char 26 ";" 5 ConnectionType SQL_Latin1_General_CP1_CI_AS 6 SQLCHAR 0 42 ";" 6 SessionID - not a continuous line as in your ....
|
|
Sun Aug 02, 2009 11:18 pm by Graham John Baker
Re how do I insert a photogragh of myself Dear Middle age shred
How do I insert a photo of myself in my profile,
please email me some advice on inserting a photo of myself.
hoping to hear from you soon.
Yours...
Started by Graham John Baker on
, 32 posts
by 10 people.
Answer Snippets (Read the full thread at middle-age-shred):
Doing Fri Nov 05, 2010 6:50 am by Drive-By
Re: Re how do I insert a photogragh of myself Quote had my tea !!! Koss -The way a Les Paul should sound ! Mon Sep 07, 2009 7:26 pm by longboard gav
can I insert a photogragh of myself....
|
