Hi list,
I have some problems with INSERT INTO and UPDATE queries on a big table.
Let me put the code and explain it ...
I have copied the create code of the table. This table has more than
1500 rows.
Create Table: CREATE TABLE `radacct` (
`RadAcctId` bigint(21) NOT NULL AUTO_INCREMENT,
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an error in the statement and to check the syntax. I know
it has
Duane Hill wrote:
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an error in the statement and to check the
On Mon, 3 Jul 2006, Stefan Hornburg wrote:
Duane Hill wrote:
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an
I have been trying to run an fairly large INSERT into an
empty table joining two other tables now for several weeks and have not been
able to get the query to run to completion even when sub-seting the data into smaller
ranges.
I have tried this at MySQL releases 4.1.8a and 4.1.10a
I must assume you have all the proper indexes setup and your
configuration variables are fairly optimal.
First, I would run just the select part with an explain in front of it
to see what MySQL is trying to do. I've had MySQL run a query for an
inordinate amount of time on a fairly small data
I am having a problem doing an insert on a datetime field. Is there
something I have to use to convert it
to that form? I have it set up in a string as '2000/09/17 00:00:00' but
that does not seem to work.
Thanks for any help you can offer.
Bob Rawlinson
--
MySQL General Mailing List
For list
Robert A. Rawlinson wrote:
I am having a problem doing an insert on a datetime field. Is there
something I have to use to convert it
to that form? I have it set up in a string as '2000/09/17 00:00:00'
but that does not seem to work.
Thanks for any help you can offer.
Bob Rawlinson
Sorry! I
Hi Sebastian,
If the new cds_catalog is created with primary key, this should
produce a duplicate key error for the second iteration of the second
table, as the data selected is from cds_catalog alone, but joining two
tables causing cartisian joint to be formed(n*(m-
t1.fieldt2.field)),
each time
Hi!
I have a huge problem with the following insert statement:
INSERT INTO cds_catalog
SELECT cds_stage.cds_catalog.*
FROM cds.cds_catalog, cds_stage.cds_catalog
WHERE cds_stage.cds_catalog.prodidcds.cds_catalog.prodid;
Whenever I'm running it, it produces the error
Sebastian Geib wrote:
Hi!
I have a huge problem with the following insert statement:
INSERT INTO cds_catalog
SELECT cds_stage.cds_catalog.*
FROM cds.cds_catalog, cds_stage.cds_catalog
WHERE cds_stage.cds_catalog.prodidcds.cds_catalog.prodid;
Whenever I'm running it, it
Using PHP i'm not able to insert a binary variable into a field of type
mediumblob of mysql.
The command I've used is:
$cfg_Query = Insert into (operazioni, datacreazione) Values
('.$contents.', Now());
$result = mysql_query($cfg_Query, $conn)
where $contents is the binary variable.
Can
giovanni cordeschi wrote:
Using PHP i'm not able to insert a binary variable into a field of type
mediumblob of mysql.
The command I've used is:
$cfg_Query = Insert into (operazioni, datacreazione) Values
('.$contents.', Now());
$result = mysql_query($cfg_Query, $conn)
It doesn't appear there
What error message are you getting or how are you verifying that the data is
not loading correctly?
-Original Message-
From: giovanni cordeschi
To: [EMAIL PROTECTED]
Sent: 5/25/04 11:23 AM
Subject: Problem while insert binary
Using PHP i'm not able to insert a binary variable
This problem is completely repeatable, I'm not the only one having it,
and I've found a (temporary) workaround. I'm not sure if it affects
other machines than AMD64, but it certainly affects them. I've tested
on two now.
If you start MySQL with skip-concurrent-insert, the problem completely
, but it certainly affects them. I've tested
on two now.
If you start MySQL with skip-concurrent-insert, the problem completely
disappears.
I'm going to try to add it to MySQL's bug database, but as I've never
used theirs before, I'm hoping some MySQL people might see this email
and do a little
FWIW, I'm still having this problem.
I've completely dropped the table and re-built it from the ground up.
It's a bizarre problem... The table is totally simple. A primary key,
and then three varchar fields. The FULLTEXT index spans the 3 varchar
fields. There are only 6500+ rows, so it's
* dan orlic
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
+ g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
now() as
dan orlic wrote:
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
+ g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
now()
Hi there,
I've got a bizarre problem I can't seem to solve. I have a small MyISAM
table (6533 rows) with a small FULLTEXT index (3 columns per row, an
average of 1 word per column). When I do an INSERT on the table, many
times the thread gets stuck perpetually in Query | update. Future
[(col_name,...)]
SELECT ...
or INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name
SET col_name=(expression | DEFAULT), ...
[ ON DUPLICATE KEY UPDATE col_name=expression, ... ]
also while insert into user(...) failed is an MySQL problem, while after
INSERT
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I have
problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status, creation_date,
last_login_date) values
Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I
have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status, creation_date,
last_login_date) values
At 15:09 28.10.2003 -0600, gerald_clark wrote:
Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I
have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password,
Hi,
my name is Francesca and I've a problem with the space character using mysql.
I try to explain the problem in a way similar to mysqldebug.txt.
m: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Problem updating a CHAR(1) columns whith a space character.
Description:
I have a
hi,
i have 2 tables:
currencyrates
+-+++
| code char(3)|| currency char(3) |
| name varchar(10)|| rate double|
| bcurrency char(1) |
Hi-
Problem:
Having trouble inserting text files longer than a few lines into MySQL
although short ones go in fine.
I'm using a form in HTML to get a value for $abstract...
form method=POST action=abstract_submit.php
textarea name=abstract rows=20 cols=70/textarea
/form
I am then using PHP
Hi Chris,
On Thu, 2002-02-28 at 10:26, Chris Herold wrote:
Problem:
Having trouble inserting text files longer than a few lines into MySQL
although short ones go in fine.
I'm using a form in HTML to get a value for $abstract...
form method=POST action=abstract_submit.php
textarea
Hello,
This is the situation:
Table1:
ID Startnr TijdAfstand SlagDatum Opmerking CRvan CRtot PR
Categorie
Table2:
Identical columns.
What is the problem? I'm trying to append all the values from table2 to
table1.
I was trying this SQL query:
insert into table1
-
From: Michiel Leegwater [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 3:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Problem with INSERT INTO ... SELECT
Hello,
This is the situation:
Table1:
ID Startnr TijdAfstand SlagDatum Opmerking CRvan CRtot PR
On Mon, 20 Aug 2001, Michiel Leegwater wrote:
insert into table1 select Startnr, Tijd, Afstand, Slag, Datum, Opmerking,
CRvan,CRtot,PR,Categorie from table2;
This doesn't work, it says Column count doesn't match value count at row 1
I understand the problem. But I can't use my ID column in
31 matches
Mail list logo
