FROM A LEFT JOIN B ON A.C=B.D WHERE B.D IS NULL
- Original Message -
From: Aaron Cannon [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, January 03, 2007 3:47 PM
Subject: select statement question
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
I need a select statement that will return all records whose C
: select statement question
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
I need a select statement
Aaron Cannon wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
SELECT c.value FROM c WHERE c.value NOT
I know this'll look scary :
select distinct book.bid, title, price, condition, author.name, edition from book left
join purchase on book.bid=purchase.bid left join student on 1 = 1 left join edition on
edition.bid = book.bid left join author on 1 = 1 left join author_book on 1 = 1 where
how do I get the values of foreign keys, that I have used within a
database
example
Main_DB
Main_Table
PK title_id3
FK manufacturer_id 5
FK category_id 4
Manufacturer_Table
PK manufacturer_id 5
description
***Greene***
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 4:18 PM
To: [EMAIL PROTECTED]
Subject: select statement question
how do I get the values of foreign keys, that I have used within a
database
example
Main_DB
)
- Original Message -
From: Jordan Morgan [EMAIL PROTECTED]
To: Nobody [EMAIL PROTECTED]
Cc: Diana Soares [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Friday, October 10, 2003 2:24 PM
Subject: Re: newbie select statement question
The date is stored as dates instead of timestamps. Yes
Look at:
if ($tenureid=3)
You're not comparing $tenureid with 3, you're assigning 3 to
$ternureid... If you want to compare both values, you must use the
operator == (and not only =).
On Fri, 2003-10-10 at 05:43, Jordan Morgan wrote:
Hi,
I have the following statement:
echo $tenureidP;
[EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:58 AM
Subject: Re: newbie select statement question
Look at:
if ($tenureid=3)
You're not comparing $tenureid with 3, you're assigning 3 to
$ternureid... If you want to compare both values, you must use the
operator
oh thanks! I guess that's why I'm a newbie.
Diana Soares wrote:
Look at:
if ($tenureid=3)
You're not comparing $tenureid with 3, you're assigning 3 to
$ternureid... If you want to compare both values, you must use the
operator == (and not only =).
On Fri, 2003-10-10 at 05:43, Jordan
Soares [EMAIL PROTECTED]
To: Jordan Morgan [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:58 AM
Subject: Re: newbie select statement question
Look at:
if ($tenureid=3)
You're not comparing $tenureid with 3, you're assigning 3 to
$ternureid... If you
Hi,
I have the following statement:
echo $tenureidP;
if ($tenureid=3)
{
// get faculty employment record - award date
$sql = select TD.Award_Date from TenureDescription TD LEFT JOIN
InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE
IE.FacultyMember='$fid';
$result =
Hi
I am a beginner in using mysql on Windows platform, and I have a question regarding
the use of SELECT * from TABLE_NAME statement within the mysql prompt.
I have a table of consisting of three columns POSTCODE, SUBURB, STATE where
the primary key is a composite of all three fields.
When I
You should write:
SELECT postcode FROM TABLE_NAME;
This will display the postcode from your table?
Jfernand
** sql **
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: November 20, 2002 16:12
To: [EMAIL PROTECTED]
Subject: SELECT Statement Question
Hi
I am
When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of
data and some of my data is not shown.
the garbled display is probably due to the results being wider then the
screen/terminal, and since the mysql client doesn't implement a horizontal
scrollbar like a gui/web mysql
thanks for the chuckle. we've all been beginners
and i still do dumb things with sql.
download corereader from http://corereader.com
it will let you click on the database objects to
build your queries. when you click on your table
name and your field name, it will return the data
to you
17 matches
Mail list logo