Re: SELECT N records from each category

This one time, at band camp, "Perrin Harkins" <[EMAIL PROTECTED]> wrote: > In your case, you might be able to just cheat it with some > MySQL-specific LIMIT stuff: Thanks very much Perrin, this is most useful and I can take it from here. Kind regards Kevin -- MySQL General Mailing List For li

Re: SELECT N records from each category

This one time, at band camp, Peter Brawley <[EMAIL PROTECTED]> wrote: > Vague? Not in the slightest. General? Indeed, by design. I have read this before.. It uses a single table, I am using multiple tables. I am not selecting the TOP 10 or whatever. This example has no relationships where the sc

Re: SELECT N records from each category

This one time, at band camp, Peter Brawley <[EMAIL PROTECTED]> wrote: > See "Within-group quotas (Top N per group)" at > http://www.artfulsoftware.com/infotree/queries.php. Yes, I have seen that, very clever. How does it relate to my situation? Simply point to vague references is not helpful. K

SELECT N records from each category

I have 3 tables (schema below) with categories, questions and answers. Each category can of course have many questions in it. Also, the answers are multiple choice, so each question can have several related answers. I am trying to achieve 2 goals. 1) SELECT N questions and the related answers from

Re: Virtual Hosting Privileges

This one time, at band camp, "Grant Peel" <[EMAIL PROTECTED]> wrote: > What priveleges should I grant users at setup time? Perhaps look at the GRANT option GRANT SELECT, UPDATE, DELETE TO [EMAIL PROTECTED] IDENTIFIELD BY 'password'; you can use GRANT * or any combination of privileges you like.

Re: append on insert

This one time, at band camp, Baron Schwartz <[EMAIL PROTECTED]> wrote: > INSERT INTO item (`key`) > SELECT CONCAT('my-item', > (SELECT IF(COUNT(*) = 0, '', CONCAT('-', COUNT(*))) >FROM item WHERE `key` LIKE 'my-item%')); > Kevin, this design is not first normal form and will cause you

Re: append on insert

This one time, at band camp, "Martin Gainty" <[EMAIL PROTECTED]> wrote: > Kevin- > > Declare the column AUTO_INCREMENT > http://lists.mysql.com/mysql/161930 You can auto increment a non INT field? Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

append on insert

I have a table of item I wish to have the value of the item incremented if there is a duplicate. I looked at ON DUPLICATE KEY UPDATE but this modifies the exsisting value. If the item is my-item and this already exists, I need to make it my-item-2 or even my-item-123 where 123 is the key. Kind reg

Re: bookmarks and keywords

This one time, at band camp, Baron Schwartz <[EMAIL PROTECTED]> wrote: > > I wish to select all bookmark_title and bookmark_url that have the same > > keywords as > > the bookmark_url 'http://www.redhat.com. I do this.. > > mysql> SELECT child.bookmark_id, child.bookmark_title, child.bookmark_url

bookmarks and keywords

I have a table of bookmarks that have keyword searching. Fields +-+--+--+--+ | bookmark_id | bookmark_title | bookmark_url | bookmark_keyword | +-+--+-

Re: Can't fetch result twice in a PHP script

This one time, at band camp, "Mahmoud Badreddine" <[EMAIL PROTECTED]> wrote: > I have something like > while($someArr=mysql_fetch_row($result)) > { > ...some code. > } > > The first time I call mysql_fetch_row , the code inside the while loop gets > executed, but not the second time. What is the

Linking tables

Hi all, having a spot of bother with a 'keywords' table. I have a table of articles with an article_id and a table of categories with a category_id, all is well. These are linked via a article_link table so that an article can be a member of multiple categories. I then have a table of 'keywords' t

Re: Blob data

This one time, at band camp, Warren Young <[EMAIL PROTECTED]> wrote: Storing arbitrary data in a BLOB column is > tantamount to trying to turn the database into a file system. If you > want a file system, use a file system. What is a file system, if not a database? Kevin -- MySQL General M

Re: MySQL e-zine

This one time, at band camp, "Peter M. Groen" <[EMAIL PROTECTED]> wrote: > > Any thoughts? Any desires to contribute? > > Hi Keith, > > Great Idea! > I volunteer for the developer side (Mysql and C++) I have written for php|mag previously, I'll put my hand up for PHP/MySQL Kevin -- "Democr

Re: advice for blob tables?

This one time, at band camp, [EMAIL PROTECTED] wrote: > > I don't feel the implementation direction this article takes is good. It > uses single row binary storage, which anyone who has had to deal with > large files knows is a definate issue. According to your method of storing binary data in

Re: advice for blob tables?

This one time, at band camp, "Michael Higgins" <[EMAIL PROTECTED]> wrote: > So before I just jump in and go like I usually do, does anyone have any > quick advice, things to consider, links, must-RTFMs or the like to help a > newbie out? This tutorial deals with images and BLOBs. It should get

referal system

Hi gang, sorta newish to MySQL so please bear with me... I am putting together a system of referals for my photography company. The referal system works, like many others. A business refers customers to me, for which they recieve a referal fee when the customer pays a deposit. I can create a the

Re: query date ranges - step 2

This one time, at band camp, Kevin Waterson <[EMAIL PROTECTED]> wrote: > seasonDateFrom seasonDateTo seasonRateWeekly > 2004-06-02 00:00:002004-10-31 00:00:00 42.86 > 2004-01-01 00:00:002004-06-01 00:00:00 34.29 > > When I take a booki

query date ranges

ards Kevin -- __ (_ \ _) ) | / / _ ) / _ | / ___) / _ ) | | ( (/ / ( ( | |( (___ ( (/ / |_| \) \_||_| \____) \____) Kevin Waterson Port Macquarie, Australia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: bookings

rocedure? Kind regards Kevin -- __ (_ \ _) ) | / / _ ) / _ | / ___) / _ ) | | ( (/ / ( ( | |( (___ ( (/ / |_| \) \_||_| \____) \) Kevin Waterson Port Macquarie, Austr

Re: bookings

oups. Kind regards Kevin -- __ (_ \ _) ) | / / _ ) / _ | / ___) / _ ) | | ( (/ / ( ( | |( (___ ( (/ / |_| \____) \_||_| \____) \) Kevin Waterson Port Macquarie, Australia -- MySQL General Mailing List For list archives: http://lists.mysql

bookings

y recieved, Kevin -- __ (_ \ _) ) | / / _ ) / _ | / ___) / _ ) | | ( (/ / ( ( | |( (___ ( (/ / |_| \) \_||_| \____) \____) Kevin Waterson Port Macquarie, Australia -- MyS