I need to get total number of all rows in a table and also select some
rows from the same table. I know how to do this
using two queries, but was wondering if there is any way to do it in one
query (one trip to the database).
Thanks,
-Jalil
--
MySQL General Mailing List
For list archives:
* jalil
I need to get total number of all rows in a table and also select some
rows from the same table. I know how to do this
using two queries, but was wondering if there is any way to do it in one
query (one trip to the database).
From version 4 you can use the SQL_CALC_FOUND_ROWS option
Hello,
I have these two tables,
CREATE TABLE `items` (
`name` varchar(100) NOT NULL default '',
`img` varchar(50) NOT NULL default '',
`year` year(4) NOT NULL default '',
`item_id` smallint(5) unsigned NOT NULL auto_increment,
PRIMARY KEY (`item_id`)
) TYPE=MyISAM;
CREATE TABLE
SELECT * FROM t1,t2,t3 WHERE t1.img_id=t2.img_id AND
t2.caption_id=t3.caption_id
Adolfo
-Original Message-
From: mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 8:15 PM
To: [EMAIL PROTECTED]
Subject: Help w/ Join Query
Hello,
I working on a small my
Hello,
I working on a small my project to learn more about joins. I have three
tables here is what they look like
CREATE TABLE `album` (
`album_id` smallint(3) NOT NULL auto_increment,
`name` text NOT NULL,
`description` text NOT NULL,
`img_id` smallint(5) NOT NULL default '0',
PRIMARY KEY