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

Re: table locking and priorities

Hi, The username field is text and number so you I can't autoincrement a username like "abc003434" ... - Original Message - From: "Mohammad Shoja" <[EMAIL PROTECTED]> To: "anna soobrattee" <[EMAIL PROTECTED]> Sent: Wednesday, June 1

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

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

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]>; <[EMA

where do i get an authcode from ?

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

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

how many colums can i create before it becomes unusable?

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

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

mysqldump of one table?

hi i want to dump the contents of one table into a text file ... can you tell me what i've done wrong ? i tried : mysqldump --opt --tables studenttable > myfile.txt mysqldump --opt --databases [studenttable] > myfile.txt mysqldump --opt database [studenttable] > myfile.txt but all these resul