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 2003
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 Se
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
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 d
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
> b
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
mysql>in
posted 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
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 ch
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 Gam
~
>
>
>
> -Original Message-
> From: Mariusz Muszalski [mailto:[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)
> Decl
D]
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 GameID=1 Order by Date DESC
Select @BF As BF, @BL As BL
--
Now wonna to
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 myS
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 lik
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 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 dat
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
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 que
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
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 co
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:
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
Tuesday, January 30, 2001 6:28 AM
Subject: Insert Problem
I have a record being inserted and I don't see what the problem is. This is
the insert statement:
insert into auth_users (username, password, firstname, lastname, address1,
address2, city, state, zip, phone, fax, email, hint) values
I have a record being inserted and I don't see what the problem is. This is the insert
statement:
insert into auth_users (username, password, firstname, lastname, address1, address2,
city, state, zip, phone, fax, email, hint) values ("username", "password",
"firstname", "lastname", "Address1",
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 7
, January 24, 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
> reco
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 d
38 matches
Mail list logo
