deleting "dead" customers

Hello! I have two tables. One contains invoices, one contains customers. How do I delete customers that are not linked to any invoice. The relation is one to many (invoices --> customers). I can select them with: select customers.* from customers left join invoices on invoices.cust_id=customers

server changes my password

Hi! This is wierd: Whenever I restart mysql server it somehow changes the password for user tadej@localhost. The password for tadej@'%' remains unchanged and I have to copy the password to the localhost entry. I am running mysql 3.23.38-nt on windows 2000 advanced server. Anyone knows how to fix

setting a character set

I'm trying to use a charset different than latin1. I did this: I created a file - c:\my.cnf - and inserted the following text into it: [client] default-character-set=win1250 I restarted mysql server and I still have latin1. What am I doing wrong ? Thanks, Tadej P.S. For the filter: da

Re: MS Excel to MySQL upload macro?

At http://www.icarz.com/mysql/index.html you can download a VB API that you can also include in excell. It's an API that connects directly to mysql. The API (MyVbQL.dll) is free and comes with an example program in VB. Regards, Tadej - Original Message - From: "Matt Wagner" <[EMAIL PROT

Benchmarking

How do I benchmark 2 queries that return same results without having mysql read from cache? Example: if i run the first query it will take 2 seconds, when I run the query again, it takes 0.05 seconds. And What is the max. size of the index file that fits into 512M memmory, so that mysql doesn'

Re: Select results to new table?

INSERT INTO table_2 SELECT * FROM table_1 WHERE condition or CREATE TABLE table_2 SELECT * FROM table_1 WHERE condition if your table_2 is not yet created Regards, Tadej - Original Message - From: "Eldon Ziegler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 09, 2

Large tables

I have 3 tables that have all fieds the same (name, length, indexes...) The only difference is that data is stored by year(1999 in table1999, 2000 in table2000, 2001 in table2001) I don't want to merge them because each contains about 15,000,000 records and the index would'nt fit into memmory...

Re: Embedding MySQL in an application

You could be more specific: Try specifying your programming language and operating system at least. - Original Message - From: "Shawn P. Garbett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 09, 2001 2:43 PM Subject: Embedding MySQL in an application > I have been

Re: editor

You can try FreeMascon. It's a windows grafical UI client for MySQL. There you can find a query editor that even highlights syntax. And it's free. download at www.scibit.com HTH, Tadej - Original Message - From: "Naintara Jain" <[EMAIL PROTECTED]> To: "Stefan Hinz" <[EMAIL PROTECTED]>;

Re: Logging connections

uot;Werner Stuerenburg" <[EMAIL PROTECTED]> To: "Tadej Guzej" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 9:35 PM Subject: Re: Logging connections > You have timestamp fields in your table. When the user connects, > you inse

Logging connections

How would I log connections to MySQL server? I need the time user connects and the time user disconnects. Thanks, Tadej - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: perforamnce

ssage - From: "Kahled Al Sahmaa" <[EMAIL PROTECTED]> To: "Tadej Guzej" <[EMAIL PROTECTED]> Sent: Saturday, August 04, 2001 12:25 PM Subject: Re: perforamnce > Hello... > > that related to your select statement which you are use, if you have > field1, fiel

perforamnce

What is better: CREATE INDEX ix1(field1, field2, field3); or CREATE INDEX ix1(field1), ix2(field2), ix3(field3); I have a large table of some 30,000,000 records and am wondering which indexing gives better performance and why. How do I optimize search on this table - I'm using lots of OR st