Re: Migrate from one MySQL table format to another

. 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] To: [EMAIL PROTECTED] Sent: Monday, February 16

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 VACUUM on postgreSQL) and InnoDB On Thu, Oct 16

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

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

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 PROTECTED] To: [EMAIL PROTECTED

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

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]

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 mysqlcreate database DB1line 2 mysqlcreate

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 Rodrigues

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 9:53 AM Subject: a few questions

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

index question

| ++--+---+--+-+--+--+ -+ 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, Leonardo Rodrigues -- MySQL General

Question on select

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