RE: Visio Stencils

2008-05-02 Thread Rajesh Mehrotra
Google: http://www.google.com/search?hl=enq=MySQL+Visio+stencilsbtnG=Google+Se arch -Raj. -Original Message- From: Ben Wiechman [mailto:[EMAIL PROTECTED] Sent: Friday, May 02, 2008 12:39 PM To: mysql@lists.mysql.com Subject: Visio Stencils Does anyone have a set of MySQL Visio

RE: Database Synchronisation Methods

2008-04-08 Thread Rajesh Mehrotra
Hi Paul, You need to set up replication. Check http://dev.mysql.com/doc/refman/5.0/en/replication.html -Raj. -Original Message- From: Paul Ikanza [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 08, 2008 1:05 PM To: 'mysql@lists.mysql.com' Subject: Database Synchronisation Methods Hi

RE: innodb transaction not works

2008-03-21 Thread Rajesh Mehrotra
Hi Saravanan, Please check http://forums.mysql.com/read.php?97,18003,18003 -Raj. -Original Message- From: Saravanan [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2008 1:59 PM To: mysql@lists.mysql.com Subject: innodb transaction not works Hi lists, We are running database with

RE: How to import oracle dump?

2008-03-18 Thread Rajesh Mehrotra
Have you tried the MySQL Migration Toolkit? Check http://www.mysql.com/products/tools/migration-toolkit/ Raj Mehrotra HCCS - Experts in Healthcare Learning -Original Message- From: Metalpalo [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 3:25 AM To: mysql@lists.mysql.com

RE: how ti put several records of one mysql table in one row of html table?

2007-10-16 Thread Rajesh Mehrotra
Hi, I think GROUP_CONCAT will do it. -Raj. -Original Message- From: afan pasalic [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 11:49 AM To: mysql@lists.mysql.com Subject: how ti put several records of one mysql table in one row of html table? hi, I have standard

RE: MySQL database synchronizing from 2 locations

2007-08-02 Thread Rajesh Mehrotra
Hi, Set up two-way replication between Corporate and Manufacturing. As long as a live network connection is available between the two sites, replication will carry on. Make sure that all your hardware is able to handle the peak I/O loads, in order to keep replication humming along seamlessly. If

RE: Migration from Oracle to MySQL

2007-07-26 Thread Rajesh Mehrotra
Check out http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html Raj Mehrotra hccs - Experts in Healthcare Learning [EMAIL PROTECTED] -Original Message- From: Tangirala, Srikalyan [mailto:[EMAIL PROTECTED] Sent: Thursday, July 26, 2007 11:11 AM To: cluster Cc:

RE: database structure

2007-07-02 Thread Rajesh Mehrotra
Hi, You can do this in four tables: 1. Tag 2. Shape (with an additional field, let us call it X, describing how many data elements each shape has) 3. ShapeElements : one record describing each data element (length, width etc.) for each shape. Record count for each shape: X 4. Data Table : X

Error 2013 (Lost Connection to MySQL Server) On A Solaris 10 Box

2007-06-12 Thread Rajesh Mehrotra
Hi, We copied over a test copy of a multi-GB database to a new Sun V440 box running Solaris 10 (64-bit) with a 64-bit MySQL install. When trying to connect to the database, we consistently get Error 2013. Any pointers? TIA. Sincerely, Raj Mehrotra hccs [EMAIL PROTECTED] mailto:[EMAIL

RE: making varchar field to act like numeric field

2006-09-28 Thread Rajesh Mehrotra
Hi Steve, Try select * from table where field1=4% and field1=7% instead. Sincerely, Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 11:24 PM To: mysql@lists.mysql.com Subject: making varchar field

RE: making varchar field to act like numeric field

2006-09-28 Thread Rajesh Mehrotra
Hi Steve, Correction: Use: select * from table where field1 like '4%' or like '5%' or like '6%' or field1 like '7%'; Sincerely, Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: Rajesh Mehrotra Sent: Thursday, September 28, 2006 11:42 AM To: '[EMAIL PROTECTED]'; mysql

RE: transitioning from ms sql

2006-09-27 Thread Rajesh Mehrotra
Hi Arjun, Check out the MySQL Migration Toolkit and some other tools available at http://www.mysql.com/products/tools/migration-toolkit/ and http://dev.mysql.com/downloads/gui-tools/5.0.html. Do a test migration and some testing on the migrated dataset, and you can then probably set up a plan for

RE: Looking for free MySQL Administrator

2006-05-23 Thread Rajesh Mehrotra
Check out http://www.mysql.com/products/tools/ for some good stuff... Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: Rithish Saralaya [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 1:21 PM To: mysql@lists.mysql.com Subject: RE: Looking for free MySQL Administrator

RE: RE: MSSQL to MySQL mapping

2005-08-22 Thread Rajesh Mehrotra
User % instead of * -Original Message- From: John c [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 9:48 AM To: mysql@lists.mysql.com Subject: FW: RE: MSSQL to MySQL mapping Also mysql complaints when I use the *= syntax: select a.userID from USers a, UserGroups b where