Here is an insert from the innodb reference manual
Suppose you use a consistent read to read the table PARENT and indeed see
the parent of the child in the table. Can you now safely add the child row
to table CHILD? No, because it may happen that meanwhile some other user has
deleted the parent r
On 2002.08.20 01:09 Ruben Safir wrote:
>
> Of course. Monty would *love* you to get MySQL officially into
> OpenOffice, and thereby secure a *huge* automatic userbase for MySQL...
I doubt your installbase is a quarter of Monty's, and Monty doesn't need more users
Everyone with a FS system u
Add the mysql lib path on /etc/ld.so.conf
and type ldconfig.
:)
=
Thanks,
Louie Miranda...
WebUrl: http://axis0.endofinternet.org
Email: [EMAIL PROTECTED] - [EMAIL PROTECTED]
- Original Message -
From: "Nick Stuart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August
Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My
problem is that when I go to connect to it I get the error:
error while loading shared libraries: libmysqlclient.so.11: cannot open
shared object file: No such file or directory
Actually (just fixed it). All I had to do was a
Hi,
Try:
SELECT f.count(*), s.name FROM first f,second s WHERE f.id = s.id GROUP BY
s.name;
Regards,
Jocelyn
- Original Message -
From: "Mark S Lowe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 3:02 AM
Subject: Count(*) using a join?
I need to do a joi
I need to do a join with a count...but for some reason I can¹t figure out
how to do it using MySQL. I¹m hoping that this pseudo code can help you give
me an answer:
> select
>
> f.count(*),
> s.name
>
> from
>
> first f, second s
>
> where
>
> f.id = s.id
How do I get a sql resu
Hi.
Thanks for the reply...
I curious with what you mean by mysql not supporting commit and
rollback coz I found this in the site :
http://www.mysql.com/documentation/mysql/bychapter/manual_Refere
nce.html#COMMIT
Actually, Ive already tested it in my app under weblogic(and
worked). I was just
Hi,
I was hoping someone here might know the best way to setup a mySQL replication
environment where master->slave can be flipped to slave<-master.
NOTE: I am NOT looking for a master<=3D>master bi-directional updating solution. This
is a solution for HA, so when the master "dies" the slave b
> Could anybody:
> 1) Recomend a good book which covers the basics of MySQL, &/or any good
> tutorials on the web?
The mysql documentation is very good, I use
http://www.mysql.com/doc/en/index.html as my home page, but you really have
to know what to look for in order to find it. It's been so lon
HI,
I am just starting out with MySQL, using Tomcat as standalone on a Win2000
machine and java servlets.
Could anybody:
1) Recomend a good book which covers the basics of MySQL, &/or any good
tutorials on the web?
2) Tell me how to set up usernames and passwords for MySQL.
3) Recomend an easy t
HEAP tables can have more than one index, but indexes only match "=" and
"!=" -- so you can't use ">", "<", etc... Also, comparisons only match
the entire index, not the left-most prefix like MyISAM tables. There are a
few other quirks, also:
http://www.mysql.com/doc/en/HEAP.html
--jeff
> On
Assuming intel and putting the CD in /dev/cdrom as root...
On Redhat 7.3... (Install whatever way you want first)
Put in CD#3 (label is Red_Hat_Linux_i3)
mount /dev/cdrom /mnt/cdrom
cd /mnt/cdrom/RedHat/RPMS
rpm -Uvh mysql*
chkconfig mysqld on
/etc/init.d/mysqld start
MySQL 3.23.49 should now
The Red Hat Database is PostgreSQL, but I don't think it comes with RH.
Isn't it a seperate (and rather costly) add-on?
> -Original Message-
> From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 4:40 PM
> To: [EMAIL PROTECTED]
> Subject: RE: mysql comes with li
Redhat (at least 7.3) comes with MySQL. If select the default install for
server, it will NOT install MySQL. You must check the box to Select
individual packages, and check off the MySQL binaries. Of course, you can
always install them After the installation from the CD's but you might have
to
I believe it has both. Mandrake I know has both.
-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 1:40 PM
To: [EMAIL PROTECTED]
Subject: RE: mysql comes with linux ?
I wasn't aware of this. I thought the Red Hat database was PostgreSQL.
--
I don't know if it is installed by default or not (in most distros it is
not), but checking is easy enough: When you get to the point of selecting
packages, click on the "choose individual packages" button or radio box
(it's been a while since I have done a RH installation) and select MySQL and
re
I have a SQL statement to create a PostgreSQL table that include a line 'id serial'
This line creates a integer field with a sequence atached to it to create an autonumber
Is there a way to create a SQL statement to accomplish this that would work with
both MySQL and PostgreSQL
---
I wasn't aware of this. I thought the Red Hat database was PostgreSQL.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: john greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 2:32 PM
To: [EMAIL PROTECTED]
Subject: mysql comes with linux ?
red hat linux implementa
red hat linux implementations by default would have
the mysql database ? ie if i install the server
version of redhat linux then i get mysql database as
well. right ?
any tips whemn using/configuring/installing mysql
database with redhat linux.
___
Hi all,
I manage a web server having a lot of http connections, using
Apache/PHP/MySQL. When there are too many simultaneous connections (so, many
MySQL requests), MySQL stops working efficiently and makes my load average
increase a LOT (already seen it at 100 !). The only way to make it decrease
Yes that's it, Thanks!
> Ignore that correction. It seems that what you want is indeed this:
>
>SELECT Data1
>FROM table_name
>WHERE Data3 = 1
>GROUP BY Data1
>HAVING SUM(Data2 = 141) = 0;
>
> > > [Filter fodder: SQL]
Luc
--
The raid function is not useful (that's to get around the 2GB filesize
limit on certain OS). I think it's a misleading function (I think it
should be called RAIF - Redundant Array of Inexpensive Files).
I use RAID 1 (hardware) scsi and my load looks to be processor bound
(believe it or not) with
On Mon, Aug 19, 2002 at 02:54:02PM -0400, Brent Baisley wrote:
>
> You might want to lookup MySQL and RAID. MySQL does support a
> database RAID setup.
If you change "support" to "provide", I'd agree. We use MySQL on RAID
systems all the time, so it certainly "supports" it.
Jeremy
--
Jeremy D.
You might want to lookup MySQL and RAID. MySQL does support a database
RAID setup. This confused me early on because I kept thinking of disk
based RAID, but this is database based RAID. I haven't used it yet, so
I can't help you any more that that. Hope it helps a little.
On Thursday, August
On Mon, Aug 19, 2002 at 10:55:32AM +0200, Thomas Spahni wrote:
>
> On Fri, 16 Aug 2002, Frank Shute wrote:
>
> > I'm using 3.23.51 and I wondered if the manual was available as
> > separate pages of html in a tarball.
> >
> > The manual as shipped is a single page and as this machine's dog slow
Hi again,
> > Do you use so huge queries that you really need sort_buffer=64M and
> > record_buffer=32M? Don't forget that record_buffer and sort_buffer are
> > specified per-thread.
Well, some further input about this as I've just tried at home
(MySQL 4.0.1-alpha-nt). You seem to be righ
Try the sun site - www.javasoft.com
I believe there are tutorials for JDBC.
Cheers,
Michael
-Original Message-
From: john greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: getting started
i need help with getting started with m
Hi!
On Aug 19, Benjamin Pflugmann wrote:
> Hi.
>
> On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote:
> > Hi, folks!
> >
> > I would apreciate your opinion on my question:
> > How to make a MyISAM table (or several tables) to be shared among different
> > databases served by one MySQ
> Do you use so huge queries that you really need sort_buffer=64M and
> record_buffer=32M? Don't forget that record_buffer and sort_buffer are
> specified per-thread.
I don't know exactly which values I need, but when I generate statistical
data from the tables it often spans a not-so-small d
Hi.
On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote:
> Hi, folks!
>
> I would apreciate your opinion on my question:
> How to make a MyISAM table (or several tables) to be shared among different
> databases served by one MySQL server on Unix (Solaris)? It is OK if this table
> appea
i need help with getting started with mysql
i am a java programmer but have not done any database
stuff. i assume that mysql can be a good db to start
with java database programming ie jdbc stuff.
would you also say that mysql would be a good db to
start and learn with jdbc ? can some one let me
I wrote:
> Actually that doesn't make sense. I was thinking of the case where
> there's a left join involved. In your case, it should just be this:
>
>SELECT DISTINCT Data1
>FROM table_name
>WHERE Data3 = 1 AND Data2 <> 141;
Ignore that correction. It seems that what you want is
The mysql datetime will have to be
'1999-03-03 12:00:00'
or
1999030312
Maurizio Danilo wrote:
>Hi,
>
>I have to import some data in Mysql from a Sybase bulk
>copy (bcp) text files, and I have some problems with
>"date" type format fields.
>
>The sybase db has datetime fields and in the
>d
Hi,
You can try something like this :
select (CASE WHEN Data2<>141 THEN Data1 END) from your_table where Data3=1
group by Data1;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Thanks for your reply, is it documented somewhere?
Randy
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 10:07 AM
Subject: Re: Transaction Question
> Randy,
> Sunday, August 18, 2002, 10:57:54 AM, you wrote:
Because I don't know what Data1 is, thats the result I want to find
> -Original Message-
> From: Mary Stickney [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 12:10 PM
> To: Luc Foisy; MYSQL-List (E-mail)
> Subject: RE: Query Question
>
>
>
> Why cant you filter on Data1?
>
That would filter out the records containing 141 before it did the group by
That would mean I could get a "group" that had 141 in it
> 4 3 141 1
> 9 3 142 1
> 103 143 1
So, here it would not event look at record 4, then it would return me a group that
I wrote:
> Maybe something like this?
>
> SELECT Data1
> FROM table_name
> WHERE Data3 = 1
> GROUP BY Data1
> HAVING SUM(Data2 = 141) = 0;
Actually that doesn't make sense. I was thinking of the case where
there's a left join involved. In your case, it should just be this:
SELE
On 19 Aug 2002, at 11:32, Luc Foisy wrote:
> IDData1 Data2 Data3
> 1 1 141 1
> 2 5 140 1
> 3 4 142 1
[snip]
> For my return I only want a single instance of "Data1", so it will
> most likely need be GROUP BY Data1
>
> I would like those records t
sql,query
While working with record level locking on innodb tables we noted some
behavior that has us a bit befuddled.
The problem, in its simple form, is that I have two processes accessing the
same table. Process A does the following:
begin;
select * from table1 for update limit 5;
Now proce
On Monday 19 August 2002 07:21 am, Nicolas Ivering wrote:
Several things spring to mind here...
1st of all when you use JDBC, you're coding to the JDBC interface, not to any
proprietary interface (IE, your application could just as well call a
PostgreSQL JDBC driver and it would not need to be
Why cant you filter on Data1?
I meant
select * from xxx
where data2 <> 141 and data3 = 1 and (data1 = 7 or data1 = 5
or data1 = 2 or data1 = 4)
groupby data1
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 10:51 AM
To: MYSQL-List (E-mail)
Hi,
I have to import some data in Mysql from a Sybase bulk
copy (bcp) text files, and I have some problems with
"date" type format fields.
The sybase db has datetime fields and in the
dump file the date format is like this:
"Mar 3 1999 12:00:00:000AM"
I have created a table with the same st
Chris,
Monday, August 19, 2002, 6:50:29 PM, you wrote:
CB> Is there any way I can do something like this other than
CB> create a little script to do it programatically?
CB> UPDATE interests_shipping_conditions_master SET
CB> interests_master_record_num = interests_master.record_num WHERE
CB> int
Antoine,
Monday, August 19, 2002, 3:57:50 PM, you wrote:
A> I have tried to upgrade from MySQL 3.23.51 to 4.0.2-alpha (both source
A> distribution, same environment, same compiler, same configuration file)
A> and I was puzzled to see that my application became 5 to 10 times slower.
A> Most queri
What have you tried?
What did you get?
Why is it not what you expected?
Luc Foisy wrote:
>Some ficticious data
>
>ID Data1 Data2 Data3
>1 1 141 1
>2 5 140 1
>3 4 142 1
>4 3 141 1
>5 2 142 1
>6 5 142
On Sunday 18 August 2002 04:17 pm, Rick Robinson wrote:
> Hi all,
> I'm testing using a HEAP table to maintain transient state in a high
> volume TP environment. So far, it looks promising, and I want to ask
> anyone about similar experiences and solicit some input.
>
> Some background:
> * I hav
I suppose I should have specified that I would not be able to filter by Data1
> -Original Message-
> From: Mary Stickney [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 11:52 AM
> To: Luc Foisy
> Subject: RE: Query Question
>
>
>
> select * from xxx
> where data2 <> 141 and
Is there any way I can do something like this other than
create a little script to do it programatically?
UPDATE interests_shipping_conditions_master SET
interests_master_record_num = interests_master.record_num WHERE
interests_shipping_conditions_master.interest_name = interests_master.interest_
Hi,
I tried using the mysqlbinlog from 3.23.52 MAX with no difference in the
output at all from 4.0.2
It seems that whatever happened truely caused the log files to become
"corrupted"
So my next question would be, is there a way to repair the log files? What
are the formating rules for the lo
Some ficticious data
ID Data1 Data2 Data3
1 1 141 1
2 5 140 1
3 4 142 1
4 3 141 1
5 2 142 1
6 5 142 1
7 7 140 1
8 2 143 1
9 3 142 1
10 3
Hi, folks!
I would apreciate your opinion on my question:
How to make a MyISAM table (or several tables) to be shared among different
databases served by one MySQL server on Unix (Solaris)? It is OK if this table
appears as a read/write table in one database only, other DBs access it
read-only.
In the last episode (Aug 19), Reid Sutherland (mysql) said:
> Dan Nelson wrote:
> > You cannot send signals to individual threads. Signals are
> > delivered to the process as a whole rather than to a thread. The
> > only way to kill a thread is from within the application itself.
> > Mysql prov
Excellent info... thanks... (a little late response, but there was no net access in
the woods... :P)
Thanks again!
---
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
RedHat Engineer - RHCE # 807302349405893
Cisco Certified - CCNA # CSCO10151622
[E
On 19 Aug 2002, at 9:36, Aleksandar Bradaric wrote:
> It's that OR that makes the mess. Try with:
>
> -> WHERE CompanyDetails.CompanySuspended='0' AND
> -> CompanyDNSZones.ZoneName='megalan.co.za' AND
> -> (CompanyDNSZones.ZoneServices LIKE '%HasMail%' OR
> -> CompanyD
Harald,
Friday, August 16, 2002, 5:46:20 PM, you wrote:
HF> In article <[EMAIL PROTECTED]>,
HF> Victoria Reznichenko <[EMAIL PROTECTED]> writes:
>> Harald,
>> Thursday, August 15, 2002, 4:02:44 PM, you wrote:
[skip]
HF>> According to the manual, LOAD_FILE returns NULL if the file is too
HF>> la
Matt,
Monday, August 19, 2002, 3:03:07 PM, you wrote:
MH> Does anyone know if there is there any work continuing to be done on MyCC or
MH> any other UI for MySQL? There are many things broken in MyCC and MySQL
MH> navigator, such as indexes and foreign keys. While I believe that it can be
MH> d
Randy,
Sunday, August 18, 2002, 10:57:54 AM, you wrote:
RJ> I am using innodb tables via mysql max
RJ> if i do a select * for update
RJ> and then do an update statement
RJ> will this unlock the record for another update or will it wait for me to do
RJ> a commit?
It will wait for COMMIT/RO
Jim,
Monday, August 19, 2002, 3:19:36 PM, you wrote:
JB> Following are two CREATE TABLE statements. The second one fails because of
JB> an error in the last line.
JB> Does anyone know why?
JB> STATEMENT #2
JB> CREATE TABLE IID_InventoryItemDesc(
JB> IID_ItemDescCD VARCHAR(1) NOT NULL,
JB> IID
Alex,
Monday, August 19, 2002, 3:38:07 PM, you wrote:
AM> I Have a problem with logining to MySQL with root. I am runnig Red Hat
AM> Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package,
AM> which I got with Red Hat Linux 7.3.
AM> So I read documentation an made as following:
how did you install them? rpm pkgs, source?
Scott Dix wrote:
> mySQL,
>
> How do I uninstall mySQL?
>
> Scott
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/
Change your query for:
select red,green,blue from colorchanger INNER JOIN
jobattributekit ON colorcode = value where
attributekit = "Color" and jobnumber =
"28200124RB4-001" and scenario="JN75K";
Also remember that MySQL does not allow sub-queries.
--- Amit Lonkar <[EMAIL PROTECTED]> wrote:
>
Hi,
If you are generating the id yourself a good strategy
is to use UUID that are "guaranteed" to be
"universally" unique. If you are developing
for the Microsoft platform, there is an API functions
that returns you a UUID and this number is guaranteed
to be unique.
If you are working in Java, y
Hi Sinisa,
> No, this is actually quite correct for Linux, as tested so far.
How would those functions know than which request is being processed?
In multithreaded case argument is the only way.
Don't rely on testing -- bug gets a "free ride" in this case on i386.
Even if it works -- it may very
Dan Nelson wrote:
>
> You cannot send signals to individual threads. Signals are delivered
> to the process as a whole rather than to a thread. The only way to
> kill a thread is from within the application itself. Mysql provides
> the "kill " command for this.
Thanks for your reply.
What co
Hi,
I have tried to upgrade from MySQL 3.23.51 to 4.0.2-alpha (both source
distribution, same environment, same compiler, same configuration file)
and I was puzzled to see that my application became 5 to 10 times slower.
Most queries in my application (at least the critical part) are write
quer
Hello,
I really hope that Red Hat hasn't changed the root default password to
something else.
Start mysqld with --skip-grant-tables parameter, then try your mysqladmin
command you were trying to execute. If it works then, your grant tables
are screwed up somehow.When you're running with --skip-g
I Have a problem with logining to MySQL with root. I am runnig Red Hat
Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package,
which I got with Red Hat Linux 7.3.
So I read documentation an made as following:
shell> mysql_install_db
I tryed thi one
> mysqladmin -u root drop te
sql,query
Following are two CREATE TABLE statements. The second one fails because of
an error in the last line.
Does anyone know why?
Jim Bailey
STATEMENT #1
CREATE TABLE IIM_InventoryItemMaster(
IIM_InventoryItemMaster_ID MEDIUMINT(8) NOT NULL,
IIM_ItemNm VARCHAR(64),
IIM_ItemDescCD VARCHAR(
First thing I would do is update your mysql. That version is very old and
probably does not support a lot of stuff you are looking for. After that I
would go and download the newest JDBC drivers from:
http://www.mysql.com/downloads/api-jdbc.html
-Nick
marco said:
> Hello everybody
> I'm just
Does anyone know if there is there any work continuing to be done on MyCC or
any other UI for MySQL? There are many things broken in MyCC and MySQL
navigator, such as indexes and foreign keys. While I believe that it can be
done with the command line, I would much rather do it with the GUI.
Mat
I'm not from an official source but I would imagine the reason for the
change of license is to be able to charge for a non-GPL version of the
driver. With that in mind it wouldn't make much sence if you could use
the driver with a non-GPL program without making the program GLP also
(and thus a
Hi:
Firstly, I'd like to congratulate both MySQL AB and
Mr. Mathews on making the JDBC driver an officialy
supported download.
I have a query though. Newer versions of the mm.mysql
driver (now called connector/j) will be released *not*
under the LGPL but under the GPL.
Now if I am using the my
David,
Tuesday, August 13, 2002, 4:48:20 PM, you wrote:
DB> I've just a tiny question.
DB> I used mysql 3.23.49 linux binary package but i've got some problems with
DB> it.
DB> I should upgrade quite shortly because 3.23.49 binary package is buggy
DB> ... ).
DB> We have load problems, memory eati
krzychu,
Saturday, August 17, 2002, 5:49:35 PM, you wrote:
k> I have a problem when I trying to start mysqld (as a root, under RH 7.2).
k> Allegedly I don't have a rights to run this program...
k> What I have to do to run mysqld without rebooting system?
You doesn't have permissions to run mysql
Dan,
Saturday, August 17, 2002, 7:55:53 PM, you wrote:
DT> I have a table where I have specified several columns which I have specified
DT> that NULL values are not allowed.
DT> I have created a PHP based create / update / delete page where users can
DT> update the table.
DT> I have an INSERT s
áÌÅËÓÁÎÄÒ,
Monday, August 19, 2002, 2:49:58 PM, you wrote:
áó> ___
áó> MySQL version 4.0.1-alpha on Win 2000 Server SP2 Rus
áó> ___
áó> # The MySQL server
áó> [mysqld]
áó> port=3306
áó> #socket=MySQL
áó> skip-lockin
Kai,
Sunday, August 18, 2002, 1:53:32 AM, you wrote:
KV> Just created a table with a column named client_nr that is a foreign key
KV> referencing to my Clients table:
KV> CREATE TABLE Contacts (
KV> contact_nrint not null auto_increment,
KV> first_namechar(30),
KV> last_namechar(30),
Massimo,
Monday, August 19, 2002, 10:40:50 AM, you wrote:
MP> As in your instruction on 4 jul 2002 23:51:13 I added the
MP> SET NO_FOREIGN_KEY_CHECKS=1;
^^^
Should be:
SET FOREIGN_KEY_CHECKS = 0
MP> after having installed 3.23.52 for WIN on my win2k syst
Aleksandr,
thank you for the bug report. Please upgrade to 4.0.2.
>From http://www.innodb.com/bugfixes.html:
February 10, 2002:
If one defines a non-latin1 character set as the default character set, then
definition of foreign key constraints may fail in an assertion failure in
dict0crea.c, rep
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Massimo Petrini" <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 12:52 PM
Subject: Re: new command in 3.23.52 - innodb database schema dump
> Massimo,
>
> it was changed to
>
> SET FOREIGN_KEY_CHECKS = 0;
>
> Pleas
On Fri, 16 Aug 2002, Frank Shute wrote:
> I'm using 3.23.51 and I wondered if the manual was available as
> separate pages of html in a tarball.
>
> The manual as shipped is a single page and as this machine's dog slow
> and takes an age to jump from one part of the manual to another,
> I though
It worked! Thank you, you just made my day.
/Nicolas
Mikhail Entaltsev wrote:
>Nicolas,
>
>
>
>
>>select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
>>from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
>>where c.PersonID = p.PersonID
>>
>>
Hi marco
In the administration page of coldfusion, usually something like:
http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm
go to your data sources and click the edit button. THen click the "show
advance settings" button. Make sure that the Allowed sql pr
Nicolas,
> select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
> from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
> where c.PersonID = p.PersonID
It won't work. Sorry.
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from
Thanks for your reply. Unfortunately that query will not select rows
where Answer.AccountID is NULL which is what I wanted.
/Nicolas
Mikhail Entaltsev wrote:
>Nicolas,
>
>select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
>from Answer a left join Account c on (a.AccountI
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
where c.PersonID = p.PersonID
Best regards,
Mikhail.
- Original Message -
From: "Nicolas Ivering" <[EMAIL PROTECTED]>
To: <[EMA
___
MySQL version 4.0.1-alpha on Win 2000 Server SP2 Rus
___
# mysql config file.
# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL
# Here is entries for some specifi
Hi, this is probably a simple query but I tried all I can think of without finding a
solution.
I have three tables,
CREATE TABLE Answer (
AnswerID INTEGER NOT NULL AUTO_INCREMENT,
QuestionID INTEGER NOT NULL,
Value DECIMAL(15,4) NOT NULL,
AccountID INTEGER,
PRIMARY KEY (AnswerID)
) T
Hello everybody
I'm just getting mad with coldfusion, installed on a redhat platform running
mysql 2.1.0
Well, the problem occures when I try to create a data source, because I
always get this ERROR MESSAGE:
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to conne
> As in your instruction on 4 jul 2002 23:51:13 I added the
>
> SET NO_FOREIGN_KEY_CHECKS=1;
>
> after having installed 3.23.52 for WIN on my win2k system in the first
line
> of my shema dump (obtained with MYSQLDUMP -opt);
>
> But wheh I lanch the command
> mysql database
> I received the fol
Hi,
-> WHERE CompanyDetails.CompanySuspended='0' AND
-> CompanyDNSZones.ZoneName='megalan.co.za' AND
-> CompanyDNSZones.ZoneServices LIKE '%HasMail%' OR
-> CompanyDNSZones.ZoneServices LIKE '%HasMailingList%';
> I explictly tell MySQL in my where clause to only return r
As in your instruction on 4 jul 2002 23:51:13 I added the
SET NO_FOREIGN_KEY_CHECKS=1;
after having installed 3.23.52 for WIN on my win2k system in the first line
of my shema dump (obtained with MYSQLDUMP -opt);
But wheh I lanch the command
mysql database http://www.mysql.com/manual.php (th
93 matches
Mail list logo
