Optimizing table (so-called VACUUM on postgreSQL) and InnoDB

commands similar to VACUUM? What´s the difference? How can I run on InnoDB? Very thanks for any light... Leonardo Rodrigues -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help: SQL support error

Hello, I runned this command... optimize table table_name .. and got a result: "The handler for the table doesn´t support optimize". The table is InnoDB type. Do you know how can I run it? Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Re: Optimizing table (so-called VACUUM on postgreSQL) and InnoDB

Thanks Jeremy, I´ll try this. Leo - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Leonardo Rodrigues" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 5:23 AM Subject: Re: Optimizing table (so-called V

Re: Migrate from one MySQL table format to another

ones. If you're changing to a new version of the same software, there must be some 'upgrade' script available which will do that for you automatically. Sincerily, Leonardo Rodrigues - Original Message - From: "Eric Wagar" <[EMAIL PROTECTED]>

index question

L | 9216 | Using where; Using filesort | ++--+---+--+-+--+--+ -+ 1 row in set (0.00 sec) rows=9216, exactly all rows in the table Question: is there a way of creating an index for helping that kind of query ? I've tried creating index on horario, but it doesnt helped. Sincerily,

Re: MAX in a SubSelect

MySQL 4.0 (the current stable brench) does not support subqueries. This feature is present in the beta brench of MySQL, v4.1. http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Subqueries Sincerily, Leonardo Rodrigues - Original Message

Re: a few questions regarding MySQL rights

://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Secure_connections Sincerily, Leonardo Rodrigues - Original Message - From: "Jon Miller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 13, 2003

Re: newbie Q: create a table in a database

You can create a table in any database without 'changing' to that database, via USE or logging again. You can make create table database.tablename (tabledefinition); > > >c:\mysql\bin\mysql line 1 > mysql>create database DB1line 2 mysql>cre

Re: newbie Q: create a table in a database

. update database.tablename delete from database.tablename ... drop table database.tablename .. I'm not a MySQL expert, but I think almost all places that a tablename is required, database.tablename can be used . Sincerily, Leonardo Rodr

Re: might be a cilly question to u -execuse me.

PHA stages and is strongly NOT recommended for production servers. http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Subqueries Sincerily, Leonardo Rodrigues - Original Message - From: "Manoj Kumar Neelapareddy" <[EMAIL

Question on select

STARTING with a-z lowercase Hope hearing from you soon, Leonardo Rodrigues Persocom Network