Re: Problem with INSERT

2006-07-03 Thread Duane Hill
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 er

Re: Problem with INSERT

2006-07-03 Thread Stefan Hornburg
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 syntax.

Re: Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

2004-09-28 Thread Eldo Skaria
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.field<>t2.field)), each tim

Re: Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

2004-09-24 Thread kernel
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.prodid<>cds.cds_catalog.prodid; Whenever I'm running it, it pro

Re: Problem with insert data

2003-10-29 Thread Rafal Kedziorski
hi, the MySQL syntax said: INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES ((expression | DEFAULT),...),(...),... [ ON DUPLICATE KEY UPDATE col_name=expression, ... ] or INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(co

Re: Problem with insert data

2003-10-28 Thread Rafal Kedziorski
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, status,

Re: Problem with insert data

2003-10-28 Thread gerald_clark
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 ('35F7A

Re: Problem with Insert

2002-02-27 Thread Arjen Lentz
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... > > > > > > > I am then using PHP to insert the info

Re: Problem with Insert

2002-02-27 Thread Chris Herold
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... I am then using PHP to insert the information into MySQL... <> When $abstract is relatively short/small (3 or

Re: Problem with INSERT INTO ... SELECT

2001-08-20 Thread Philip Mak
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 colu

RE: Problem with INSERT INTO ... SELECT

2001-08-20 Thread Cord Thomas
Michiel i believe you need to tell the target what fields it will have too... INSERT INTO Table1 (A, B) SELECT Table2.A, Table2.B FROM Table2 Of course you can omit the Table2. part in this trivial case. making it INSERT INTO Table1 (A, B) SELECT A, B FROM Table2 -Original Message- Fr