Re: Populate values in an Excel sheet from MySQL

day with Yahoo! - make it your home page http://www.yahoo.com/r/hs How about this for a novel aproach... Use the CSV storage engine that MySQL provides in the source distribution? It is very easy to use, and there is no headaches. -- Partha Dutta -- MySQL General Mailing List For l

RE: Storing manually diggested Passwords with MD5

et (0.18 sec) Partha -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification > -Original Message- > From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 11, 2005 7:21 PM > To: mysql

RE: CHECK constraint

nOnly', 'DesignInstall', 'InstallOnly') WITH CHECK OPTION This will force or constraint the view to only accept inserts where the criteria specified in the WHERE clause matches. -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified

RE: InnnoDb - change innodb_buffer_pool_size ?

. Partha -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification > -Original Message- > From: Michael Gale [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 14, 2005 10:04 PM > To: mysql@lists.mysql.com > S

RE: Export from Access

I think that the best approach would be to use the MySQL Migration Toolkit. Why spend a lot of time writing a tool when something already exists, and it works with Microsoft Access? http://www.mysql.com/products/migration-toolkit/ -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA

RE: auto_increment trouble (not the usual check || alter table solution, though)

have you DROPPED & re-created the table? -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification > -Original Message- > From: Ricardo Oliveira [mailto:[EMAIL PROTECTED] > Sent: Monday, May 16, 2005 5

RE: innodb buffer pool size question

The buffer pool size value is in 16K pages (from SHOW INNODB STATUS output) -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification > -Original Message- > From: Sergei Skarupo [mailto:[EMAIL PROTECTED] > Sen

RE: SLOW SLOW query - please help!

Brian, What is the output of the following: EXPLAIN select * from terms where term like 'Britney Spears' limit 1; Running this statement will produce info on what index path is being used in the query. Also, can you use "=" instead of "like" in your query? P

RE: UPDATE Query

, 22)) WHERE Insertion_ID = 190716; -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification > -Original Message- > From: shaun thornburgh [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 12, 2005 9:47 AM > To: my

RE: stopped while creating index.

) -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification > -Original Message- > From: Tom [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 12, 2005 5:12 AM > To: mysql@lists.mysql.com > Subject: stopped while

RE: How to put tables on a different drive???

When you create the tables, you can specify the DATA DIRECTORY and INDEX DIRECTORY clause while creating the table to specify different paths. Not sure if it works on Windows though. Should be a simple enough test -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you

RE: Foreign Key Restriction

You can turn off foreign key restrictions within your session: SET SESSION foreign_key_checks = 0; Then later, turn them back on using SET SESSION foreign_key_checks = 1; -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com

Re: how to check if keys disabled?

You can use the mysqlshow command to list all disabled keys: e.g.: mysqlshow -k world foo When the indexes are displayed the word "disabled" will be in the comment field -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www

Using a hardware load balancer in from of MySQL

the database server would go the mysql server 1. If server1 fails, the load balancer should send all connections to server 2, etc. Thanks for any insight on any implementation gotchas. Partha Dutta Bloomberg, L.P. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql