Re: What format for text fields?

2004-07-15 Thread Jeff Gannaway
This is the 2nd Hope this helps. God bless! -Jeff Gannaway ___ http://RadioU.com This Is Where Music Is Going - Listen Online! ___ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Finding the records in one table that are not in another table

2004-07-10 Thread Jeff Gannaway
for either ProductsNEW or ProductsOLD. The data comes from our distributor, and they don't have any field which would be unique from record to record. If a primary key is essential, I can pre-process the tables to create one. Thanks in advance for your help!!! -Jeff Gannaway

Is there an easy way to find duplicate records in a table?

2004-07-10 Thread Jeff Gannaway
are different. Thanks!! -Jeff Gannaway ___ http://RadioU.com This Is Where Music Is Going - Listen Online! ___ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Which records are not contained in 2 different tables?

2004-07-10 Thread Jeff Gannaway
compare 1 table to 1 table. How do I do this? -Jeff Gannaway ___ http://RadioU.com This Is Where Music Is Going - Listen Online! ___ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Need help with my LEFT JOIN query...

2004-07-10 Thread Jeff Gannaway
| +---+---++ Here's my Query SELECT a.ProductID FROM ImportLiebermansStep3Add a LEFT JOIN ProductsOLD b ON a.PUBLISHER=b.Vendor AND a.NUMBER=b.VIN WHERE b.ProductID IS NULL; But this query runs, and runs, and runs, and runs, and runs without ever giving results. What am I missing??? Thanks! -Jeff Gannaway

Copying a ddatabase from one server to another

2001-02-22 Thread Jeff Gannaway
| mysql --host=[IP Address of New Server] database -uUSERNAME -pPASSWORD and I received the following output: ERROR 1130: Host 'old.server.hostname.net' is not allowed to connect to this MySQL server Any tips??? Thanks, Jeff Gannaway

Suggestion For List Management

2001-02-22 Thread Jeff Gannaway
r to sort through your e-mails. Anyway, that's my 2 -Jeff Gannaway [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

Re: Copying a ddatabase from one server to another

2001-02-21 Thread Jeff Gannaway
Ahhh using mysql command instead of mysqldump command to import. It worked splendidly! Gracias, Jeff Gannaway At 07:21 PM 2/21/01 -0300, Fbio Ottolini wrote: I just importa data created by mysqldump using mysql -u username -p dbname table MySQL asks for my password and it's done. BR