Hi. I have this error message in MySQL using Create Index create index indice on products(productid(7))
Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa66cd-11.MYI' (Errcode: 13) The ProductID fields is text type Carlos >From: David Kramer <[EMAIL PROTECTED]> >To: 'Carlos Rovetto' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >Subject: RE: Using Inner Join in MySQL >Date: Fri, 12 Jul 2002 12:38:12 -0700 > >It depends on the size of the tables that you are joining together. Can >you >index any of the columns that you are joining? If you post the query that >you are trying to execute I might be able to help you more. > >DK > >-----Original Message----- >From: Carlos Rovetto [mailto:[EMAIL PROTECTED]] >Sent: Friday, July 12, 2002 12:32 PM >To: [EMAIL PROTECTED] >Subject: Using Inner Join in MySQL > > >Hi. I want know why the time of response is slowly when i make a Join >between two tables using sql query in MySQL. > >I don't have more experience in MySQL > >Carlos > > > > >_________________________________________________________________ >MSN. Más Útil cada Día. http://www.msn.es/intmap/ > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _________________________________________________________________ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php