Yes sir, you are correct. Thank you for correcting me. In practice, a
NULL in a foreign key almost always means an orphan record. In most
applications the designer will want to use the NOT NULL constraint.
Bob Hall
A foreign key value can be null, if it suits the data application
. Is there anyway of doing this?
Please help?
[EMAIL PROTECTED]
No sir. The members of the SET have to be entered as constant values
in the column definition.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
--
PHP Database Mailing List (http
ppreciated.
Scott Mebberson
Sir, I can't offer suggestions without knowing what the subquery is.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
Sir, it would help to see the INSERT statement and the table definition.
Bob Hall
I sent this message to the "general" list yesterday, and have yet to get an
answer (except for that Spanish "Snow White" virus attempt from Peru).
I'm trying to download info from a table as
On Sun, 8 Apr 2001, Bob Hall wrote:
Doug,
You've posted your usual good sense, combined with one statement I
strongly disagree with.
One of
these products is a relational database management system. The other is a
quasi-SQL-like-front-end-to-systems-of-indexed-files
PostgreSQL to become the open source app that ate
Oracle. MySQL will never be capable of that, but I don't think it
needs to be. There will always be a niche for small, quirky apps that
have just enough functionality to get the job done and keep the
learning curve short and shallow.
Bob Hall
Kn
On Mon, 9 Apr 2001, Bob Hall wrote:
MySQL is providing an SQL frontend to a
bunch of tables and indices, that is it ... it is up to the programmer to
handle the "managing of data" part where it revolves around being
relational ...
I've developed database app
carts.custId = '$custId' AND items.itemId = carts.itemId
GROUP BY itemId;
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
MySQL list magic words: sql query database
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
online manual.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
MySQL list magic words: sql query database
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED
to see what has changed, especially
for SQL. But it covers the basics of SQL and performance better than
anything else. Almost all your beginning questions will be answered
there.
For a more advanced treatment of performance, Jeremy's book sounds
like the best bet, when it comes out.
Bob
return the
first slide. People who have tested GROUP BY statements say that the
value returned from columns with no aggregate function is somewhat
random.
Bob Hall
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
() for Max() to get the earliest visit.
Bob Hall
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
a seperate table for the array, with a foreign key that points
back to the record in the original table. That will make retrieving data
a lot easier; e.g. you can do a query with a join and
WHERE thisField = 'john'.
Bob Hall
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
13 matches
Mail list logo