Insert into table select * ... union

Hello, I'm collecting data into a very simple table with one varchar(100) field ("myValue") and one int(10) field ("Qty"). I'm doing this with a simple "insert into . on duplicate key update qty = qty +1". After the table has reached a count of several 10 million records every insert takes

Re: insert into table select ...

Gaspar Bakos <[EMAIL PROTECTED]> wrote: > > I am trying to duplicate a row of a table in the following way: > > insert into Observer select * from Observer where OBid = 4; > ERROR 1066: Not unique table/alias: 'Observer' > > It is a unique table; I mean there can't be another table named in the

insert into table select ...

Hi, I am trying to duplicate a row of a table in the following way: insert into Observer select * from Observer where OBid = 4; ERROR 1066: Not unique table/alias: 'Observer' It is a unique table; I mean there can't be another table named in the same way. Any pointer would be welcome. Probably

Insert into Table

Hi, I have a table in which i have a field of VARCHAR(255), i am picking up URLs from a file and INSERTING into mysql table, i am using MySQL C API, the problem is that file contains 6700 records and it is just inserting few records like 100 or so, what may be the probnlem Please help Sameer

RE: Problem with using INSERT INTO [table] SQL string

you read that article you may get a better understating of what I am trying to relay. Thanks Dan -Original Message- From: Donald Guy [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 9:55 AM To: [EMAIL PROTECTED] Subject: Problem with using INSERT INTO [table] SQL string Hi

Problem with using INSERT INTO [table] SQL string

orm("Region") & "','" mySQL= mySQL & Request.Form("PostalCode") & "')" --- The white paper gives the following my SQL syntax to help with c

Re: Newbie question: can't create/insert into table

Hi. On Tue, Feb 19, 2002 at 04:15:36AM +0300, [EMAIL PROTECTED] wrote: > > I am a total MySQL newbie using MySQL 3.22.32. [...] > create table temp1 > -> select field_x > -> from MyData; > > But, I get a syntax error (ERROR 1064) on line 2. > > Would somebody please point me at the ri

Newbie question: can't create/insert into table

Hi, I am a total MySQL newbie using MySQL 3.22.32. I am trying to simultaneously create a table and insert some data into it as follows: create table temp1 -> select field_x -> from MyData; But, I get a syntax error (ERROR 1064) on line 2. Would somebody please point me at the right

Re: INSERT INTO Table problems

make sure the values are placed in the correct columns? Ryan Shrout Production Manager Athlonmb.com http://www.athlonmb.com [EMAIL PROTECTED] - Original Message - From: "Jason Landry" <[EMAIL PROTECTED]> To: "Ryan Shrout" <[EMAIL PROTECTED]>; <[EMAIL PRO

Re: INSERT INTO Table problems

To: <[EMAIL PROTECTED]> Sent: Sunday, March 18, 2001 11:39 PM Subject: INSERT INTO Table problems Okay, another question from the stumbling idiot: what's wrong with this code: $insert_query = "INSERT INTO news (NewsID, Title, Date, Author, Source, Link, Information, Status) VALUES (&

INSERT INTO Table problems

Okay, another question from the stumbling idiot: what's wrong with this code: $insert_query = "INSERT INTO news (NewsID, Title, Date, Author, Source, Link, Information, Status) VALUES ('', 'asdf', '2001-03-19 00:33:47', '1', 'asdf', 'asdf', 'asdf', '2') LIMIT 0, 30"; $insert_result = mysql_quer

INSERT INTO Table problems

Okay, another question from the stumbling idiot: what's wrong with this code: $insert_query = "INSERT INTO news (NewsID, Title, Date, Author, Source, Link, Information, Status) VALUES ('', 'asdf', '2001-03-19 00:33:47', '1', 'asdf', 'asdf', 'asdf', '2') LIMIT 0, 30"; $insert_result = mysql_quer