Please help with query to show duplicate addresses... TIA!

I am trying to come up with a query that shows duplicate last names and the order numbers for each occurance of. I can get as far as determining the duplicates but my query result only outputs one order for each. Here is my current query, an example of the results and an example of the results I

Another newbie question - using OR in WHERE clauses

Is there a simpler way to write something like: SELECT * FROM tablename WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty' Clearly this does not work: WHERE columname = 'Bob' OR 'Mike' OR 'Betty' Thanks!

Visual/Wizard style software for creating complex queries/joins?

Greetings! Is anyone familiar with/can recommend any software capable of helping design complex (well for me anyway) queries/updates/inserts with joins? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Reset Auto-Incriment?

I realize that this might be problematic/devastating if you had an AI PK and did this, however in my case there is no problem as there is no related data in the database yet lol. My question is, how can I reset AI? For example I deleted several rows and now my AI starts with the AI number after

Variable names, colum names

Greetings! Is it common practice to name script variables/form data in say PHP to match the appropriate colums in the db tables? I can see how this makes sense, however in the little work I have done I preferred to do the opposite as it seems to be helpful to keep a distinction. Thanks! --

Best way to get value of autoincriment after inserting NULL?

Greetinsg. If I have a table like with a column being the PK for the table and being an Auto Increment value, what is the best way to return this value to my script? It is possible that additional rows may have been added during the small wait. Ie. Col 1 Col 2 Col 3

RE: Best way to get value of autoincriment after inserting NULL?

, December 15, 2003 12:56 PM To: Paul Fine Cc: [EMAIL PROTECTED] Subject: Re: Best way to get value of autoincriment after inserting NULL? On Mon, 15 Dec 2003, Paul Fine wrote: If I have a table like with a column being the PK for the table and being an Auto Increment value, what is the best way

Please analyze my project table design

Greetings, my hands on school project is a small real estate database. I am using MySQL 3.23 without InnoDB, but would like to migrate to 4.x w/InnoDB at some point. I would greatly appreciate any feedback on this design. These are the business rules: 1) 1 matter may have several vendors

Inserting data into table1 should insert data into table2's FK ???

Du If I have two tables with the first table containing a field which is FK of table 2, when I insert a value into this field, should it not automagically insert a value into that PK in the second table? Thanks! -- MySQL General Mailing List For list archives:

TINYINT(1) vs ENUM?

Normally for a column with 2 possible values, I would use TINYINT(1) and programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is the correct: way? Now how about using ENUM instead? Is there any difference in overhead? Thanks!

TINYINT(1) vs ENUM ?

Normally for a column with 2 possible values, I would use TINYINT(1) and programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is the “correct: way?   Now how about using ENUM instead? Is there any difference in overhead?   Thanks! -- MySQL General Mailing List For list

Migration to INODB?

First of all I would like to thank everyone who has helped with my past posts. I'm not sure what the correct etiquette is, to post a thanks to every poster? Anyway, my situation is this. The production server is currently running mysql 3.23. I do not want to migrate to 4.x right away, however I

Choosing between VARCHAR and TEXT

Can anyone tell me what is better to use for items such as names and addresses? I suspect VARCHAR(max anticipated length) but why? Is it because Text will pad? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

MySQL on Win32 vs Linux ?

Greetings. Can anyone comment on the stability of MySQL on Win32? Unfortunately I may have to use IIS for a project and am just wandering if I can expect the same sort of stability and performance using MySQL (and PHP) on a Windows Server. Thanks for any advice! -- MySQL General Mailing List

The correct way to deal with name_1, name_2, name_3

Greetings, I would be greatful for any advice on the correct way to do this. If I have something dynamic, for example customer names where usually there are 1 or 2 unique customer names but possibly say up to 10, what is the correct design? For example I could simply create a table with name_1,

RE: The correct way to deal with name_1, name_2, name_3

Fine; [EMAIL PROTECTED] Subject: Re: The correct way to deal with name_1, name_2, name_3 - Original Message - From: Paul Fine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 17, 2003 10:37 AM Subject: The correct way to deal with name_1, name_2, name_3 Greetings, I would

RE: MySQL 4 Built in SSL?

Fine Subject: RE: MySQL 4 Built in SSL? What I have done is load putty on my WIN2K box. Connect to the nix box - make sure authentication is correctly configured Launch mysql and work on it from the command line prompt -Original Message- From: Paul Fine [mailto:[EMAIL PROTECTED] Sent

MYSQLD Dump - Locks Database

Can anyone please tell me what if anything happens with database locking during the execution of a mysqldump? Ie. What happens to database transactions occurring while performing a dump? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Digest Again, PLEASE SOMEONE HELP?

Thanks. Well I can't figure out what the problem is, I keep getting single e-mails for each post :( even after unsubscribing and resubscribing with digest selected. -Original Message- From: Rob A. Brahier [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 7:44 AM To: Paul Fine

MySQL 4 Built in SSL?

Would anyone be kind enough to provide an example of using MySQL 4 with it's apparent built in SSL functionality to connect from a Win client to *Nix box? Am I correct in assuming that this new functionality means that I will not have to use stunnel or ssh tunneling? Thanks for any info! --

Digest Again, PLEASE SOMEONE HELP?

Unless I am misinformed, subscription to the DIGEST format of this list should cause all messages to come in one daily e-mail? Can someone else who is subscribed this way please at least let me know that this is at least the case for them? I continue to get every single post as an individual

Newbie - How to determine hardware requirements?

Greetings. Does anyone have any suggestions besides trial and error for determining how resource intensive my database is going to be? Is this just something the a developer just gets a feel for after developing a number of databases or are there some guidelines I can use? Thanks for any help!

MySQL List Digest ???

Greetings. I have posted a few times to no avail on this matter. Choosing to receive a message digest should send me the daily posts in a single e-mail instead of getting individual e-mails every time someone posts? I cannot get it to happen. I have cancelled my sub and re-sub'd choosing the

RE: MySQL List Digest ???

Thanks. I tried that awhile back to no avail. Am I correct that I should be receiving only a single large e-mail each day? Thanks! -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 1:22 PM To: Paul Fine Cc: [EMAIL PROTECTED] Subject: Re

Digest Problem?

I cannot seem to get this list as a digest :( I have unsubscribed and re-subscribed multiple times choosing the digest option to no avail. I keep receiving single e-mails. Thanks for any help! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: