Re: Select statement to get the difference

2003-10-01 Thread Lourdes Millán
Stefan Berger escribió: How to tell it in MySQL I have 2 tables and i want to find difference (the id exists in one table but in the other not) between them. With SELECT attachment_id from tbl_attachment, tbl_msg2atta where attachment_id = atta_id i receive all id wich are equals in both

Re: Update Date Problem with VB

2003-09-24 Thread Lourdes Millán
Hi, What is the table definition? Have you got a primary index? I work with date fields without problems in this way: Update table set Date_Field = '2003-08-01' Where Date_Field = '2003-01-19' Lourdes. Optik Bacik Scheibbs escribió: Hey! So this is my first time here... I am using myODBC

Re: performance problem switching from Win2000 to WinXP clients!!

2003-09-23 Thread Lourdes Millán
Angela Olmeijer escribió: Hi there! I encountered a performance problem when I switched from a Win2000 machine to a WinXP machine to access MySQL via a MS Access (XP) Front-end. Simple queries take 20 times more time to appear on screen. Here's a rundown of hard-/software. Windows 2000