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
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
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
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
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
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
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
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]
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 use
