RE: Visio Stencils
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 stencils? Does such a beast exist? Ben Wiechman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Database Synchronisation Methods
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 All, I am trying to figure out the best way to do database synchronisation. I have my database at the head office and the application runs, partly at remote/branch office. I am considering having a copy of the database there but how can I have it synchronise in real time so that the information is consistent when viewed from either side of the link at all times? Paul. o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~ o DISCLAIMER THE INFORMATION CONTAINED IN THIS COMMUNICATION IS CONFIDENTIAL AND MAY BE LEGALLY PRIVILEGED.IT IS INTENDED SOLELY FOR USE OF THE INDIVIDUAL OR ENTITY TO WHOM IT IS ADDRESSED AND OTHERS AUTHORIZED TO RECEIVE IT. IF YOU ARE NOT THE INTENDED RECIPIENT YOU ARE HEREBY NOTIFIED THAT ANY DISCLOSURE, COPYING, DISTRIBUTION OR TAKING ACTION IN RELIANCE OF THE CONTENTS OF THIS INFORMATION IS STRICTLY PROHIBITED AND MAY BE UNLAWFUL . NEW VISION PRINTING AND PUBLISHING LIMITED IS NEITHER LIABLE FOR THE PROPER, COMPLETE TRANSMISSION OF THE INFORMATION CONTAINED IN THIS COMMUNICATION, ANY DELAY IN ITS RECEIPT OR THAT THE MAIL IS VIRUS-FREE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: innodb transaction not works
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 mixed tables myisam and innodb. I know that innodb supports transactions. My server is running with default transaction-isolation=REPEATABLE READ Whenever our cron runs stats updation scripts. It locks whole table and make other sql statements which updates the table waits for long time. How can achieve isolation correctly make other statements proceed without waiting. And my script updates record by record not as bunch. should I use transactional statements like start transaction and commit to achieve ? thanks in advance. Saravanan Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to import oracle dump?
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 Subject: How to import oracle dump? Hello I have got one question. I need to convert oracle dump file and import it to MySQl server. I have found some utitlity OraDump-to-MySQL but it is not free and convert only 5 record from each table. Can somebody help me ? Thanks -- View this message in context: http://www.nabble.com/How-to-import-oracle-dump--tp16115624p16115624.htm l Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: how ti put several records of one mysql table in one row of html table?
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 organizations table with org_id, name, address,
city,... columns.
CREATE TABLE `organization` (
`organization_id` int(8) unsigned NOT NULL default '0',
`address_id` int(8) unsigned default NULL,
`full_name` varchar(255) default NULL,
`phone` varchar(255) NOT NULL default '',
`fax` varchar(10) default NULL,
`parent_org_id` int(8) default NULL,
`website` varchar(45) default NULL,
`country` varchar(45) default NULL,
PRIMARY KEY (`organization_id`)
) ENGINE=MyISAM
+-++-+++
+
| organization_id | address_id | full_name | phone | fax|
website|
+-++-+++
+
|8200 | 1 | 1520 | 212245 | 2122457730 |
http://www.abcinc.com |
+-++-+++
+
I have also custom_fields table
CREATE TABLE `custom_fields` (
`field_id` int(4) NOT NULL,
`field_display` varchar(100) character set latin1 NOT NULL,
`field_type` enum('text','date') character set latin1 NOT NULL default
'text',
`field_order` int(3) unsigned default NULL,
`choices` text character set latin1,
PRIMARY KEY (`field_id`)
) ENGINE=MyISAM
*** 1. row ***
field_id: 12
field_display: Start Date
field_type: date
field_order: 2
choices:
*** 2. row ***
field_id: 13
field_display: Cancel Date
field_type: date
field_order: 4
choices:
*** 3. row ***
field_id: 14
field_display: Membership Type
field_type: text
field_order: 6
choices: Large Member,Small Member,Associate Member,Individual
Member
*** 4. row ***
field_id: 15
field_display: Referred By
field_type: text
field_order: 8
choices:
and custom field values table
CREATE TABLE `custom_field_values` (
`organization_id` int(8) NOT NULL,
`field_id` int(4) NOT NULL,
`cust_field_value` varchar(255) default NULL,
PRIMARY KEY (`organization_id`,`field_id`)
) ENGINE=MyISAM
mysql select organization_id, field_id, cust_field_value from
dir_custom_field_values where instance_id=12 and organization_id=8200;
+-+--+--+
| organization_id | field_id | cust_field_value |
+-+--+--+
|8200 | 12 | 2005-04-01 |
|8200 | 14 | Small Member |
|8200 | 16 | 1-4 |
|8200 | 21 | Retail |
+-+--+--+
I have to make a list (on screen, as html table) of organizations with
custom fields as a part of the table, e.g.
Org. ID | Org. Name | Org. Address | ... | cust_field_1 | cust_field_2 |
cust_field_3 | ...
but I can't make a query to put several records from custom_field_values
for specific org_id in one row?
Example:
+-++-+++
++-+
-+
| organization_id | address_id | full_name | phone | fax|
website| start date | cancel date | membership type
|
+-++-+++
++-+
-+
|8200 | 1 | 1520 | 212245 | 2122457730 |
http://www.abcinc.com | 2005-04-01 | 2006-01-01 |Smal Member|
+-++-+++
++-+
-+
thanks for any help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL database synchronizing from 2 locations
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 the connectivity between the two servers is lost, replication will gracefully auto-recover. You will need to set up some heartbeat script to monitor the connectivity, and SMS/email you if it is lost, allowing you to check on it. Sincerely, Raj Mehrotra -Original Message- From: C K [mailto:[EMAIL PROTECTED] Sent: Thursday, August 02, 2007 2:08 PM To: mysql@lists.mysql.com Subject: MySQL database synchronizing from 2 locations Hello, My client has a mfg. unit at 65 Km from a city in India. He wants to connect to his corporate office in the city. Both offices will use same data and same ERP system. He is using Win 2K3 server and MySQL 5.0.17. Is it possible to make them synchronized at a particular or regular intervals? How? Please give details. Options I think - Replication (is it possible for Windows?) Cluster (Is it possible?) Manual Sync by using Navicat or any other tool (other tools please) Please help. Prior Thanks, CPK -- Keep your Environment clean and green. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migration from Oracle to MySQL
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: mysql@lists.mysql.com Subject: Migration from Oracle to MySQL Hi All: I am doing a study on the migration of databases from Oracle to MySQL. In this process, I gathered few points. Overall, I think arguments can be made in favor of MySQL in terms of performance, stability, ease of use, and cost. All of these things point to decreased TCO when using MySQL instead of Oracle. Some things unique to MySQL that Oracle does not offer include: - Storage engines, choices like InnoDB, MyISAM Cluster, give you specialized transactional, search/read optimized and highly available engines for storing your data - Fast connections - Easy replication - Overall ease of use Could you provide some more information about Oracle limitations, MySQL limitations, Oracle vs. MySQL etc? Thanks, Regards, Sri -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: database structure
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 number of records for each TagID. References ShapeElements. The number of table will remain fixed at four, no matter how many shapes you have. And your SQL statements will be generic, most of the times, regardless of the shape. Sincerely, Raj Mehrotra hccs - Experts in Healthcare Learning (516) 478-4100, x105 [EMAIL PROTECTED] -Original Message- From: Hiep Nguyen [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 8:53 AM To: mysql@lists.mysql.com Subject: database structure Hi all, i'm seeking for help/suggestion on how to create relationship for this scenario: I have one table (tag) with the following fields: tagid, location, weight, grade, heat, shape, diameter, length, width, height, ... (and many other fields) what i want to do is move the shape field into a different table, however, each shape will have different dimensions for sample: rod bar has diamter and length, but square/flat bar has width, height (thickness), and length. wire has only diameter. but i also don't want to create a huge table to hold all the possible fields in all shapes, so i'm thinking create a table per shape: round table (diameter, length) square table (width, height, length) i-beam table (flange height, flange thickness, web thickness) angle table (leg1, leg2, thickness) ... and so on. in turn, i have 2 tables: tag, shape + as many table as there are shapes my question is: is there a better to do this? how do i query with this structure? i'm a bit confuse on how to manipulate data if each shape have diffent fields??? Thank you for all your help (sorry for a long email) T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 2013 (Lost Connection to MySQL Server) On A Solaris 10 Box
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 PROTECTED]
RE: making varchar field to act like numeric field
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 to act like numeric field I am looking for any suggestions to this problem. I have a table with a varchar field. This field can hold textual or numeric data, but it is stored in a varchar field so the database sees it all as text. I need to be able to search and sort this field as if it were numeric. For example, here is some sample data 2.5 4 2 6 7 6.2 3.4 6 I need to be able query the table to get the rows within a certain range, for example, between 4 and 7: select * from table where field1=4 and field1=7 This doesn't work because the column is not a numeric data type. Is there anyway to dynamically cast the data to a numeric format so I can use MySQL's numeric sorting? I can't change the field's data type because it also needs to be able to hold textual data. Thank you for your help. -- Steve Musumeche CIO, Internet Retail Connection -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: making varchar field to act like numeric field
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@lists.mysql.com Subject: RE: making varchar field to act like numeric field 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 to act like numeric field I am looking for any suggestions to this problem. I have a table with a varchar field. This field can hold textual or numeric data, but it is stored in a varchar field so the database sees it all as text. I need to be able to search and sort this field as if it were numeric. For example, here is some sample data 2.5 4 2 6 7 6.2 3.4 6 I need to be able query the table to get the rows within a certain range, for example, between 4 and 7: select * from table where field1=4 and field1=7 This doesn't work because the column is not a numeric data type. Is there anyway to dynamically cast the data to a numeric format so I can use MySQL's numeric sorting? I can't change the field's data type because it also needs to be able to hold textual data. Thank you for your help. -- Steve Musumeche CIO, Internet Retail Connection -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transitioning from ms sql
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 the transition. Sincerely, Raj Mehrotra hccs - Experts in Healthcare Learning [EMAIL PROTECTED] -Original Message- From: Arjun Bhandari [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 12:11 AM To: mysql@lists.mysql.com Subject: transitioning from ms sql Hi, I have been using MS SQL for the last one year, however would not like to transition to mysql. At the first glance it looks very different from ms sql and the tools are also different. can someone tell me if there is any document which explains the equivalence and how i could port a lot of my queries, tables, views and stored procedures to my sql from ms sql. Best Regards, Arjun ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any unauthorized use of the information contained in this email or its attachments is prohibited. If this email is received in error, please contact the sender and delete the material from your computer systems. Do not use, copy, or disclose the contents of this email or any attachments. Abu Dhabi Investment Authority (ADIA) accepts no responsibility for the content of this email to the extent that the same consists of statements and opinions made which are the senders own and not made on behalf of ADIA. Nor does ADIA accept any liability for any errors or omissions in the content of this email caused by electronic and technical failures. Although ADIA has taken reasonable precautions to ensure that no viruses are present in this email, ADIA accepts no responsibility for any loss or damage arising from the use of this email or its attachments. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Looking for free MySQL Administrator
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 I'm looking for a MySQL administrator for 4.x/5.x that will allow me to Any suggestions? TIA http://www.webyog.com/ Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: RE: MSSQL to MySQL mapping
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 a.UserGroupID*=b.UserGroupID; Any ideas? What is the equivalent syntax for MySQL. Thank you John C From: John c [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: FW: RE: MSSQL to MySQL mapping Date: Mon, 22 Aug 2005 13:18:43 + I am trying to adjust sql_mode but with no success. I use MySQL Query Browser from a remote mashine, login as root and I run set global sql_mode='ansi'; Then I run MySQLCommand line client from the MySQL server and the sql_mode is unchanged. I also tried to set the sql_mode in the My.ini file but it does not seem to have any effect. We have a web application that connects to MySQL. The applicatio written to communicate to SQL Server and the MySQL default mode cannot interpret the sql queries. How do I set the sql_mode, with what tool, how do I ensure what sql mode is currently set? Thank you for your help John C From: Arjan Hulshoff [EMAIL PROTECTED] To: John c [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: RE: MSSQL to MySQL mapping Date: Thu, 11 Aug 2005 09:20:08 +0200 Have you adjusted your queries? MSSQL uses a different dialect (T-SQL), then MySQL uses. There are quite some difference, although some queries still might work. Arjan. -Original Message- From: John c [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 08:12 PM To: mysql@lists.mysql.com Subject: MSSQL to MySQL mapping We have a web based application running on IIS 5.0 using MS SQL Server 2000 as the DBMS; we use ODBC to connect to the DB. We migrated our DB to MySQL and used the MySQL ODBC driver. It appears that some of the SQL statements that are accepted by SQL Server 2000 are not accepted by MySQL. Is there a mapping from MSSQL to MySQL statements? Thank you John C. _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this message and any attachments. ASML is neither liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
