, 2005 9:26 am
Subject: Re: problem with update statement
> Hi,
> this is an example where what you describe doesn't happen (v 4.1
> and 5.0) :
> mysql> create table ports(mac varchar(17),port_index varchar(3));
> Query OK, 0 rows affected (0.10 sec)
>
> mysql> in
Hi,
this is an example where what you describe doesn't happen (v 4.1 and 5.0) :
mysql> create table ports(mac varchar(17),port_index varchar(3));
Query OK, 0 rows affected (0.10 sec)
mysql> insert into ports values('00:04:FB:23:5A:44','120'),(NULL,'120');
Query OK, 2 rows affected (0.08 sec)
Recor
That is very odd behavior and shouldn't be happening. I ran a quick
test on my machine and MySQL does not exhibit that behavior. You may
try running and repair on your table. Perhaps something is out of
whack. What version of MySQL are you running?
On Apr 22, 2005, at 6:08 PM, [EMAIL PROTECTED]
Hello, all:
In a MyISAM table, I have a column named "MAC", of type VARCHAR(17).
This field is used to hold MAC addresses of computers' network
interface cards. These MAC addresses are in the
form "XX:XX:XX:XX:XX:XX", where X can be either a number or an
uppercase letter. I can run "select
On 10-Aug-2001 Julian Simpson wrote:
> In what way is it mangling my query?
> and why won't the same query work from my php script.
> I would accept this if it was just any interface but myphpadmin is supposed
> to be in line with mysql standards.
>
>>> update cdrequest set albumfill = "hot sho
>> In what way is it mangling my query?
>> and why won't the same query work from my php script.
>> I would accept this if it was just any interface but myphpadmin is supposed to be
>in line with mysql standards.
>>
>> >> update cdrequest set albumfill = "hot shots II", releasedatefill
>> >> =
On Fri, Aug 10, 2001 at 02:19:21AM -0400, Julian Simpson wrote:
> In what way is it mangling my query?
> and why won't the same query work from my php script.
> I would accept this if it was just any interface but myphpadmin is supposed to be in
>line with mysql standards.
>
> >> update cdreque
In what way is it mangling my query?
and why won't the same query work from my php script.
I would accept this if it was just any interface but myphpadmin is supposed to be in
line with mysql standards.
>> update cdrequest set albumfill = "hot shots II", releasedatefill
>> = 20010708 where requ
> update cdrequest set albumfill = "hot shots II", releasedatefill
> = 20010708 where requstID = 2;
>
> i get:
> You have an error in your SQL syntax near '\"hot shots II\",
> releasedatefill = 20010708 where requstID = 2' at line 1
> I can't see any reason for the error.
Your web based inte
I have a table 'cdrequest' it has columns 'albumfill' and 'releasedatefill' among
others
when i do the following query with myphpadmin
update cdrequest set albumfill = "hot shots II", releasedatefill = 20010708 where
requstID = 2;
i get:
You have an error in your SQL syntax near '\"hot sh
10 matches
Mail list logo
