[ANN] [Qt ORM] QxOrm 1.4.5 and QxEntityEditor 1.2.3 released : support MongoDB database and code source now on GitHub

2018-09-06 Thread QxOrm contact
Hello, *QxOrm library 1.4.5* and *QxEntityEditor application 1.2.3* just released : https://www.qxorm.com/ *QxOrm library 1.4.5 changes log :* * - Support MongoDB database : QxOrm library becomes a C++/Qt Object Document Mapper ODM library !- For more details about MongoDB integration, see

ANN: Database Workbench 5.2 now includes PostgreSQL support

2016-09-08 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2 " This release includes support for PostgreSQL and adds several other features. Database Workbench 5 comes in multiple editions with

mysqld_multi doesn't support !include or !includedir directives

2016-07-07 Thread Molle, Thomas
Hi, I try to use !includedir directive with mysqld_multi for load other option files but nothing is loaded by mysql. In the default my.cnf, I have only the includedir directive for my configuration directory : !includedir /etc/my.cnf.d And in /etc/my.cnf.d/mysql3306.cnf I have : [mysqld_mul

[ANN] QxOrm 1.4.2 & QxEntityEditor 1.1.9 released : support JSON serialization

2016-04-06 Thread QxOrm contact
Hello, QxOrm 1.4.2 and QxEntityEditor 1.1.9 just released : http://www.qxorm.com/ QxOrm library 1.4.2 changes log : - Support JSON serialization : each C++ class registered in QxOrm context can be serialized/deserialized in JSON format (JSON feature requires Qt5) - For more details about JSON

ANN: DAC for MySQL 3.0.0 with RAD Studio 10 Seattle support is out!

2015-11-10 Thread Aleksander Andreev
. What’s new in v3.0.0: Support for RAD Studio 10 Seattle added, support for Android, MacOS & IOS target platforms introduced, several minor bugs fixed. Full changelog: [!] Package for RX10 Seattle added [!] Android target platform support added [!] iOS target platform support added [!] MacOS ta

ANN: DAC for MySQL 3.0.0-beta with RAD Studio 10 Seattle and mobile platforms support is out!

2015-09-16 Thread Aleksander Andreev
. What’s new in v3.0.0-beta: Support for RAD Studio 10 Seattle added, support for Android, MacOS & IOS target platforms introduced, several minor bugs fixed. Full changelog: [!] Package for RX10 Seattle added [!] Android target platform support added [!] iOS target platform support added [!] M

[ANNOUNCE] QxOrm 1.3.2 and QxEntityEditor 1.1.8 released, support C++11 types

2015-03-25 Thread QxOrm contact
Hello, *QxOrm 1.3.2* (C++/Qt ORM Object Relational Mapping database library) and *QxEntityEditor 1.1.8* (the graphic editor) just released (http://www.qxorm.com/) ! Changes in version *QxOrm 1.3.2*: *- Support C++11 types (need to set compilation options in QxOrm.pri config file to enable

[ANN] ODB C++ ORM 2.4.0 released, adds MySQL stored procedure support

2015-02-11 Thread Boris Kolpackov
new features in this release: * Support for bulk operations in Oracle and SQL Server. Bulk operations can be used to persist, update, or erase a range of objects using a single database statement execution which often translates to a significantly better performance. * Ability to join

LAMP Support

2014-10-15 Thread Don Wieland
Hey gang, I need a few hours of support from a LAMP developer to resolve a few issues via TeamViewer or GoToMeeting. Anyone who is interested, has the skills, and can offer this to me, please contact me PRIVATELY. Please include your support hourly rate. Thanks! Don Wieland d

DAC for MySQL 2.10.0 with support RAD Studio XE7 is out!

2014-09-22 Thread Aleksander Andreev
. What’s new in v2.10.0: Support for Delphi XE7 and C++ Builder XE7 introduced immediately! Full changelog: [!] Support for Delphi XE7 and C++ Builder XE7 introduced [-] "After TmySQLDataSet.SortBy the cursor changes position when using Data Controls" bug fixed You're welcome to d

Re: When will MySQL support the ANSI SQL MERGE command?

2014-09-19 Thread shawn l.green
Hello ccleve, On 9/19/2014 3:06 PM, ccleve wrote: I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? You appear to be looking for one of these com

When will MySQL support the ANSI SQL MERGE command?

2014-09-19 Thread ccleve
I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

mySQL Query support/assistance...

2014-02-11 Thread Don Wieland
Hi gang, I am looking for someone that I can pay a few hours to work with me on coming up with a few needed QUERIES for a large mysql database. The queries will span across tables, so I great knowledge of JOINS will most likely be necessary. We will work using SKYPE and GoToMeeting. Please con

[ANN] ODB C++ ORM 2.3.0 released, adds schema evolution support

2013-10-30 Thread Boris Kolpackov
new features in this release: * Support for database schema evolution, including automatic schema migration, immediate and gradual data migration, as well as soft object model changes (ability to work with multiple schema versions using the same C++ classes). For a quick showcase

RE: Adding language support to tables

2013-05-01 Thread Rick James
ou are using an new-enough NDB so that FOREIGN KEYs are implemented? > -Original Message- > From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] > Sent: Wednesday, May 01, 2013 5:53 AM > To: [MySQL] > Subject: Adding language support to tables > > Hi, > &

Re: Adding language support to tables

2013-05-01 Thread Neil Tompkins
s the PRIMARY KEY, and make it ASCII, not UTF8. > That would turn the 4-byte id into a 2-byte string. > > I gather you are using an new-enough NDB so that FOREIGN KEYs are > implemented? > > > -Original Message----- > > From: Neil Tompkins [mailto:neil.tompk...@googlemai

Adding language support to tables

2013-05-01 Thread Neil Tompkins
ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; Basically I'm wanting to add language support for each table to translate the name field in each instance. All other information will remain the same. Therefore

Re: Myisam won't support replication in an MySQL Cluster environment

2012-05-07 Thread Johan De Meersman
nagementspeak - and just as meaningless. I've seen your threads over the past couple of weeks, and have come to the same conclusion as Harald: you keep reposting the same inane question, all the while blatantly ignoring any and all relevant and informative replies you get from knowledgeable an

Re: Myisam won't support replication in an MySQL Cluster environment

2012-05-04 Thread Reindl Harald
flies in the face of > all rational behavior. > > Best regards, > > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Friday, May 04, 2012 3:23 AM > To: mysql@lists.mysql.com > Subject: Re: Myisam won't support replication

RE: Myisam won't support replication in an MySQL Cluster environment

2012-05-04 Thread Brown, Charles
ct: Re: Myisam won't support replication in an MySQL Cluster environment Am 04.05.2012 06:45, schrieb Brown: > Does anyone have idea or experienced in MySQL Cluster configured for > bi-directional replication. Please advise me if you have to use NDBcluster > engine in order t

Re: Myisam won't support replication in an MySQL Cluster environment

2012-05-04 Thread Reindl Harald
Am 04.05.2012 06:45, schrieb Brown: > Does anyone have idea or experienced in MySQL Cluster configured for > bi-directional replication. Please advise me if you have to use NDBcluster > engine in order to get replication between the data nodes. I'm using MYISAM > on several tables that will no

Myisam won't support replication in an MySQL Cluster environment

2012-05-03 Thread Brown, Charles
Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. ***

Myisam won't support replication in an MySQL Cluster environment

2012-05-03 Thread Brown, Charles
Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. ***

RE: Myisam won't support replication

2012-05-03 Thread Rick James
C > Subject: Re: Myisam won't support replication > > Charles, > > How do you know your replication isn't working? > > > > On Thu, May 3, 2012 at 9:50 PM, Brown, Charles wrote: > > > I noticed that my replication stopped working after migrating to >

Re: Myisam won't support replication

2012-05-03 Thread Andrew Moore
Charles, How do you know your replication isn't working? On Thu, May 3, 2012 at 9:50 PM, Brown, Charles wrote: > I noticed that my replication stopped working after migrating to MySQL > cluster. My current engine is myisam. Does anyone have an idea why repl > won't work. Do I have to use the

Myisam won't support replication

2012-05-03 Thread Brown, Charles
I noticed that my replication stopped working after migrating to MySQL cluster. My current engine is myisam. Does anyone have an idea why repl won't work. Do I have to use the ndbengine? This message is intended only for the use of the Addressee and

[ANN] ODB C++ ORM 2.0.0 released, adds support for C++11, polymorphism

2012-05-02 Thread Boris Kolpackov
. Major new features in this release: * Support for C++11 which adds integration with the new C++11 standard library components, including smart pointers and containers. Now you can use std::unique_ptr and std::shared_ptr as object pointers (their lazy versions are also provided). For

[ANN] ODB C++ ORM 1.7.0 adds support for optimistic concurrency

2011-12-07 Thread Boris Kolpackov
. Major new features in this release: * Support for optimistic concurrency using object versioning. * Support for SQL statement execution tracing. * Support for read-only/const data members. * Support for persistent classes without object ids. * Support for the Oracle database, including

Re: MySQL anemic GIS support

2011-10-07 Thread Michael Dykman
Somebody feel to jump in and contradict me here, but I have never had any love from the MySQL GIS stack. For the very few functions it does support, the performance has been abysmal and I generally find myself hacking together UDFs against columns of FLOAT and avoiding POINT altogether. - md

MySQL anemic GIS support

2011-10-07 Thread René Fournier
Anyone have any idea on if/when MySQL will get real GIS support? http://mysqldbnews.blogspot.com/2007/10/does-mysql-gis-make-grade.html …is what I'm referring to. Specifically, the factor that many functions are quietly replaced with MBRContains(). This makes it, for example

RE: Community Support better than Official Support? (was: Can I Develop using Community Edition and Deploy onto Enterprise Edition??)

2011-09-22 Thread Hal�sz S�ndor
;>>> 2011/09/22 13:08 -0400, Jerry Schwartz The user forum: it has many experienced users, some beta testers, and (because the product is used world-wide) a response time measured in hours. What it doesn't have is any presence from the company. Is n't that what companies nowadays w

RE: Community Support better than Official Support? (was: Can I Develop using Community Edition and Deploy onto Enterprise Edition??)

2011-09-22 Thread Jerry Schwartz
That's a great attitude. I always appreciate it when a support organization listens to users. I've been on both sides of the fence, and I always hated it when there //was// a fence. One thing I always favored, again as both a user and as a tech support professional, was a public lis

Community Support better than Official Support? (was: Can I Develop using Community Edition and Deploy onto Enterprise Edition??)

2011-09-22 Thread Shawn Green (MySQL)
This comment has me intrigued: On 9/21/2011 17:50, John Daisley wrote: Partitioning is available in the community edition and has been for a while now. Support is the only real difference and since Oracle took over the support available in the community is usually faster and better than you get

Re: does mysql support master to master replication

2011-08-03 Thread Rik Wasmus
> Any mysql instance can replicate from any other as long as binary logging > is enabled on the designated master. > Two instances can replicate from one another yes, but precautions must be > taken especially in the case of active-active configuration. Works perfectly indeed, to name the precauti

Re: does mysql support master to master replication

2011-08-03 Thread Claudio Nanni
g 3, 2011 at 1:10 AM, Angela liu wrote: > >> Hi, Folks: >> >> Does mysql support master to master replication, or master to slave >> replication on;y? I did not find the answer in MySQL manual, but found some >> discussion over the internet. >> >> Do

Re: does mysql support master to master replication

2011-08-02 Thread Jon Siebert
, Folks: > > Does mysql support master to master replication, or master to slave > replication on;y? I did not find the answer in MySQL manual, but found some > discussion over the internet. > > Does anybody know? if so, anybody has implemented master to master > replication in production? > > Thanks > > Angela >

Re: does mysql support master to master replication

2011-08-02 Thread Jon Siebert
MySQL, to my knowledge, supports only Master to Slave replication- as well as Master-slave-slave replication. http://dev.mysql.com/doc/refman/5.0/en/replication.html On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote: > Hi, Folks: > > Does mysql support master to master replication, or

Re: does mysql support master to master replication

2011-08-02 Thread Feng He
I have been using the M-M replication over years. But we only write to one node at any time. When this node is unusable, we write to another node. On Wed, Aug 3, 2011 at 1:10 PM, Angela liu wrote: > Hi, Folks: > > Does mysql support master to master replication, or master

does mysql support master to master replication

2011-08-02 Thread Angela liu
Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y?  I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know?  if so, anybody has implemented master to master replication in production? Thanks

Re: MySQL Enterprise support now at Oracle?

2011-03-10 Thread David Giragosian
On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely wrote: > Shawn Green works for Oracle and has been very helpful, and I am happy to > eat a little bit of shoe leather! > > Thanks Shawn! > > Jim > Check the archives for Shawn's posts. IMNSHO, they are unparalleled in clarity and depth and breadth of

Re: MySQL Enterprise support now at Oracle?

2011-03-10 Thread Jim McNeely
Shawn Green works for Oracle and has been very helpful, and I am happy to eat a little bit of shoe leather! Thanks Shawn! Jim On Mar 10, 2011, at 11:11 AM, Jim McNeely wrote: > Wow! We paid for MySQL enterprise plus enterprise support back in the good > old days before ORACLE bought My

MySQL Enterprise support now at Oracle?

2011-03-10 Thread Jim McNeely
Wow! We paid for MySQL enterprise plus enterprise support back in the good old days before ORACLE bought MySQL. I just sacrificed the sacred chicken and sprinkled the blood around my computer and went to sign up for support at support.oracle.com. After wading through the crappy Flash interface

Re: CR: add support of interactive transactions for webclients

2011-02-15 Thread Johan De Meersman
I can't speak for the MySQL people, but in my view your "workaround" is the correct way of implementing this. It is not the database's job to keep track of which user wants to keep what session open, and HTTP is stateless by design. Keeping transactions open for relatively long periods of time woul

CR: add support of interactive transactions for webclients

2011-02-14 Thread Herbert Huber
CR: add support of interactive transactions for webclients Hello, I dont know how to place an idea (CR) for mySQL. I try it that way. At the moment I am implementing an "easy-to-use" multiuser webclient for database usage. (phpMyAdmin in contrast is a very powerful tool for p

Re: ENGINE=ARCHIVE doesn't support INDEX!!??

2010-09-29 Thread Johan De Meersman
Correct. I assume the thinking behind it, is that you use that kind of table for huge amounts of inactive data, so it doesn't matter if your selects are a bit slower. Also, keep in mind that because it is a compressed file format, you will be scanning much more data per physical read than with a re

ENGINE=ARCHIVE doesn't support INDEX!!??

2010-09-29 Thread Daevid Vincent
I gotta ask... http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html#c11511 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

odbc connector 5.1 for windows unicode support

2010-02-04 Thread wim . delvaux
database said the returned string is NOT utf8 (i.e the binary data looks OK but the apps do not consider the binary as utf8). Does the connector support utf8 and if so why does say openoffice do not consider the data to be utf8 T -- MySQL General Mailing List For list archives: http

Re: ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

2009-12-08 Thread Martijn Tonies
I just would like to know which version of MySQL support the creation of database triggers with the same action and event for one table. I'm not sure there is any plan to implement support for multiple triggers with the same action and timing. I certainly hope so... If not, it seem

Re: ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

2009-12-08 Thread Jesper Wisborg Krogh
On Wed, 9 Dec 2009 16:39:33 Jeetendra Ranjan wrote: > Hi, > > I just would like to know which version of MySQL support the creation of > database triggers with the same action and event for one table. I'm not sure there is any plan to implement support for multiple triggers with

ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

2009-12-08 Thread Jeetendra Ranjan
Hi, I just would like to know which version of MySQL support the creation of database triggers with the same action and event for one table. Because if i create the the triggers as below i am getting error. First trigger (Succesfull) ++ CREATE TRIGGER CONSUMER_PROFILE_before_delete

Re: MySQL 5.4 Support for Mac OS X 10.6.x ?

2009-12-02 Thread Steve Pincaud
10.6.2, I have read the here under pages and my conclusion is that MySQL > currently does not support Mac OS X 10.6.x, so my question is: is there any > plan in the roadmap to support it ? and if so what would be the ETA for GA > and to get beta versions (the mysql-5.4.3-beta is supported o

MySQL 5.4 Support for Mac OS X 10.6.x ?

2009-11-29 Thread Steve Pincaud
Hello, I have a Mac Book Pro (64 bits x86) running with Snow Leopard aka Mac OS X 10.6.2, I have read the here under pages and my conclusion is that MySQL currently does not support Mac OS X 10.6.x, so my question is: is there any plan in the roadmap to support it ? and if so what would be the

does ado/myodbc not support blob data insert in vc6?

2009-08-10 Thread linux...@gmail.com
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk and GetChun

does ado/myodbc not support blob data insert in vc6?

2009-08-09 Thread linux...@gmail.com
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk and GetChun

Re: MySQL could not support bit storage?

2009-05-11 Thread Moon's Father
you might be better off using an integer and packing > many bits together into it. > -- David Yeung, MySQL Senior Support Engineer, Sun Gold Partner. My Blog:http://yueliangdao0608.cublog.cn Comanpy: http://www.actionsky.com

Re: MySQL could not support bit storage?

2009-05-11 Thread Baron Schwartz
On Sun, May 10, 2009 at 10:12 PM, Moon's Father wrote: >  Hi. >   MySQL only has one datatype called bit, but its smallest storage is one > byte. > How to save a bit on disk, but not a byte? In some cases, CHAR(0) NULL can actually use one bit on disk. You either store the empty string '', or yo

Re: MySQL could not support bit storage?

2009-05-10 Thread Peter Chacko
, May 11, 2009 at 7:42 AM, Moon's Father wrote: >  Hi. >   MySQL only has one datatype called bit, but its smallest storage is one > byte. > How to save a bit on disk, but not a byte? >  Any reply is appreciated. > -- > David Yeung, > MySQL Senior Support Engineer, >

Fwd: Does mysql support materialized views?

2009-04-20 Thread Olexandr Melnyk
Query cache stores "select" query together with its results. When the same query is sent again, result from the cache is returned. Whenever some table is modified, all cache entries referencing it are deleted. That happens even when modification doesn't affect cached rows, eg.: SELECT a FROM a_ta

Re: Does mysql support materialized views?

2009-04-20 Thread Olexandr Melnyk
On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun wrote: > Hi  Olexandr Melnyk > > That's to say, create the aggregation tables and update them by triggers? > I've noticed a "update view" in Mysql , can it work under the aggretate > operation? You're not looking for views, you need to use normal tables.

Re: Does mysql support materialized views?

2009-04-20 Thread Morten
On Apr 20, 2009, at 11:34 AM, Olexandr Melnyk wrote: No, you will have to "emulate" them using triggers or stored procedures. Or: 1. Create table "this_is_not_a_view" and use that as the materialized view 2. Build a new version in the background "this_is_not_a_view_pending" as per your

Re: Does mysql support materialized views?

2009-04-20 Thread Olexandr Melnyk
No, you will have to "emulate" them using triggers or stored procedures. On Mon, Apr 20, 2009 at 12:28 PM, Lin Chun wrote: > Hi > > I am now working with Mondrian , and need  tuning the database, as the > materialized views can improve the performance > and doesn't need to create the fact tables

Re: Does mysql support materialized views?

2009-04-20 Thread Krishna Chandra Prajapati
No On Mon, Apr 20, 2009 at 2:58 PM, Lin Chun wrote: > Hi > > I am now working with Mondrian , and need tuning the database, as the > materialized views can improve the performance > and doesn't need to create the fact tables > > > > cheers > -- > - > Lin Chun > -- Kr

Does mysql support materialized views?

2009-04-20 Thread Lin Chun
Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun

Re: When will MySQL support array datatype?

2009-03-10 Thread Andrew Garner
This is part of the SQL Standard. MySQL has a worklog open on it: http://forge.mysql.com/worklog/task.php?id=2081 On Sat, Feb 14, 2009 at 9:05 PM, Moon's Father wrote: > Hi. >   Who could tell me when the MySQL support array datatype? > Any reply will be appreciated. > > --

Re: When will MySQL support array datatype?

2009-03-10 Thread Darryle Steplight
; Claudio Nanni >> >> >> Moon's Father wrote: >> >>> Hi. >>>   Who could tell me when the MySQL support array datatype? >>> Any reply will be appreciated. >>> >>> >>> >> >> > > > -- > I'm a

Re: When will MySQL support array datatype?

2009-03-10 Thread Moon's Father
elational > DBMS. > > Cheers > Claudio Nanni > > > Moon's Father wrote: > >> Hi. >> Who could tell me when the MySQL support array datatype? >> Any reply will be appreciated. >> >> >> > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn

Re: When will MySQL support array datatype?

2009-02-15 Thread Claudio Nanni
Complex datatypes are not compatible with the concept of relational databases, probably you want to refer to an Object-Oriented DBMS or Object-Relational DBMS. Cheers Claudio Nanni Moon's Father wrote: Hi. Who could tell me when the MySQL support array datatype? Any reply wi

Re: When will MySQL support array datatype?

2009-02-15 Thread Martijn Tonies
Who could tell me when the MySQL support array datatype? Any reply will be appreciated. Given that you appreciate -any- reply ... I hope it never supports it. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server

[ANN]: MicroOLAP Database Designer for MySQL 1.9.8 has been released. Now with Russian language support!

2008-12-17 Thread Mikhail Oleynik
(experimental). Several minor bugs and improvements. >>> Full changelog: http://microolap.com/products/database/mysql-designer/news/ >>> Downloads: http://microolap.com/products/database/mysql-designer/download/ >>> Details about Russian language support: http://kitchen.micr

Additional language support for tracking server usage.

2008-10-13 Thread John Murtari
Folks, I work at a Web Hosting company and we were frustrated by our inability to account for user activity on a busy server. We could see gross spikes in activity by SHOW STATUS, but couldn't tell where they were coming from easily. We finally developed an extensive set of patches for MySQL and

Current state of CONNECT BY support in MySQL?

2008-10-08 Thread D. Dante Lorenso
Many people seem to ask this question periodically but I wanted the most recent answer... What's the current state of having support for CONNECT BY in MySQL? I'm using MySQL 5.0.45 on CentOS 5.2 and noticed in the documentation that I can't write my own recursive functio

RE: Time Zone Support

2008-08-27 Thread Martin Gainty
; To: mysql@lists.mysql.com > CC: [EMAIL PROTECTED] > Subject: Time Zone Support > Date: Tue, 26 Aug 2008 22:26:36 -0600 > > Hi, > > We need to add support for time zone to our existing PHP "Board Member" > Extranet applications. Could those of you with experience suppo

Time Zone Support

2008-08-26 Thread Keith Spiller
Hi, We need to add support for time zone to our existing PHP "Board Member" Extranet applications. Could those of you with experience supporting a time zone field in your MySQL data tables offer some advice? Would you use a single field? Would you use just an offset value? How

Re: mySQL support required

2008-06-09 Thread Juan Eduardo Moreno
Hi Kishore, Please see the following approach : http://dschneller.blogspot.com/2007/09/error-1033-hy000-on-innodb.html Regards, Juan On Mon, Jun 9, 2008 at 8:26 AM, <[EMAIL PROTECTED]> wrote: > > > > Hi , > > > > We are in Urgent need of support to r

mySQL support required

2008-06-09 Thread kishore.bhat
Hi , We are in Urgent need of support to recover from a database problem Details of our license product are as below License serial numbers is : 565076 Received on 19/Apr/006 The Problem detail is said below, We are not able to access the innodb data from the mysql Database

Re: MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint...

2008-02-14 Thread Peter M. Groen
On Thursday 14 February 2008 01:21:31 Jacob, Raymond A Jr wrote: > I apologize for asking this question. > I am somewhat confused by Microsoft's Licensing and I personally can not > justify to senior management why > MS SQL should be procured instead of procuring software more urgent > requirements

RE: [SPAM] - MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint... - Email found in subject

2008-02-13 Thread jmacaranas
http://blogs.ittoolbox.com/km/sharepoint/archives/sharepoint-and-mysql-2 2051 hmm.. but I think you might have problems getting support from sharepoint's vendor... IIRC they always push to use SQL server for this.. (we know the reason why.. :) ) >-Original Message- >

MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint...

2008-02-13 Thread Jacob, Raymond A Jr
I apologize for asking this question. I am somewhat confused by Microsoft's Licensing and I personally can not justify to senior management why MS SQL should be procured instead of procuring software more urgent requirements. I had the not so bright idea that maybe a MS SQL emulator or compatibili

Linq support

2008-01-31 Thread Sharique uddin Ahmed Farooqui
Hi, Did latest Mysql .net provider (5.1.4) support Linq? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are "the initiator".

RE: Client does not support authentication protocol requested by server

2007-10-10 Thread Reinhart Viane
t. At least that is what I think... Regards -Oorspronkelijk bericht- Van: John Berman [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 oktober 2007 23:47 Aan: mysql@lists.mysql.com Onderwerp: Client does not support authentication protocol requested by server Hi We have php 4.3.4 and mysql

Client does not support authentication protocol requested by server

2007-10-09 Thread John Berman
Hi We have php 4.3.4 and mysql 5 My test script produces this Client does not support authentication protocol requested by server http://www.jewishgen.org/cemetery/connect-test.php Research suggests that I can upgrade php or SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD ('xxx

Re: #1017 - Can't find file: './support/orderpc.frm' (errno: 13)

2007-09-14 Thread Haig Dedeyan
" and then stops right there. I went into "/var/lib/mysql/support" and the orderpc.frm is there along with its respective myd & myi files. Any idea on how to fix this? I'm using suse 10.1 with mysql 5.x. Also, when I run a simple search to list all items in that table

Re: #1017 - Can't find file: './support/orderpc.frm' (errno: 13)

2007-09-14 Thread Mike Zupan
> when I open the dbase in phpmyadmin.. > > I have a dbase with 14 tables. When I open it in phpmyadmin, it will > list all the tables until it reaches the table "orderpc" and then stops > right there. > > I went into "/var/lib/mysql/support" and the order

#1017 - Can't find file: './support/orderpc.frm' (errno: 13)

2007-09-14 Thread Haig Dedeyan
went into "/var/lib/mysql/support" and the orderpc.frm is there along with its respective myd & myi files. Any idea on how to fix this? I'm using suse 10.1 with mysql 5.x. Also, when I run a simple search to list all items in that table, I get nothing. Thanks Haig -- M

Fwd: [commercial] MySQL cluster setup and support

2007-08-13 Thread C K
-- Forwarded message -- From: C K <[EMAIL PROTECTED]> Date: Aug 13, 2007 11:37 AM Subject: [commercial] MySQL cluster setup and support To: [EMAIL PROTECTED] Dear all, we are a medium sized company in India having mfg. facilities about 65 kms. from Pune and Head Office in Pu

Why doesn't MySQL support gzip encode/decode functions.

2007-06-12 Thread Kevin Burton
Why doesn't mysql support gzip for COMPRESS/UNCOMPRESS and only zlib For network applications zlib is a lot less compatible than gzip. For example I could send gzip'd content directly from the database within a larger gzip'd stream. Kevin -- Founder/CEO Tailrank.co

Re: Does mysql support groups?

2007-05-30 Thread Peter Brawley
Chris, >Does Mysql support groups of users? It does not implement groups, but they are relatively easy to implement by linking a usergroups table to mysql.users. PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: Does mysql support groups?

2007-05-30 Thread Baron Schwartz
Hi Chris, Chris Hoover wrote: Does Mysql support groups of users? I am working on porting an application from Sybase to Mysql and it relies heavily on using groups to control access to the data. I am not seeing this mentioned in Mysql, but I might be overlooking something. So does it

Does mysql support groups?

2007-05-30 Thread Chris Hoover
Does Mysql support groups of users? I am working on porting an application from Sybase to Mysql and it relies heavily on using groups to control access to the data. I am not seeing this mentioned in Mysql, but I might be overlooking something. So does it support groups? Thanks, Chris

Re: Table compression with write (append) support

2007-05-28 Thread Yves Goergen
On 28.05.2007 18:34 CE(S)T, Kevin Hunter wrote: > At 5:45a -0400 on 28 May 2007, Yves Goergen wrote: >> Also, URLs sometimes contain things like >> session IDs. They're probably not of interest for my use but it's not >> always easy to detect them for removal. > > Really? Why wouldn't it be easy

Re: Table compression with write (append) support

2007-05-28 Thread Kevin Hunter
h the dictionary table. You'd have a slightly more bloated dictionary, but depending on the number of requests the site(s) get(s), the aggregation would more than make up for it. > I could also parse user agent > strings for easier evaluation, but this takes me the possibility to add &g

Re: Table compression with write (append) support

2007-05-28 Thread Baron Schwartz
Yves Goergen wrote: On 28.05.2007 09:06 CE(S)T, Kevin Hunter wrote: At 12:31a -0400 on 28 May 2007, Dan Nelson wrote: You want the ARCHIVE storage engine. http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html Hm, it doesn't support deleting rows and it cannot use indexe

Re: Table compression with write (append) support

2007-05-28 Thread Yves Goergen
On 28.05.2007 09:06 CE(S)T, Kevin Hunter wrote: > At 12:31a -0400 on 28 May 2007, Dan Nelson wrote: >> You want the ARCHIVE storage engine. >> >> http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html Hm, it doesn't support deleting rows and it cannot use in

Re: Table compression with write (append) support

2007-05-28 Thread Kevin Hunter
At 12:31a -0400 on 28 May 2007, Dan Nelson wrote: > In the last episode (May 27), Yves Goergen said: >> I'm thinking about using a MySQL table to store an Apache access log >> and do statistics on it. Currently all access log files are stored as >> files and compressed by day. Older log files are c

Re: Table compression with write (append) support

2007-05-27 Thread Dan Nelson
In the last episode (May 27), Yves Goergen said: > I'm thinking about using a MySQL table to store an Apache access log > and do statistics on it. Currently all access log files are stored as > files and compressed by day. Older log files are compressed by month, > with bzip2. This gives a very goo

Table compression with write (append) support

2007-05-27 Thread Yves Goergen
Hi, I'm thinking about using a MySQL table to store an Apache access log and do statistics on it. Currently all access log files are stored as files and compressed by day. Older log files are compressed by month, with bzip2. This gives a very good compression ratio, since there's a lot of repetiti

FK support on myISAM, Parallelization, pronunciation and all kinds of goodness...

2007-05-24 Thread Daevid Vincent
Whoa!? I was just reading this page (http://en.wikipedia.org/wiki/MySQL), and noticed a few things... " <http://en.wikipedia.org/wiki/Foreign_key> Foreign key support for all storage engines will likely be released with MySQL 5.2 (although it has been present since version 3.23.44

Re: Question on InnoDB support

2007-05-10 Thread Joerg Bruehe
Hi Waldo, all! [EMAIL PROTECTED] wrote: I'm making an assessment of MySQL possible official adoption in my company. A question I have is: with InnoDB codebase being owned by Oracle, is there any impact to its reliability and support? Any other issues? The developers of InnoDB have

Question on InnoDB support

2007-05-07 Thread waldo_tumanut
I'm making an assessment of MySQL possible official adoption in my company. A question I have is: with InnoDB codebase being owned by Oracle, is there any impact to its reliability and support? Any other issues? Waldo Tumanut Database An

MySQL IPv6 Support?

2007-04-16 Thread YuleMule
Hello, I have searched every corner of the internet for info on MySQL's IPv6 support, but have not found much information. I have a Linux box with an IPv6 address. It can be pinged from other machines (Linux and Windows) by its IPv6 address. However, I cannot get this command to work:

  1   2   3   4   5   6   7   8   9   10   >