Have you tried single quotes (ie. registry_program='EA')?
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Mon, 30 Jun
Greetings!!
I'm trying this insert and it will not run in batch mode. I think the '' syntax is
right but what else am I missing??
insert into registry set registry_program=EA, registry_key=BASE_PATH,
registry_value=f:auction;
Robin E. Kopetzky
Black Mesa Computers/Internet
Hi all,
Sorry should have got my mind around the LOAD_FILE('./image.tiff')
method.
M.
In message [EMAIL PROTECTED], Mark Worsdall
[EMAIL PROTECTED] writes
Hi,
After a good old slurp of an image I am trying to stick it into my
table.
# Slurp file
foreach (@image_list) {
my $image =
Hi,
After a good old slurp of an image I am trying to stick it into my
table.
# Slurp file
foreach (@image_list) {
my $image = /usr/home/shadow/Vision/$_;
# Load image into memory
my $imagePIC = do
{
local ($/, *PIC); # slurp mode, local file handle
open PIC, $image or die
hi everybody,
I have problem with inserting data into table.
MY table is:-
Name type
IDint(9)autoincrement
Total int(9)
while i insert the data,i want the total(ID+2).Its mean the record should be
like this:-
ID Total
1 3
2 4
3 5
is it possiblei have try is like this
Hi.
On Mon, Apr 29, 2002 at 10:00:07AM +, [EMAIL PROTECTED] wrote:
hi everybody,
I have problem with inserting data into table.
MY table is:-
Name type
IDint(9)autoincrement
Total int(9)
while i insert the data,i want the total(ID+2).Its mean the record should
be like
the issue in couple of newsgroups but didn't get a reply
on resolving it nor pin-pointing the cause of it.
Regards,
Michael
- Original Message -
From: Robert Grey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 11:35 AM
Subject: INSERT Problem with mm.mysql, JBoss
Try it like this --
SELECT @BF:=Date FROM Results WHERE GameID=1 ORDER BY Date ASC LIMIT
1;
SELECT @BL:=Date FROM Results WHERE GameID=1 ORDER BY Date DESC LIMIT
1;
SELECT @BF AS BF, @BL AS BL;
Mariusz Muszalski [EMAIL PROTECTED] wrote:
Look at this MS SQL:
Declare @BF
Look at this MS SQL:
Declare @BF char(10)
Declare @BL char(10)
SET ROWCOUNT 1
Select @BF=Date From Results Where GameID=1 Order by Date ASC
Select @BL=Date From Results Where GameID=1 Order by Date DESC
Select @BF As BF, @BL As BL
--
Now wonna to implement above to
: +972 4 908 2181
Mobile : +972 54 533190
E-mail: [EMAIL PROTECTED]
Web : www.spiralsolutions.com
-Original Message-
From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 12:44 PM
To: [EMAIL PROTECTED]
Subject: INSERT
:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 12:44 PM
To: [EMAIL PROTECTED]
Subject: INSERT problem
Look at this MS SQL:
Declare @BF char(10)
Declare @BL char(10)
SET ROWCOUNT 1
Select @BF=Date From Results Where GameID=1 Order by Date ASC
Select @BL=Date From Results Where
Date |Tue, 14 Aug 2001 10:43:36 +0100
From |Mariusz Muszalski [EMAIL PROTECTED]
Hello!
MM Look at this MS SQL:
MM Declare @BF char(10)
MM Declare @BL char(10)
MM SET ROWCOUNT 1
MM Select @BF=Date From Results Where GameID=1 Order by Date ASC
MM Select @BL=Date From Results Where GameID=1
Glyndower;
I just joined the PHP mailing list. It appears to be fairly active and
knowledgable. Your question seems to be MORE PHP related than MySQL.
I know, I hate joining half a dozen lists to get answers, and the MySQL
list has been most helpful with database questions, but this sounds
Hi all,
I'm new to the whole PHP and MySql stuff and I hopeful that I can get a push
in the right direction for what I'm sure is a very sinple problem.
I have succesfully created a databse using telnet and added data to it also
using telnet.
I have also succesfully got the data to display on a
I have succesfully created a databse using telnet and added data to it also
using telnet.
Why not do it with myPhpAdmin? Google shows you the address. Very
convienient. It pays at least in the long run - you won't bother
with telnet to maintain your db.
I have also succesfully got the data
On Tue, 3 Jul 2001 23:01, Glyndower wrote:
Hi all,
I'm new to the whole PHP and MySql stuff and I hopeful that I can get a
push in the right direction for what I'm sure is a very sinple problem.
I have succesfully created a databse using telnet and added data to it
also using telnet.
I
Hello all
I am running linux mandrake with Mysql vers 3.23.23-beta, for
pc-linux-gnu on i686
I've had a problem with recieving to many connections which i am working
on but my MAIN problem currently is that it will not allow me to insert
into tables.
I cleared out all the connections and can
Hi,
I am running a query using C APIs to insert a large text item into a MySQL table.
The query is as follows
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
You can't use 'where' in 'insert' query. Use 'update' or 'replace'.
- Original Message -
From: Toby Miller [EMAIL PROTECTED]
To: Liste mysql [EMAIL PROTECTED]
Sent: Tuesday, January 30, 2001 2:28 PM
Subject: Insert Problem
I have a record being inserted and I don't see what
My bad, not enough sleep I guess.
Thanks,
Toby
- Original Message -
From: "Roger Ramirez" [EMAIL PROTECTED]
To: "Toby Miller" [EMAIL PROTECTED]
Cc: "MySQL List" [EMAIL PROTECTED]
Sent: Tuesday, January 30, 2001 6:33 AM
Subject: Re: Insert Problem
Hmmm...
On Wed, 24 Jan 2001, Xinkun Wang wrote:
|
|I've got a problem about Mysql table. if I insert several records in a
|certain order, firstly it is ok, but when I delete them and insert those
|records again (in the same sequence), But the order in MySql is totally
|different. For instance, I have
Hi
I've got a problem about Mysql table. if I insert several records in a
certain order, firstly it is ok, but when I delete them and insert those
records again (in the same sequence), But the order in MySql is totally
different. For instance, I have 78 records, when I do insert
secondly, it
, 2001 12:10 PM
To: [EMAIL PROTECTED]
Subject: Insert problem in MYSQL with PHP
Hi
I've got a problem about Mysql table. if I insert several records in a
certain order, firstly it is ok, but when I delete them and insert those
records again (in the same sequence), But the order in MySql
36 matches
Mail list logo