Hello,
There must have been some changes in the default interpretation
respective to foreign key attributes
If I add explicitly 'not null' to the columns host_id and admin_id
in test_nkomp_admin, it works like intended:
create table test_nkomp_admin
(
host_id int unsigned not null,
admin
Phillip,
give us a starting point: what OS do you plan to use? For windows,
there are monolithic LAMP installs in one big .msi file that I am told
works fairly well.
Under various linux disto's, it is usually a matter of installing a
set of packages via yum or apt-get.. which ones will depend on
Greetings All,
I am in a new shop and we are redesigning the web site.
For development I am setting up a
Development/Staging/Production environment.
I just realized yesterday that I have never been involved in setting that up
from a database end, only the php coding end for webpages.
What are my
I have two of Paul's books and they are excellent.
- Original Message -
From: "Paul DuBois"
To: "[MySQL] Mysql list"
Cc: "MikeB" ; "Philip Riebold"
Sent: Thursday, October 28, 2010 1:45 PM
Subject: Re: SQL book recommendation?
On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote:
Most helpful people of all time -
I have a student who uninstalled his mySQL and then reinstalled. When
the wizard gets to the point of starting the server, it sits there for a
couple of minutes and then the wizard has a message that it is not
responding. As suggested on the developer zone, he rem
On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote:
>
> On 26 Oct 2010, at 11:49, MikeB wrote:
>
>> I'm finding the MySQL online manuals hard going in figuring out how to
>> construct SQL queries. Can anyone perhaps recommend a good book that can
>> shed light on the subject?
>>
>> Thanks.
>
Some more testing performed and it seems like problem with foreign key
reference indexing, see below:
create table test_nkomp_admin2
(
host_id int unsigned,
admin_id varchar(15),
foreign key (host_id) references test_nkomp (host_id) on delete
cascade on update cascade
)engine=innodb;
crea
On 10/28/2010 03:34 PM, misiaQ wrote:
Works fine on 5.0.87 (rows returned as expected).
Confirmed on 5.1.51-log.
Most likely problem with VARCHAR behavior, because this one works fine:
select * from test_nkomp_admin where host_id=6 and trim(admin_id)='luke';
The thing with the varchar was also
Works fine on 5.0.87 (rows returned as expected).
Confirmed on 5.1.51-log.
Most likely problem with VARCHAR behavior, because this one works fine:
select * from test_nkomp_admin where host_id=6 and trim(admin_id)='luke';
Regards,
m
-Original Message-
From: gregor kling [mailto:gregor.kl
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query works exactly as assumed in version 5.1.41 with
the given testbed:
select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
/* version 5.1.41 ubuntu 1
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query works exactly as assumed in version 5.1.41 with
the given testbed:
select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
/* version 5.1.41 ubuntu 1
11 matches
Mail list logo
