Problem with INSERT INTO and UPDATE queries

2014-06-25 Thread Antonio Fernández Pérez
​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,

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.

Problem with INSERT

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

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

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

2004-09-24 Thread Sebastian Geib
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 produces the error mentio

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

Problem with insert data

2003-10-28 Thread Rafal Kedziorski
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 ('35F7A660096411D89BC0D1907F

Query problem with insert into....select

2002-04-17 Thread Inandjo Taurel
hi, i have 2 tables: currencyrates +-+++ | code char(3)|| currency char(3) | | name varchar(10)|| rate double| | bcurrency char(1) |

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
- 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

Problem with INSERT INTO ... SELECT

2001-08-20 Thread Michiel Leegwater
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 s