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 list archives: http://lists.mysql.com/mysql
MySQL actually has an MD5() function:
mysql select MD5('password');
+--+
| MD5('password') |
+--+
| 5f4dcc3b5aa765d61d8327deb882cf99 |
+--+
1 row in set (0.18 sec)
Partha
--
Partha
', '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? www.mysql.com/certification
.
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
Subject: InnnoDb - change
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
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]
Sent: Monday
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:00 PM
To: mysql
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?
Partha
--
Partha Dutta, Senior
)
--
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 creating index
= 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: mysql@lists.mysql.com
Subject: UPDATE Query
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
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.mysql.com
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
to 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
14 matches
Mail list logo
