S | | NULL
||
+---+-+--+-+-++
Claudio, good point.
Unfortunately, didn't work. I tried it before but no luck.
Thanks,
Igor
On 07/09/2011 02:43 PM, Johnny Withers wrote:
>
> It seems to me that your insert statement is trying
That's what is bad of SP in MySQL, debugging.
Just out of the blue,
can you try to disable query cache?
*SET GLOBAL query_cache_size = 0;*
*
SET GLOBAL query_cache_type = 0;
*
it could be a bug
Claudio
2011/7/9 Johnny Withers
> It seems to me that your insert statement is t
It seems to me that your insert statement is trying to insert duplicate rows
into the storage table. This is why insert ignore and replace work.
On Jul 9, 2011 3:49 AM, "Igor Shevtsov" wrote:
Hi all,
I can't explain strange behaviour of the INSERT statement in the stored
procedu
Hi all,
I can't explain strange behaviour of the INSERT statement in the stored
procedure.
The idea is to generate a list based on the output of 3 INNER JOIN of
regularly updated tables.
Something like :
INSERT INTO storage
(column list)
SELECT
column list
FROM t1 JOIN t2
ON t1.x=t2.y
JOIN
Mário Gamito <[EMAIL PROTECTED]> wrote on 02/12/2008 01:00:25 AM:
> Hi,
>
> Is it possible to send an INSERT statement from a Windows server running
> MS SQL SERVER 2005 to a Linux box running MySQL ?
>
> If so, how ? Do I need any special tools ?
>
> Any help w
Save the sql statement to text file,then execute it inside the mysql shell.
On Feb 12, 2008 2:00 PM, Mário Gamito <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to send an INSERT statement from a Windows server running
> MS SQL SERVER 2005 to a Linux box running MySQL ?
&
Hi,
Is it possible to send an INSERT statement from a Windows server running
MS SQL SERVER 2005 to a Linux box running MySQL ?
If so, how ? Do I need any special tools ?
Any help would be appreciated.
Warm Regards,
Mário Gamito
--
MySQL General Mailing List
For list archives: http
0',
> > `email` varchar(128) NOT NULL DEFAULT '',
> > PRIMARY KEY (`id`),
> > UNIQUE KEY `email` (`email`)
> > ) ENGINE=InnoDB;
> >
> > Question:
> >
> > 1)
> > When I INSERT a row is there any way to be able in the
> > same INSERT
L DEFAULT '',
> PRIMARY KEY (`id`),
> UNIQUE KEY `email` (`email`)
> ) ENGINE=InnoDB;
>
> Question:
>
> 1)
> When I INSERT a row is there any way to be able in the
> same INSERT statement (without doing an UPDATE after
> the insert) to populate the field `
KEY (`id`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB;
Question:
1)
When I INSERT a row is there any way to be able in the
same INSERT statement (without doing an UPDATE after
the insert) to populate the field `sid`, which is base
on the value that the field `id` gets (e.g. sid= MOD
(id, 20)
Chris W. Parker wrote:
Hello,
Me again. Excuse for sending two questions so closely together.
I'm looking through the MySQL manual (as well as searching Google and
the PHP site's MySQL functions) trying to find out how to test an Insert
statement (or any other statement for t
Hello,
Me again. Excuse for sending two questions so closely together.
I'm looking through the MySQL manual (as well as searching Google and
the PHP site's MySQL functions) trying to find out how to test an Insert
statement (or any other statement for that matter).
Although I haven
> Hi folks. I come to the list with another compound question.
> >
> > My middleware allows me to build any syntax for the actual sql
> > statement, so I'm trying to minimize the work done to insert several
> > records at one try. I currently have multiple insert s
ddleware allows me to build any syntax for the actual sql
> statement, so I'm trying to minimize the work done to insert several
> records at one try. I currently have multiple insert statements, but
> can't find any reference to multiple records added using one insert
> state
ference to multiple records added using one insert
statement. I now have:
-SQL = "INSERT INTO mytable (myfield) VALUES ('alpha');INSERT INTO
mytable (myfield) VALUES ('bravo');INSERT INTO mytable (myfield) VALUES
('charlie');INSERT INTO mytable (myfield) VALU
--- [EMAIL PROTECTED] wrote:
> I think you need an UPDATE statement
> UPDATE MyTable set EndDate=DATE_ADD(InitOn, INTERVAL
> LenChoice DAY) WHERE
> RecordID = ;
>
> Insert *always* creates new records if successful
> and cannot be used to
> modify them.
> Update *always* updates recirds in pos
Stuart Felenstein <[EMAIL PROTECTED]> wrote on 26/11/2004 13:54:31:
> I'm trying to build an insert query that will add a
> value into a field , after the first insert query adds
> the record.
>
> Relevant table information:
>
> +-+-++--+
> | RecordID
I'm trying to build an insert query that will add a
value into a field , after the first insert query adds
the record.
Relevant table information:
+-+-++--+
| RecordID| InitOn | LenChoice | EndDate |
+ [PrimID,AutoInc]| [Date] | [int]|
I have a database that is constantly moving large numbers around.
At the moment when a simple INSERT into Table_Name
('3573286532896523465328654654365436543'); is run
the value entered into the table is a zero. The field type that I am inserting
into is DOUBLE(200,0) unsigned.
Also this is all
TECTED]>
Sent: Tuesday, September 28, 2004 5:41 PM
Subject: Re: Multiple Insert Statement?
>
> - Original Message -
> From: "Eve Atley" <[EMAIL PROTECTED]>
> To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
> &
- Original Message -
From: "Eve Atley" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, September 28, 2004 3:56 PM
Subject: RE: Multiple Insert Statement?
>
> Then I
At 02:56 PM 9/28/2004, you wrote:
Then I need help getting on the right track here. What I really want to do
is something like the following:
INSERT INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT
* FROM wow.resume r WHERE r.Candidate_ID = '13103';
You need to match up the colu
Then I need help getting on the right track here. What I really want to do
is something like the following:
INSERT INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT
* FROM wow.resume r WHERE r.Candidate_ID = '13103';
INSERT INTO wow.candidate_erp
(Candidate_ID, Vendor_ID, Last
,
each time the same set of data being inserted.
reg,
Eldo.
On Mon, 27 Sep 2004 14:07:54 +0200 (CEST), Tobias Asplund
<[EMAIL PROTECTED]> wrote:
> On Mon, 27 Sep 2004, Sebastian Geib wrote:
>
> > >> I have a huge problem with the following insert statement:
ELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE
r.Section_ID =
> > '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND
> > c.Candidate_ID = r.Candidate_ID;
> >
> > Is it possible to do a multiple insert statement like so
At 14:16 -0400 9/28/04, Eve Atley wrote:
My query:
SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID =
'1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND
c.Candidate_ID = r.Candidate_ID;
Is it possible to do a multiple insert statement
wow.candidate c WHERE r.Section_ID =
> '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND
> c.Candidate_ID = r.Candidate_ID;
>
> Is it possible to do a multiple insert statement like so?
>
> INSERT INTO wow.candidate_erp
> (Candidate_ID,
My query:
SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID =
'1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND
c.Candidate_ID = r.Candidate_ID;
Is it possible to do a multiple insert statement like so?
INSERT INTO wow.candida
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 run
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 produce
* 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() as
Found that function right after I posted. Thanks, it should do exactly
what I need.
Roger Baklund wrote:
* Scott Plumlee
I've got two separate tables, each with id fields that are
auto-increment. The created fields below are timestamps. The tables
are Innodb tables using transactions to proce
* Scott Plumlee
> I've got two separate tables, each with id fields that are
> auto-increment. The created fields below are timestamps. The tables
> are Innodb tables using transactions to process the statements. This
> will be an online registration process for our business, using PHP and
> MyS
Scott Plumlee wrote:
I've looked through the PHP Cookbook and the MySQL cookbook and haven't
seen a solution. I've thought about trying to make some unique hash
with the data to be inserted but if there's another identical set of
data, then the hash would match. I can't use a timestamp in the
I've got two separate tables, each with id fields that are
auto-increment. The created fields below are timestamps. The tables
are Innodb tables using transactions to process the statements. This
will be an online registration process for our business, using PHP and
MySQL. PHP is using sess
Never mind!
I figured it out :-)
Thanks,
-Bob
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
t it using this:
INSERT INTO `test` SET dt_create = NOW()
However, what I really need is to have the above
INSERT statement (or something that
does the same thing) integrated into another
INSERT statement which looks
something like this:
INSERT INTO `test` (`Title`, `Email`, `City`,
`State`,
INTO `test` SET dt_create = NOW()
However, what I really need is to have the above
INSERT statement (or something that
does the same thing) integrated into another
INSERT statement which looks
something like this:
INSERT INTO `test` (`Title`, `Email`, `City`,
`State`, `Country`, `URL`, `Date`,
`Des
El Sáb 28 Jun 2003 12:24, Zachary Perschall escribió:
> Help! I'm trying to do an insert statement where one of the fields
> sometimes contains an apostrophe. The field type is a varchar. Everytime
> that one of these values comes up with an apostrophe, it tells me there is
> a
;m trying to do an insert statement where one of the fields
> sometimes contains an apostrophe. The field type is a varchar. Everytime
> that one of these values comes up with an apostrophe, it tells me there
> is an error in my SQL statement (obviously because it thinks there are
> m
C. just use the appropriate str_replace() functions of that language to replace those
apostrophes.
-yves
-Ursprüngliche Nachricht-
Von: "Zachary Perschall" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECTED]>
Gesendet: Samstag, 28. Juni 2003 20:24
Betreff: Insert statemen
Help! I'm trying to do an insert statement where one of the fields sometimes contains
an apostrophe. The field type is a varchar. Everytime that one of these values comes
up with an apostrophe, it tells me there is an error in my SQL statement (obviously
because it thinks there are
At 11:37 +1000 2/7/03, boclair wrote:
- Original Message -
From: Paul DuBois <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 8:47 AM
Subject: Re: Using SET in the INSERT statement
: At 14:19 +1000 2/5/03, b
- Original Message -
From: Keith C. Ivey <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 6:47 AM
Subject: Re: Using SET in the INSERT statement
: On 5 Feb 2003, at 14:19, boclair wrote:
:
: > I notice some of my colleagues using SET in IN
AIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 6:17 AM
Subject: RE: Using SET in the INSERT statement
: Are you referring to the data type SET or the Command SET? The manual
page
: you point to is talking about the data type, but
- Original Message -
From: Paul DuBois <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 8:47 AM
Subject: Re: Using SET in the INSERT statement
: At 14:19 +1000 2/5/03, boclair wrote:
: >I notice some of my co
At 14:19 +1000 2/5/03, boclair wrote:
I notice some of my colleagues using SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The reference is short because there isn't much to say about it. :-)
The SET clause consists of col_name=value assignments, separated
by comma
oday.
http://www.mysql.com/doc/en/INSERT.html
-Original Message-
From: boclair [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 8:19 PM
To: [EMAIL PROTECTED]
Subject: Using SET in the INSERT statement
I notice some of my colleagues using SET in INSERT statements.
DuBois makes a short re
On 5 Feb 2003, at 14:19, boclair wrote:
> I notice some of my colleagues using SET in INSERT statements.
>
> DuBois makes a short reference on p565, DoorStop1.
>
> The Manual has some mention in http://www.mysql.com/doc/en/SET.html
You seem to be confusing two unrelated meanings of SET. The S
I notice some of my colleagues have used SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
I sort of get it but I am looking for a fuller explanation.
Louise
(for the filter this time: sql,query,q
I notice some of my colleagues using SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
I sort of get it but I am looking for a fuller explanation.
Louise
---
hat is being sent, and I am getting
this:
http://192.168.1.53/workout-absflexor.php?exerciselist=%24listbox&exercise=80
&reps=12&comments=&submit=Send+Data
Notice that the $listbox variable is still not being sent. Notice the
two echo statements both of which shows what's in that var
At 17:30 -0400 6/21/02, Michael Jessop wrote:
>Can someone tell me what this means? I mean, I guess I *know* what it
>means, but why?
Placeholders for Python scripts using MySQLdb should be %s, not ?.
Convert your ? characters to %s and see what happens.
>
>The insert statement
Can someone tell me what this means? I mean, I guess I *know* what it
means, but why?
The insert statement into a mysql database is...
'insert into works values(?, ?, ?, ?, ? ,?)'
The invocation of the dynamic sql is...
status = cur_mysql.execute(sql,
(wrk_inst, ZERO
Hello,
I'm having some trouble constructing my first INSERT statement into
multiple tables. I'm using PHP4. I have written the following INSERT
statement with no problems:
$sql = "INSERT INTO main (name, ext, stor_pre, stor_base, width, height,
file_size, proj_id, d
eful. Can anybody
>help?
You can't get the primary key value returned from the INSERT statement
itself. But (assuming the key is an AUTO_INCREMENT column), you can
issue this query after the INSERT to get the valu
I have a query where I am inserting a record into a db, and would like to
have the primary key
value returned, I have been reading and reading, but I can't seem to find
any mention of this. I would think that this would be useful. Can anybody
help?
__
Hi Curtis!
On Sat, 27 Oct 2001, Curtis Gordon wrote:
> omg!
> code red!!
> I JUST installed apache and mysql the other day because my host went down
> and I didn't want to miss out on dev time!
> Is is possible that the downloads i grabbed were already infected?
I think you're fine. Those were
omg!
code red!!
I JUST installed apache and mysql the other day because my host went down
and I didn't want to miss out on dev time!
Is is possible that the downloads i grabbed were already infected?
_
Get your FREE download of MSN
That's W32.Nimda, I believe. Maybe Code Red.
Every 10 minutes or so, you'll get 16 or so attempts shot to yer log.
But yes, this has nothing to do with MySQL.
Mike
Curtis Gordon wrote:
> hi Jim, I am finding a TON of errors like this one..
>
> [Sat Oct 27 01:14:57 2001] [error] [client **.***
hi Jim, I am finding a TON of errors like this one..
[Sat Oct 27 01:14:57 2001] [error] [client **.***.***.**] File does not
exist: c:/phpweb/scripts/..%5c/winnt/system32/cmd.exe
I am not on a winnt system though, I'm running winME here at home. It looks
to me like somebody is trying to access
Hello,
I am trying to insert large TEXT data into a MySQL database. The
server rejects insert statements that include a 15MB text file.
The manual says to change "max_allowed_packet" for the server
to accept large data. I have set this on the server side to
65535KB, which appears to be the larges
> This is how I'd like the query to work:
> insert into host (host_id, host_IP) values ((select from mail
> mail_id where
> mail_addr = "[EMAIL PROTECTED]"), '127.0.0.1')
Try:
insert into host (host_id, host_IP) select mail_id, '127.0.0.1' from mail
where mail_addr = '[EMAIL PROTECTED]';
-
As I've understood it mysql doesn't support sub-selects inside for example
insert statements
(apart from inset ... select).
Background-stuff:
What I'm working on is parsing logfiles and inserting them into a mysql
database through the C API,
to minimize traffic and to maximize time, I was hopin
At 5:30 PM -0500 3/23/01, Lee Jenkins wrote:
>I apologize because I know I've seen this somewhere on the list before
>(should have saved it). I'm trying to insert some data into CHAR fields
>that have trailing Ascii 0 characters, but get a syntax error.
>
>The data would like this:
>
>23302220202
I apologize because I know I've seen this somewhere on the list before
(should have saved it). I'm trying to insert some data into CHAR fields
that have trailing Ascii 0 characters, but get a syntax error.
The data would like this:
23302220202X
Where "X" represents the
Can anyone see why maybe this set of select/insert statements always inserts a value
of 0 instead of the selected site id in the first select statement? The variable
$getid should hold the site id to be entered into the table ssx but its always entered
at 0 and I get no php or mysql errors. Any
68 matches
Mail list logo
