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
Guys,
How do i select and insert a data from 1 table to another with same table
fields.
mysql select * from cardv2_data where refcode = '10-44';
Is it like this??
mysql select * from cardv2_data where refcode = '10-44'; insert into * copy
this to this table.
Please help!
--
Louie Miranda
Louie Miranda wrote:
How do i select and insert a data from 1 table to another with same table
fields.
INSERT .. SELECT -- it's in the manual at:
http://dev.mysql.com/doc/mysql/en/insert-select.html
It's always good to read the manual before asking questions on the list,
as a large number
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
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
same
Hello
I belive this is not the correct place to ask the
question. You can try your discussion forums at
http://www.webyog.com/forums for SQLyog specific
questions.
Karam
--- William IT [EMAIL PROTECTED] wrote:
Why SQLyog can not insert/update Table w/o Primary
Key? Is there additional setting
Out of interest is there any advantage of using a primary key?, or is it
perfectly ok/normal not to specify one?.
Im not quite sure what a primary does. I only used a primary key on one
table which had auto_increment column only because it forced me to add it.
??
Hello
I belive this is not
Probably this is what you want
http://www.webyog.com/forums/index.php?act=STf=5t=351s=7cd9c97584811d72b9305d3e691ab28f
Karam
--- Daniel Crompton [EMAIL PROTECTED]
wrote:
Out of interest is there any advantage of using a
primary key?, or is it
perfectly ok/normal not to specify one?.
Im not
Why SQLyog can not insert/update Table w/o Primary Key? Is there additional setting to
enable this?
I first posted this on the php-db list, but am not getting the proper
results yet, so I am copying here, hopefully someone can help me figure
this one out...
I have a form with a select list and a hidden field to save the selected
item. On submit another page is loaded with a few fields to be
I have a server (any server, could be a RADIUS, a DNS or a MTA) that
logs to a file in /var/logs/log-file. Is there a way to take the raw
data sent to the log file and INSERT it into a table? Can this be
done on the fly, meaning, the data isn't stored in the flat text file
at all, but
Hello,
I'm looking for a solution to INSERT data from a text file that is used
for logging into a MySQL table.
A hypothetical example...
I have a server (any server, could be a RADIUS, a DNS or a MTA) that
logs to a file in /var/logs/log-file. Is there a way to take the raw
data sent to the
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
= mySQL Request.Form(PostalCode) ')
---
The white paper gives the following my SQL syntax to help with customizing
the SQL string:
INSERT INTO [table] ([DBfield1],[DBfield2]) VALUES
('[form_field1
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 all
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
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 right
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 =
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 =
nt: 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 ('', 'asdf', '2001-03-19 00:3
b.com
http://www.athlonmb.com
[EMAIL PROTECTED]
- Original Message -
From: "Jason Landry" [EMAIL PROTECTED]
To: "Ryan Shrout" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 1:04 AM
Subject: Re: INSERT INTO Table problems
What's the "LIMIT 0,30&qu
21 matches
Mail list logo