DISTINCT AND NON DISTINCT #2
Hi All, I've been reading up on how to do joins on the mysql site. Is there not an inverse function for DISTINCT, so that I can pull out duplicate data as opposed to DISTINCT data...or will I have to get this information by using joins? Thanks very much for your help. Anna
DISTINCT AND NON DISTINCT
Hi All, I've been reading up on how to do joins on the mysql site. Is there not an inverse function for DISTINCT, so that I can pull out duplicate data as opposed to DISTINCT data...or will I have to get this information by using joins? Thanks very much for your help. Anna
table locking and priorities
Hi All, Can anyone help me... My registration form looks up the last username in the members table (select distinct username from members order by uid desc limit 1), and increments this username (e.g. from abc2 abc3) which will be used as the username for the next user to sign up... the problem occurs when in the time it takes to do an insert, several selects can take place - so i have the case where there are users with the same username (which is not very good at all) Can I force the selects to lock, whilst the insert is taking place? Has anyone got any ideas on how to get aorund this ? Please write back soon! Anna
Re: where do i get an authcode from ? - PLEASE GET ME UNSUBSCRIBED OFF THIS LIST....
nothing at all i'm afraid.. i think this requires a little shouting ... PLEASE GET ME UNSUBSCRIBED OFF THIS LIST thanks anna - Original Message - From: "Brian McDonough" [EMAIL PROTECTED] To: "anna soobrattee" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 10:42 PM Subject: Re: where do i get an authcode from ? I am having trouble too! The AutoResponder/SubScriber seems to be not working Did you hear anything positive on how to unsubscribe??? 120 emails per day while Traveling on Business is Tooo Much At 03:12 PM 3/21/01 -0000, anna soobrattee wrote: please tell how to get an auth code - i want to unsubscribe but i can't without an authcode. emailing the unsubscribe address doesn't work...i've been trying for weeks! thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
http://lists.mysql.com/php/unsubscribe.php
I can't unsubscribe either - I do not receive an auth code from this page http://lists.mysql.com/php/unsubscribe.php after I've entered my email address, so I cannot unsubscribe myself. If someone can fix this page, then perhaps, people will stop sending "unsubscribe me" emails to this list... anna - Original Message - From: "Phillip Vamplew" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: "Arne Claassen" [EMAIL PROTECTED]; "Heikki Tuuri" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 26, 2001 11:48 AM Subject: RE: Signal 11 on Innobase table range queries Please unsubscribe me from the list. -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 10:35 AM To: [EMAIL PROTECTED] Cc: Arne Claassen; Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Signal 11 on Innobase table range queries Hi! "Jeremy" == Jeremy D Zawodny [EMAIL PROTECTED] writes: Jeremy On Sun, Mar 25, 2001 at 09:52:22PM -0800, Arne Claassen wrote: I've got a reproducable signal 11 death in mysqld using Innobase tables and range queries (at least reproducable on my machine, Redhat 6.2, mysql 3.23.35). Here's how it manifests itself: Create a table with at least 32 columns. Then load a row or two into the table and try to do any query using a range (, , between, in) on the primary key and i get this: mysql select * from foo where id 1 limit 1; Jeremy [snip] Let me know if anyone can reproduce this, as it's quite the nuisance... Jeremy Yep. I've got a similar result here. Jeremy To reproduce you only need one row in the table: cut Thanks for the test case; We will fix this shortly and then release 3.23.36 that will contain the fix for this. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how do i store complex data in the most efficient way?
hi, i have a query that i hope someone can help me with.
i have a monitoring system that tracks the number of times that person clicks on a
particular adbanner on our site or in one of our newsletters. i member can choose
have a maximum of 16 interests selected.
so for example, i can say i'm interested in carbuying, the stockmarket and action
movies. at the moment i store the 16 interests as a bit bitfield,which gets decoded
on the server.
this system has worked very well for me, but now i have a few new requirements.
- the total number of possible interests that can be selected is now 150
- and i need store the users click rate and the number of times we have sent them a
newsletter relating to an interest or the number of times we have displayed an
adbanner related to their interest.
the long ineffient way would be
- to store 150 enum ("y", "n") fields to say that a user has selected a particular
interest
- then another 150 tinyint fields to store the response rate
- and another 150 tinyint fields to store the the count of times we have sent a
newsletter to them
this already results in 450 fields per record!
the best way i came up with was to store a number like "2_7" to represent 3 things,
the fact that a user has selected that interest, that the user has responded to 2 of
our 7 newsletters.
but this is still 150 fields per record.
we have about 250,000 members at the moment - this could get really out of hand very
quicky.
has anyone got any ideas on the best way to store this information ??
thanks for your help.
anna
large tables?
hi, i've been asked to design a for a new web-based system which stores lots of data on it's members. There are currently about 500,000 member records. the problem is that i have to store at least 248 pieces of information on each user. i've made the system as relational as possible so that for each user record, i am only storing integers, for the most part tinyints and smallints. Is there a limit on the number of fields per record. I can easily see this new system requiring 300 fields(columns). what are the consequences for making a table with so many columns. this table will be updated very frequently - will access time degrade severely even though i use mainly ints in this table? thanks for your help. anna
