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 I have
- 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.name from
- 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 a
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
connection
- 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
- 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.
I do mean Do you mean one column for each name, in which
- 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 this mean?
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
- 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
I also have
- 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 looks like:
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.html
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
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
the
- 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 product which
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