sunaram patir <[EMAIL PROTECTED]> wrote on 12/11/2005 12:10:52 AM:
> hi,
> what is the maximum no of tables supported in a mysql database?
>
That mostly depends on how large your hard drives are...
Except for the InnoDB engine (in default mode) and the NDB engine, all
other database engines
hi,
what is the maximum no of tables supported in a mysql database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hello there..
mysqldump has a option called --opt that dump your data in that way.
This is the default option for
new versions of mysqldump.
--opt is the equivalent of typing --add-drop-table,
add-locks, --create-options, --quick,
--extended-insert, --lock-tables, --set-charset and
When performing "mysqldump" is there any way to ensure that each
record gets an INSERT of it's own? I keep getting the following:
INSERT INTO 'mytable' (1,'test item'), (2,'test item'), (3,'test
item'), (4,'test item'), (5,'test item');
but I'd rather have
INSERT INTO 'mytabl
ali asghar torabi parizy wrote:
i have fedora core3 installed on my system.
which release of Mysql is compatible with fedora core3 ?
You should have no issue installing MySQL 5 from the download site,
while using Fedora Core 3 - http://dev.mysql.com/downloads/.
If however, you want to use t
There is at least one other option that JR didn't mention... at least some
versions of Excel have the menu option Data->Get External Data which
allows you to link through ODBC to run queries directly from within Excel.
I have barely used it and I have never tried it with MySQL so I can't
really
Thanks for you responses! This list has proven to be for useful to pick
pick the brains of other DBA's.
I think we are probably going to go the route of splitting the different
pieces of data into seperate columns, while keeping the original product_id,
since we have a lot of third party applicat
Here's the skinny -- YES and NO.
NO in that it won't export directly, YES in that you have to do a little leg
work in order for it to be done.
You have 3 options -- ODBC, Code and CSV.
ODBC -- Excel has the ability to use ODBC connections to the MySQL database.
Run your MySQL query with the H
Hello.
In my humble opinion, the design of the database should not depend
on operators which you're going to use in your queries. Yes, using
INTs in the IN clause (that means the the column type is INT as well,
isn't it?) should be a bit faster, because operations with strings are in
general
