In general, is it more efficient to do many queries or one "large" query
with many joins?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: "Ville Mattila" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 4:07 AM
Subject: Join only the latest entry...
> Hello there,
>
> I have a table including information about my projects, the structure
> has each id and name. Then
- Original Message -
From: "Chris Boget" <[EMAIL PROTECTED]>
To: "Greg Jones" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 8:32 AM
Subject: Re: Query Help
> > Access. However, when I run it against MySQL I get an error.
> > select l.ltsysid,l.lientraknum, c
- Original Message -
From: "Andy (da man) Rosenblatt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 29, 2003 4:05 PM
Subject: HELP!
> hi
> I bought a book with your mySQL program and seemed to have installed it
worng and i cant stop it. I never set a user name or
- Original Message -
From: "Kelley Prebil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 9:33 PM
Subject: mysql: not found
> When I try to start the database with :
>
> mysql -h host -u user -p
>
> I get the response :
>
> mysql: not found
>
> What does thi
- Original Message -
From: "Paul Fine" <[EMAIL PROTECTED]>
To: "'Stephen Fromm'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 11:49 AM
Subject: RE: The correct way to deal with name_1, name_2, name_3
Thanks.
- Original Message -
From: "Paul Fine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 10:37 AM
Subject: The correct way to deal with name_1, name_2, name_3
> Greetings, I would be greatful for any advice on the correct way to do
this.
>
> If I have something
The connection identifier returned by mysql_connect() need not be passed to
calls to MySQL-related functions.
What is the "scope" of this claim?
In particular, if I open a connection and then call a function I wrote
myself, which then calls a MySQL related function, can I still omit the
connectio
- Original Message -
From: "Shravan Durvasula" <[EMAIL PROTECTED]>
To: "MySQL HELP" <[EMAIL PROTECTED]>
Sent: Tuesday, November 11, 2003 12:48 PM
Subject: Foreign Key
> Hi all:
>
> I have a table A(Id, Type). Primary Key is "Id"
> I have another table B(Id, State). Primary Key is "Id"
>
Is it OK to have actual newline/carriage return characters in string data?
E.g. consider the insert statement
INSERT into table t1 ( ) VALUES('Here is a newline:\nThere it was!');
Now consider the statement, typed as
INSERT into table t1 ( ) VALUES('Here is a newline:
There it was!');
Is the sec
- Original Message -
From: "Gary Huntress" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 17, 2003 12:14 PM
Subject: Multiple Self Joins and Left Joins ?
>
> I'm stumped by this query that I think will involve multiple self joins
and
> left joins.
>
> My data look
I got a bounced email with an attachment entitled macex.mex.scr, about 72.3
KB, which if IIRC is probably the Sobig.F virus. It appears to have been
sent to people on this list (even though the list wasn't in the "to:" line)
because the body of the email discussed MySQL.
Since Sobig.F forges the
Morten,
I'd like to help you with actual code, but I can't, because the version of
MySQL I use doesn't implement foreign key constraints.
In my own code (written in the C API), I plan on checking these constraints
myself. But I can't implement them in the tables themselves.
Best,
Steve Fromm
> Hello MySQL programmers,
>
> suppose we have an Enhanced ER diagram,
> with entities as classes/ subclasses connected through
> some IS-A relationship.
>
> How can this be Coded in MySQL Please?
>
> My prerequisites are the basic database texts from
>
> http://www-db.stanford.edu/~ullman/dscb.h
> hmm well sorry to be unclear i know this works but it would return more
> results than needed also i cant expect users to add this themselves, like
i
> would have to add the astrerix to every word in that case like i do to get
> all words ;\
I don't know the MySQL issues (I'm now using some FULL
It depends on what you want to know.
I used _Fundamentals of Database Systems_ (Elmasri and Navathe) when I took
a DB course. It was pretty good, though my impression is that there might
be a "classic" which is better.
The problem with the more MySQL-specific books is that you might not learn
th
- Original Message -
From: "Jon Haugsand" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 2:57 AM
Subject: Re: XML in MySQL
> * [EMAIL PROTECTED]
> > geez mysql is an open source product you cannot expect so much too soon
over
> > a very expensive commercial prod
It appears that if I try to insert an illegal value into an INT field, the
value is set to 0 instead of NULL, even though the field has NULL as a
default.
Is this documented behavior, and if so, what's the rationale?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
18 matches
Mail list logo
