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
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 Robert,
I have experience the similar issue with MySQL, MM.MySQL and JBOSS.
I was using CMP-EJBs with INNODB table from MySQL-Max and data did not
persist in the table as I called EJB create(). The issue resolved as I
'alt' the table back to MyISAM tables.
I have posted the issu
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
MySQL does not support multi table updates yet either.
Yosi Oren wrote:
> Hi,
> You are trying to use nested select for that update wich MySQL do not
> support insted use :
> update table set field = value from table inner join table where bla = bla
> .
>
> Sincerely,
>
Hi,
You are trying to use nested select for that update wich MySQL do not
support insted use :
update table set field = value from table inner join table where bla = bla
Sincerely,
Yosi Oren
VP,R&D manager
Tel : +972 4 908 2180 ext 217
Fax : +
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
> 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
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
I have a record being inserted and I don't see what the pr
Hmmm I don't believe you can have a where in an insert statement. You
either do or you don't. Perhaps you are thinking of update?
- Original Message -
From: "Toby Miller" <[EMAIL PROTECTED]>
To: "Liste mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 6:28 AM
Subject: Inser
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
This has nothing to do with PHP, and you should
never expect a relational database to store records
in a specific order.
If you need to order your data, you should create
a key field. Look up AUTO INCREMENT in the manual,
then, if you have trouble, read
http://www.bitbybit.dk/mysqlfaq/faq.html#c
28 matches
Mail list logo
