Re: MySQL 5.0.51a and SHOW ENGINES
On Fri, Apr 11, 2008 at 08:54:26AM +0200, Martijn Tonies wrote: Hello Jim, On Thu, Apr 10, 2008 at 09:32:43AM +0200, Martijn Tonies wrote: It seems that SHOW ENGINES fails on MySQL 5.0.51a (community edition checked). Instead of returning the full data, the first two columns are cut off at 3 characters, while the comment column is cut off at 26 characters. sounds like you are using the wrong value for the length of a utf8 field, where the number of characters is being divided by the max character length. (10 / 3 = 3, 80 / 3 = 26) or it could be the server returning the wrong length. use mysql --column-type-info to see what it is returning. That doesn't work with 5.0 as far as I can tell. sorry, i think --column-type-info is new in 5.1. you can get the same effect using -T with 5.0, i believe. jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0.51a and SHOW ENGINES
On Thu, Apr 10, 2008 at 09:32:43AM +0200, Martijn Tonies wrote: It seems that SHOW ENGINES fails on MySQL 5.0.51a (community edition checked). Instead of returning the full data, the first two columns are cut off at 3 characters, while the comment column is cut off at 26 characters. sounds like you are using the wrong value for the length of a utf8 field, where the number of characters is being divided by the max character length. (10 / 3 = 3, 80 / 3 = 26) or it could be the server returning the wrong length. use mysql --column-type-info to see what it is returning. jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: union operator problems in MySQL v3.23?
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote: Notwithstanding end-of-life status, is there an issue in MySQL v3.23 r.e. the union operator? My installation returns a syntax error on any query containing the union operator, even with the sample queries provided in the documentation: mysql SELECT REPEAT('a',1) UNION SELECT REPEAT('b',10); ERROR 1064: syntax error near 'UNION SELECT REPEAT('b',10)' at line 1 Support for UNION was not added until 4.0. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ODBC 3.51.22 problem - please help
On Wed, Dec 12, 2007 at 05:11:43PM -0800, Ed Reed wrote: I've found a glaring problem with the latest ODBC connector. Data types have been changed and data is no longer being read correctly. That's not quite correct -- data types are now actually being read correctly. They were wrong before, even if it was what you expected. I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The following query produces different data types depending on the version of the ODBC driver. SELECT ConCat(21000,'-','a') In 3.51.19 it is a VarChar and in 3.51.22 it's a VarBinary. Concat is supposed to return a string. In C a byte array may be fine but in VB a string should be a VarChar. Is this a bug or is there a server or OBDC setting that can be changed to make sure that it always returns a VarChar CONCAT() derives its return types from its arguments. The key part from the CONCAT() documentation is: If all arguments are non-binary strings, the result is a non-binary string. If the arguments include any binary strings, the result is a binary string. A numeric argument is converted to its equivalent binary string form; if you want to avoid that, you can use an explicit type cast, as in this example: SELECT CONCAT(CAST(int_col AS CHAR), char_col); That earlier releases of the driver would return a non-binary string in your case was a bug. That a numeric argument is converted to a binary string is an unfortunate server feature. I hope it will get fixed in a future server release, but I'm not sure when that will be, and it will almost certainly not be in the 5.1 series. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Falcon and Foreign Key Constraints
On Thu, Sep 20, 2007 at 11:20:19AM +0200, Martijn Tonies wrote: I thought that Falcon supported FKs, but in my test, it doesn't? Can someone confirm this? The Falcon storage engine does not currently support foreign keys. (The underlying engine does have support for them, but this functionality is not exposed to the MySQL server.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb to be removed? and...
On Tue, Jul 24, 2007 at 11:48:38AM +0200, Christian Parpart wrote: so is it true, that innodb is to be removed? No, not in the forseeable future. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb to be removed? and...
On Tue, Jul 24, 2007 at 11:17:11AM -0400, Les Schaffer wrote: Jim Winstead wrote: No, not in the forseeable future. if you are going to use that kind of Orwellian newspeak, then expect the followup question to be, how far into the future does MySQL see? do you have a number in mind, like 1 year, 3 years, 3 months, 3 days? A couple of years. And that's not saying InnoDB will be removed in a couple of years. I mean InnoDB will almost certainly not be removed in the next couple of years, barring any unforeseen developments, and there is nothing implied there about it being removed after a couple of years, either. If you want stronger guarantees than that, contact our sales department. Sorry for being less than perfectly clear. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb to be removed? and...
On Tue, Jul 24, 2007 at 02:49:55PM -0500, mos wrote: Since you're here, maybe you can answer a question for me. Will Falcon eventually replace InnoDb? Or do you have another engine in mind? There is no effort underway to replace InnoDB. Last I heard, Oracle intends to keep developing InnoDB, and MySQL intends to keep distributing it as part of the main distribution. The MySQL storage engine interface is designed to allow alternatives, and as we're seeing with the growing number of storage engines (from MySQL and others in the community), there are a lot of different ways to skin the data-storage cat. Each storage engine brings with it different strengths and weaknesses that make it more or less suitable for different workloads. Robin Schumacher has written a series of articles on Falcon that explain some of its strengths and weaknesses, and I assume there will be more as Falcon gets closer to a stable release. (And of course, you should go ahead and download the Falcon development releases, try it out, and let us know about any problems you find.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query cache question when using HANDLER
On Wed, Jun 27, 2007 at 01:27:24PM +1200, Ian Collins wrote: Are HANDLER queries cached in the query cache? No, they are not. The query cache only caches the results of SELECT statements. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: why is `load data from master` obsolete?
On Thu, Jun 21, 2007 at 01:12:19PM +0200, Christian Parpart wrote: this statement indeed is a feature. but why has it been marked obsolete? it would be sooo easy instanciate master-slave replication. It's marked obsolete because it doesn't really work well (such as only supporting MyISAM), and will be replaced by the online backup support that is currently under development. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ODBC Drivers 3 and 5
On Tue, Jun 19, 2007 at 10:24:11AM -0400, [EMAIL PROTECTED] wrote: I have been looking online for an explanation of the differences between ODBC drivers 3 and 5. I'm sure it is someplace simple to find. Does anyone here know? Connector/ODBC 3.51 is an ODBC driver that supports only the ANSI interfaces, and Connector/ODBC 5.0 is a ground-up rewrite that supports the ODBC Unicode interfaces and some other features. 5.0 is still only a beta, while 3.51 is production-ready. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ODBC Drivers 3 and 5
On Tue, Jun 19, 2007 at 03:15:19PM -0400, [EMAIL PROTECTED] wrote: So I guess the same thing goes with the JDBC connectors? http://dev.mysql.com/downloads/connector/j/5.0.html For example.. If I'm using Coldfusion to do jdbc calls in version 5 will I have less functions on my ASP server that is using ODBC version 3? Should I be using the same version? No, Connector/J has always supported Unicode. There's no reason to stay with Connector/J 3.x because you're using Connector/ODBC 3.51. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fields seem to be mis-wired (for lack of a better term)
On Tue, Apr 24, 2007 at 10:03:58AM -0700, Chris W. Parker wrote: UPDATE `users` SET `name` = 'First Last' AND `email` = '[EMAIL PROTECTED]' AND `balance` = 0 AND `accrual` = 14400 AND `is_manager` = 1 AND `is_superadmin` = 1 AND `type` = 0 AND `manager_id` = 0 AND `modified` = NOW() WHERE `id` = 5 you can't use 'AND' to connect your updates, you need to use commas: UPDATE users SET name = 'First Last', email = '[EMAIL PROTECTED]', ... what you're doing now is setting your name column to a boolean expression. jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [LICENSING] why so hazy? Comparing to Samba.
On Thu, Feb 22, 2007 at 11:33:47PM -0600, mos wrote: That's just one guy's opinion. :) And quite misinformed, unfortunately. $595 is the per-server price for MySQL Enterprise, which includes support, the network monitoring and advisory service, and more. It is not the OEM pricing. You may notice that we don't publish OEM pricing, precisely because it is far too easy for someone to think they just need to multiply some base price times some theoretical number of units. If you are an ISV looking to license MySQL for distribution with your application, contact the MySQL sales team. They are happy to work with you to fit find the pricing model that makes the most sense. (Or, of course, you can just open source your application.) And I hope we can now consider this horse to be sufficiently dead. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [LICENSING] why so hazy? Comparing to Samba.
On Thu, Feb 22, 2007 at 01:39:49PM -0900, software advocate wrote: This is exactly why someone needs to develop a non-gpl mysql drop in client for PHP. This would get around license costs, despite what MySQL AB has to say, this would be completely legal. Ask your local rep from the FSF. One could always reverse engineer the protocol like the Samba team. Also the fact is, an idea can NOT be copyrighted. You can read the source, take notes, or even make documentation to create your own client. In fact, MySQL AB has developed exactly such a thing. (Look for info on 'mysqlnd'.) This licensing comment in the internals documentation is old, and is supposed to be removed. Unfortunately, updating the internals documentation is not something that gets a lot of priority. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why release 5.0.23 instead of 5.0.24?
On Sat, Jul 29, 2006 at 08:35:41AM -0700, Abdullah Ibn Hamad Al-Marri wrote: Why MySQL 5.0.23 while it has serious bug? I thought you guys will release 5.0.24 instead. This is still the case. 5.0.23 will not be released, and 5.0.24 will be released as soon as it is ready. (I see that some 5.0.23 binaries are listed on the 5.0 download page -- this is a mistake.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.21 has been released
On Fri, Jul 28, 2006 at 07:34:07AM -0600, John Meyer wrote: Is there still development going on of mysql 4? In general, only security-related bugs are being fixed in the 4.1 tree. (Sometimes other bugs will get fixed in those trees in the course of implementing a fix intended for the later releases.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connecting to the embedded server
On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote: Dear all, is it a desired feature that the embedded version of the client library still tries to create a network connection when I pass a hostname into connect? Yes, the embedded version also acts as a standard MySQL client. Is it possible to influence this behaviour, so that the API just ignores settings like the hostname and the port and always connects to the embedded server? You can call mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, 0) after calling mysql_init() and before calling mysql_real_connect(). http://dev.mysql.com/doc/refman/5.1/en/mysql-options.html Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Random Hangs, Linux AMD 64, 5.0.22 AB Binaries
Sounds like the well-known problem with Debian stable's glibc on x86_64: http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Differences between MySQL 4 and 5 for scripts
On Wed, Jun 14, 2006 at 11:00:36PM +0100, Graham Reeds wrote: Dan Buettner wrote: Graham, I seem to recall those single quote marks working without a problem on various platforms and versions of MySQL. Of course they are generally just a nicety and only required if you are using reserved words as table/column/key names, so you could just remove them entirely. Could you post the exact error message you're getting please? You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''Blog'' at line 1 when line one is DROP TABLE IF EXISTS 'Blog'; You're not quoting the table name correctly. Identifiers must be quoted using the backtick (`), if they are quoted at all. You should be fine with: DROP TABLE IF EXISTS Blog; or DROP TABLE IF EXISTS `Blog`; 2) You could work around this problem a different way ... - create a 5.0 database yourself using the standard supplied scripts, perhaps on your own workstation - dump your new database structure using mysqldump with the flag --compatible=mysql40 which should create a file suitable for piping into a MySQL 4.0 server That worked. The gotchas: * CHARSET wasn't exported as CHARACTER SET - it wasn't exported at all. Because MySQL 4.0 does not understand character sets at the table level. (It was a new feature in MySQL 4.1.) * TYPE is now ENGINE (ie TYPE=InnoDB is now ENGINE=InnoDB) ENGINE is supported as of MySQL 4.0.18. * The tables have gone from having an initial capital letter to all lower caps (I thought v5 was all lower caps anyway?) On systems with case-insensitive file systems, MySQL will lowercase table and database identifiers. * Also an error occurred regarding varchar size (it appears v5 can hold 4096 while v4 max is 255). The maximum size of a VARCHAR is 255 bytes in MySQL 4.0, and about 64K characters in MySQL 4.1 and later. Can you load a v5 server with a v4 script? Yes, you can generally load scripts written for MySQL 4.x into MySQL 5.x. You may also want to use the special syntax for specifying version-specific parts of your query: http://dev.mysql.com/doc/refman/5.0/en/comments.html Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Security fix for 4.0.27?
On Mon, Jun 05, 2006 at 10:16:05PM -0700, Ken Williams wrote: Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue? (http://lists.mysql.com/announce/364) 4.1 and 5 have been already, kinda wondering why 4.0 hasn't. It will not, because 4.0 does not have this bug. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sub-query optimizer improvements scheduled?
On Sat, May 06, 2006 at 12:55:55PM +0100, Peter Rosenthal wrote: Out of interest is there any time on the roadmap to improve the query optimizer's handling of sub-queries as specified in http://dev.mysql.com/doc/refman/5.0/en/subquery-restrictions.html ? As Timour previewed at his Speeding Up Queries session at the MySQL Users Conference, optimizations for subquery performance are currently scheduled for the 5.2 release. (And as I'm sure Robin and Zack covered at one of their talks on the MySQL roadmap, 5.2 is currently scheduled to reach a production release sometime in 2007.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql4.0
On Fri, May 05, 2006 at 03:40:10PM +0100, Chris wrote: Is mysql 4.0 still supported or EOL, as the recent advisory says users of 4.0 should upgrade to 4.1 to patch the security problem. Subsequently I have noticed a new 5.x release and new 4.1.x release and no 4.0.x release. There are currently no plans to release a new version of 4.0. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Many sources are in correct. For example the Gui Tools.
On Tue, Apr 18, 2006 at 06:19:53PM -0600, Boyd Lynn Gerber wrote: What has happended to all the bk repo's? The documentation says there there but they are not. For example. http://dev.mysql.com/doc/administrator/en/mysql-gui-install-source-download.html http://dev.mysql.com/doc/query-browser/en/mysql-gui-install-source-download.html http://dev.mysql.com/doc/refman/4.1/en/development-source.html http://dev.mysql.com/doc/refman/5.0/en/development-source.html http://dev.mysql.com/doc/refman/5.1/en/development-source.html I know some have gone to SVN where are the publice repo's? You can find the SVN repositories for the GUI tools and Connectors at http://svn.mysql.com/ The server repositories are still at http://mysql.bkbits.net/ Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Where is the more detailed document of MySQL Network?
On Mon, Apr 17, 2006 at 11:26:38AM +0800, 古雷 wrote: Hello: For example: What does Web Access and Remote Troubleshooting mean in this page https://shop.mysql.com/network.html?rz=s2 'Web Access' means you have access to the web-based support system. 'Remote Troubleshooting' means that MySQL support engineers will log in to your systems to troubleshoot problems. There is more information about this here: http://www.mysql.com/company/legal/supportpolicies/policies-08.html Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Download older versions
On Thu, Apr 13, 2006 at 07:13:55PM -0500, Mike Blezien wrote: Hello, I'm trying to locate the RPM downloads for MySQL version 4.0.26(4.0.26-pc-linux-gnu-i686), for a RH/7.3 system, but can't seem to find them. Doesn't MySQL site have older version archives where these older RPM's can be downloaded ... if so, where would they be located ?? Old releases can be found at: http://downloads.mysql.com/archives.php Specifically, the RPM packages for 4.0.26 can be found at: http://downloads.mysql.com/archives.php?p=mysql-4.0v=4.0.26 Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 5.1 Delopment source
On Fri, Jan 06, 2006 at 06:02:05AM -1000, Beau E. Cox wrote: Hi - I am trying to download the 5.1 development sources as per the documentation; when I try this: export PATH=/home/beau/src/bitkeeper/bk_client-1.1:$PATH sfioball -r+ bk://mysql.bkbits.net/mysql-5.1 mysql-5.1 The name of the repository was changed to mysql-5.1-new, and it looks like the documentation may not have been updated. try: sfioball -r+ bk://mysql.bkbits.net/mysql-5.1-new mysql-5.1 Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: this listserv function...?
This is addressed in the FAQ for the mailing lists. http://lists.mysql.com/faq.php#replyto Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction with bdb table gives error Lock table is out of available locks
On 12/7/05, Marco Baroetto [EMAIL PROTECTED] wrote: Hi, I have a berkeley db table containing about 5 rows where I do this transaction (pseudocode follows): begin work delete from mytable where myfield='boo' /*delete about 100 rows*/ for (i=0; i=100; i++){ insert into mytable values(...); } commit During the insert command i get the following error: Lock table is out of available locks I tried to resolve the problem starting mysqld with -O bdb_max_lock=6 and later with -O bdb_max_lock=12 but i still receive the same error. Hi Marco. What does 'SHOW CREATE TABLE' look like for your table? You may want to file a bug about this and attach your data and the actual queries being run. I was not able to come up with a test case to reproduce this problem, but you haven't provided much information to go on. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Control Center
On Tue, Nov 22, 2005 at 04:50:42PM -0800, Jon Drukman wrote: What happened to MySQL Control Center (aka mycc or mysqlcc)? The dev.mysql.com site redirects to the Query Browser page. QB is a poor substitute for mycc. It looks like neither of them has had active development much lately but at least mycc, even in its beta stage, is fairly useful. Development of MySQL Control Center was halted a couple of years ago. The new GUI tools (Query Browser, Administrator, etc) are still under active development. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: any alias for MySQL cluster question?
On Fri, Nov 18, 2005 at 02:41:30PM -0800, Jenny Chen wrote: I'd ask some questions on MySQL cluster. Does anyone know if there is any email alias for the cluster questions? Yes, there is a mailing list for MySQL Cluster: http://lists.mysql.com/cluster Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Aborting slipped keys
On Wed, Nov 16, 2005 at 06:33:40PM -0800, Scott Haneda wrote: Sometimes I paste in something in mysql CLI and it just does this: WHERE products.ship_status != 1 ); /c \c \c; I tried all the \c commands and nothing will get me out of it, I can ^c and it will get me out, but then I have to login again, which is a pain, how can I tell mysql to drop me back to a clean prompt? Just close the open quote before you use \c mysql select \c mysql Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem ( large problem ) with date fields after 4.0.x to 4.1.x upgrade
On Wed, Nov 09, 2005 at 02:06:59PM +1100, Daniel Kasak wrote: Background on data: mysql select ID, Loc_FK, BatchNo, EAPDate from EAPosting where Loc_FK=7249; +---++-++ | ID| Loc_FK | BatchNo | EAPDate| +---++-++ | 59370 | 7249 | 60992 | 2004-08-31 | | 60512 | 7249 | 64986 | 2004-09-30 | | 60513 | 7249 | 64986 | 2004-10-31 | | 60514 | 7249 | 64986 | 2004-11-30 | | 60515 | 7249 | 64986 | 2004-12-31 | | 61714 | 7249 | 70753 | 2005-01-31 | | 61715 | 7249 | 70753 | 2005-02-28 | | 61716 | 7249 | 70753 | 2005-03-31 | | 63124 | 7249 | 74142 | 2005-04-30 | | 63125 | 7249 | 74142 | 2005-05-31 | | 63126 | 7249 | 74142 | 2005-06-30 | | 64194 | 7249 | 83404 | 2005-08-31 | | 64195 | 7249 | 83404 | 2005-09-30 | +---++-++ 13 rows in set (0.01 sec) So far so good. mysql select max(EAPDate) from EAPosting where Loc_FK=7249; +--+ | max(EAPDate) | +--+ | 2005-09-30 | +--+ 1 row in set (0.00 sec) *BIG* problem! What's up with the 2005-09-30 record? Perhaps I'm missing something, but 2005-09-30 looks like the maximum value of EAPDate in the data above. What did you expect the result to be? Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Does the MySQL mailing list use MySQl to manage the mailing list?
On Thu, Oct 13, 2005 at 02:34:00PM +0900, Dave wrote: I am curious to know if the MySQL mailing list uses MySQL in managing the list and it's archives. The articles are surely archived in a database, and I would assume that if the MySQL developers were to use any database, it would be a MySQL one. What applications are used for management of this list? I like the way it is handled, and I have always been interested in having a mailing list manager that uses MySQL to keep track of members. The lists are managed using ezmlm-idx (http://www.ezmlm.org/). The subscription lists are kept in a MySQL database, the message archives are simply kept in the filesystem, the index of messages used by the news server and web archive are kept in MySQL, and the search index is kept in MySQL. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Federated engine and comment???
On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote: Did I just see in the documentation that the comment clause is being misused to supply a connection string for the federated engine? If so, I sure hope it will be changed before the final 5.0 release. This is fixed in 5.0.13, the documentation just hasn't caught up with the change yet. The new syntax is CONNECTION = '...'. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: reply to header?
On Tue, Aug 02, 2005 at 02:38:01PM -0400, Jason Pyeron wrote: why does this list not have the reply to header set? This is covered in the mailing list FAQ at http://lists.mysql.com/faq.php Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql user name length
On Wed, Jul 06, 2005 at 03:46:02PM -0700, Tim Traver wrote: Is there any reason why I shouldn't increase the size of the allowable user names in mysql to var(32) instead of the default var(16) ??? Couldn't really find much on it, but wanted to ask if anyone knows of any troubles this may cause... Yes, there are a number of places within the server that only expect the username to be 16 characters, and will almost certainly break in the face of longer usernames. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Issues on Debian-AMD64 - looking for ideas or help.
On Tue, Jun 28, 2005 at 10:37:43PM -0700, mike wrote: I'm compiling my mysql server from source. I have started noticing this as of 4.1.10 - in fact, I was running 4.1.12 and it's changed the LinuxThreads detection (since LT does not exist on amd64) - and 4.1.12 kept locking up after only a few minutes of uptime consistently. Once I figured this out, I rolled back to my 4.1.10 with a small patch to the configure script to force the calling of CFLAGS=$CFLAGS -DUSE_MUTEX_INSTEAD_OF_RW_LOCKS -DPTHREAD_ADAPTIVE_MUTEX_INITIALIZER_NP I'm wondering though - am I missing something here? This is a bug in the version of glibc being shipped with Ubuntu, and apparently Debian as well. Here's the Ubuntu bug for tracking it: https://bugzilla.ubuntu.com/show_bug.cgi?id=11730 There's also a Debian bug for it, but I can't find it right now. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lists.mysql.com maintenance - Friday, June 10
The lists.mysql.com services will be offline for maintenance during parts of this coming weekend starting at 15:00 PDT (22:00 GMT) on Friday, June 10. Any mails you send during this time and mails to you from the lists will all still be delivered, but with some possible delays. Everything should be back to normal by next Monday, June 13, at the latest. Our apologies for the late notice. As always, you can contact [EMAIL PROTECTED] about any problems you are having sending or receiving messages from the lists.mysql.com mailing lists. Thanks. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: No Longer Receiving Emails
lists.mysql.com was down temporarily due to a faulty disk. Mails to and from the lists should be working now. When you notice a disruption like this, it is best if you simply check http://lists.mysql.com/ to verify if there are mails in the archive that you have not yet received, and just be patient -- when you send these test emails, they get queued up and delivered to the thousands of list subscribers when the lists come back online. *Do not send test emails to the list.* If you believe you are experiencing trouble receiving mails from the list, please contact the list administrators at [EMAIL PROTECTED] Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tiger - MySQL --- any news ???
On Mon, May 23, 2005 at 04:03:52PM -0500, Kevin Victor wrote: I would like to know if there is any existing solution for running MySQL on Tiger. I dont see a binary version for 10.4 yet, will it be released any time soon?? The existing binaries for 10.3 should run fine on Tiger. Personally, I've downloaded the 4.1.12 standard installer package, installed it, and run the full test suite and it all passed. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hashmysql.org 0wn3d?
It was taken offline temporarily. It's back now. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why building obsolete versions.
On Fri, May 20, 2005 at 10:50:29AM -0700, Fredrick Bartlett wrote: The documentation indicates that there are three active versions being worked on. Is this true? Why not just release the current one with the most bug fixes? D.1.1. Changes in release 5.0.7 (not released yet) D.1.2. Changes in release 5.0.6 (not released yet) D.1.3. Changes in release 5.0.5 (to be released soon) The documentation is just out-of-date here. 5.0.5 will not be released. 5.0.6 will be released soon. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 2 MySQL Errors
On Fri, Mar 25, 2005 at 07:27:47PM -0800, David Blomstrom wrote: I can't figure out why I get an error message relating to fiels borderstates and bordernotes when I try to create a new table. One is VARCHAR, the other TEXT, and both are NULL, like almost every field on the table. Can someone tell me what I'm doing wrong? Thanks. [snip] `borderk` INT( 6, 1 ) DEFAULT NULL , This is your problem. INT does not take two parameters. [ snip ] MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1) DEFAULT NULL, `borderstates` VARCHAR(255) DEFAULT NULL, `bordernotes` TEXT DE' at line 1 That's why the error message says near 1) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Password (str) vs. MD5 (str)
On Mon, Dec 06, 2004 at 04:21:38PM -0600, [EMAIL PROTECTED] wrote: does anyone know what type of encryption is used in the PASSWORD(str) function? When would you use the MD5 vs the PASSWORD function? We have a campus standard to use the MD5 encryption so I need to confirm if the PASSWORD function will offer that or not. As the manual says, the PASSWORD() function should not be used within your application. It is meant only for use with the built-in MySQL privilege tables. Use MD5() or SHA1() for your own applications. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Full Text Wild Card Searches
On Fri, Dec 03, 2004 at 10:30:25AM -0500, Michael J. Pawlowsky wrote: I've been trying to implement full text searches. Genreally I use either LIKE or REGEXP for searches but wanted to try some Full Text Searches. It's wonderfully fast and is working well for full words, however I have not found a way to add wildcards in a search. For example if in my text fields I have the word residential I would like the key resident to match it. Is there any way to do this in Full Text Searches? If you are doing the search in Boolean mode, you can add '*' to the end of a word to match all words beginning with that prefix. For example: SELECT record FROM table WHERE MATCH (record) AGAINST ('resident*' IN BOOLEAN MODE) (Using 'IN BOOLEAN MODE' requires MySQL 4.0 or later.) -- Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: archived versions of MySQL
On Mon, Nov 22, 2004 at 03:49:52PM -0800, Emmett Bishop wrote: I need to snag a copy of MySQL 4.0.20 for Windows. Is there somewhere on the MySQL I can grab older versions? http://downloads.mysql.com/ -- Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL syntax error
On Sat, Nov 13, 2004 at 12:30:43PM -0800, Stuart Felenstein wrote: $sql = SELECT PostStart, JobTitle, Industry, LocationState, VendorID FROM VendorJobs; echo $sql; //if ($Ind) $sql .= WHERE VendorJobs.Industry = $s_Ind; As you can see above s_ind is an array , comma delimited. To me this all looks fine. to the parser, well ;) You can't compare a column with a comma-delimited list of numbers like that, and you also want to make sure there is a space before the 'WHERE' keyword. You want: $sql .= WHERE VendorJobs.Industry IN ($s_Ind); -- Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL syntax error
On Sat, Nov 13, 2004 at 12:46:12PM -0800, Stuart Felenstein wrote: --- Jim Winstead [EMAIL PROTECTED] wrote: You can't compare a column with a comma-delimited list of numbers like that... What should the seperator be then ? My point was that you can't compare a column with an array of numbers using the '=' operator. You have to use the IN operator, as in the line of code I posted: $sql .= WHERE VendorJobs.Industry IN ($s_Ind); (where $s_Ind is a comma-delimited list of numbers or quoted strings.) -- Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Works with MySQL Logo
On Tue, Nov 02, 2004 at 11:57:35PM -0800, Karam Chand wrote: I had checked google before posting. As you can see none of the images are original and the clarity is not good. They dont look good in my app. Can I get an original one from MySQL AB? The official MySQL logos can be downloaded from http://dev.mysql.com/downloads/logos.html There is no official 'Works with MySQL' logo (and I don't think there ever has been). Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 table/column names in UTF8
On Tue, Oct 26, 2004 at 01:03:22PM -0700, Brian Mansell wrote: From http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html : # Important note: MySQL 4.1 stores table names and column names in UTF8. If you have table names or column names that use characters outside of the range from `A' to `Z', you may have to do a mysqldump of your tables in MySQL 4.0 and restore them after upgrading to MySQL 4.1. The symptom for this problem is that you get a table not found error when trying to access your tables. In this case, you should be able to downgrade back to MySQL 4.0 and access your data. In our MySQL 4.0 databases today, we have log tables with names like 'system_log_day_20041026'. Based upon the `A` to `Z` conditional in the above statement, are we in any way at risk of not being able to access our tables? No. (The actual risk is with table or database names that have characters outside of the standard US-ASCII range.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: where to download older versions?
On Thu, Oct 14, 2004 at 02:23:09PM +0200, [EMAIL PROTECTED] wrote: please, where can I download older version (4.0.20) of mysql for Windows? I searched archives, documentation, no advice. In fact, I only need libmysql.dll file - can anybody send me? Sorry, there was a mixup that caused the 4.0.20 binaries to not be available at http://downloads.mysql.com/archives.php (where all older releases can be downloaded). The binaries for 4.0.20 are available from there now. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
Hey folks. Apparently I need to say it again: this discussion is off-topic for this mailing list. Please either let it die or take the discussion off-list. Thanks. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
Hi. This discussion is very off-topic for this list. Please take the discussion of how to use your email client off-list. Thanks. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: UTF8 pre-4.1?
On Thu, Sep 16, 2004 at 10:56:55AM -0700, V. M. Brasseur wrote: *I* understand that Unicode utf8 support does not happen until version 4.1 (I can read the manual), but there are some in the office who are skeptical and somehow believe that there is support for it in earlier versions (as early as 3.23, according to them). To set all of our minds at ease, could someone else please confirm or deny for me that MySQL does not support utf8 prior to version 4.1? I don't believe I'm wrong in this case, but if I am I would very much like to know. MySQL versions before 4.1 do not support UTF-8. It is, however, possible to simply store UTF-8 data in a string field (VARCHAR, CHAR, TEXT, etc) in those versions. You simply won't be able to get the correct ordering in ORDER BY clauses, and full-text search will not always work as expected. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to download MySQL (fwd)
On Wed, Sep 15, 2004 at 01:33:08AM +0800, Bret Busby wrote: Does the message below, mean that everyone who posts a message to this list, will receive a message such as the one below, from the person below, for the next week? Not any more, because he's been unsubscribed from all MySQL mailing lists. When you receive such emails, you can forward them to [EMAIL PROTECTED] and we'll take care of it. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Data Dictionary (INFORMATION_SCHEMA)
On Wed, Aug 11, 2004 at 07:03:18PM +0200, Jochem van Dieten wrote: MySQL strives to ful SQL standard compliance (ISO/IEC 9075), so an INFORMATION_SCHEMA must be planned for someday. However, that day does not appear to be in the near future. INFORMATION_SCHEMA will be supported in MySQL 5.0. A developer (Sergey Gluhov) is currently working on the implementation. The 'New Features Planned for 5.0' section of the manual will be updated soon to mention it. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql] Question about the reference manual
On Wed, Aug 04, 2004 at 02:46:50PM -0500, rdo mail list address wrote: Is the MySQL Reference Manual, by Widenius and Axmark (the one to which there is a link on the Documentation page of the mysql website, for sale by Barnes and Noble) the same reference manual that you can download? The PDF version has 1310 pages, the softcover book has 712 pages, and I'm not sure that they're the same. I like to have an actual book so that I can take it with me and study in places where I have to waste some time waiting. But I suspect the online manual is more up to date than the published book, and wanted to confirm whether that is true. The MySQL Reference Manual published by O'Reilly is the same reference manual as the website -- as it existed when it was published in June 2002. The manual has been updated quite extensively since then. Two new books have just been published under the MySQL Press imprint that are derived from the online manual. You can find more information about them at http://www.mysqlpress.com/ Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Display of ? and Hex conversion
On Fri, Jul 02, 2004 at 01:52:06PM -0500, Boyd E. Hemphill wrote: We discovered a rather odd situation where some space characters where being displayed as ?. In tracking this down, it was determined that the server had stored the hex value A0 rather than 20 by using this query: 'A0' is the code for a non-breaking space, assuming you're using the iso-8859-1 (or related) character encoding. update Location set NameLn = replace(hex(NameLn), 'A0' , '20') where hex(NameLn) like '%A0%' Better would have been: UPDATE Location SET NameLn = REPLACE(NameLn, CHAR(0xA0), ' ') WHERE NameLn LIKE CONCAT('%',CHAR(0xA0),'%') Now for the NameLn field I have the hex string (arrg my data has been hexed!!! :-) So, my questions are: 1. How do I go back from the hex string to characters? You can use the UNHEX() function. 2. Has anyone else seen this problem? At this point I can say the diplay issue only appears on some browsers. The likely culprit for this sort of thing, in my experience, is users using cut-and-paste from an application like Microsoft Word into their browser. That often introduces similar issues with characters like curly-quotes and em-dashes. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: average in Group By
On Fri, Jun 04, 2004 at 09:25:58AM -0700, Shantanu Oak wrote: I am trying to find average price of the shares in the portfolio table. I thought something like this should work... SELECT symbol, ((sum(buyrate*quantity))/quantity) as average from portfolio group by symbol; It does work, but wrong results. What is the correct query? Why not use the AVG() function? It does exactly what you want. http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Off Topic: Search in this list not are functioning
On Fri, Jun 04, 2004 at 10:33:27AM -0300, Renato Cramer wrote: I tried search numerous times and not get: either return all messages or neither. Is one known problem? The search box in the sidebar was simply not going to the right place. This has been fixed. Thanks for the report. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Where is Release mysql-4.1.2a-alpha-win.zip
On Sun, May 30, 2004 at 06:58:35PM +0200, Bernhard Döbler wrote: searching for latest MySQL-Downloads I see there's no mysql-4.1.2a-alpha-win.zip available by now on - for example - ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-4.1/. As Patrick's release announcement (http://lists.mysql.com/announce/199) said, binaries for Microsoft Windows are not yet available for 4.1.2. http://dev.mysql.com/downloads/mysql/4.1.html links the file mysql-4.0.20a-win-noinstall.zip in the MySQL-4.1 directory on MySQL-Download FTP-Servers as 4.1 release without installe. Is that correct? No, some files were simply copied into the wrong directory, and thus listed on the wrong page. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why is MySQL.com using MnoGoSearch for searching its site???
On Fri, May 28, 2004 at 12:17:37AM -0500, mos wrote: As most people already know, MySQL has FullText indexing built into it, so why is mysql.com using MnoGoSearch? (There is an icon Powered by MnoGoSearch on the search page.) 1) Is there something wrong with MySQL's FullText search for handling a lot of data? Not at all. 2) Is MnoGoSearch better? Well, it does understand HTML, so it is able to index the HTML content of our sites more intelligently than MySQL's full-text search could. 3) Why isn't MySQL using their own Full Text search engine? We do, just not for the full-text search of our sites. (It is used in the first set of documentation links that are presented with some searches, and for the search on http://solutions.mysql.com/.) Also, mnoGoSearch uses MySQL for its index storage. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: query to see if db exists...........mysql_query( myQuery)
On Thu, May 27, 2004 at 03:59:46PM -0400, Bono, Saroj AA R62 wrote: I am going to use mysql_query() and want to find out if a certain database exists. If mysql_real_connect() fails there are many errors that could account for this. The database may exist , and I cant take the error returned from the failed query to mean the db isnt there and should be created. So what sort of query can I use to see whether the db exists? I thought of USE myDb but once again a failed mysql_query cant rule out other factors that can cause the failure. Any suggestions? You could use SHOW DATABASES LIKE 'myDb'. http://dev.mysql.com/doc/mysql/en/Show_database_info.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Determine table type and comments
On Wed, May 26, 2004 at 06:22:45PM -0700, Scott Haneda wrote: I can not find this in the docs. I can see in phpmyadmin what a table comment is and what type of table it is, such as MyISAM etc. From the mysql shell, how do I get to this info? You can use SHOW TABLE STATUS: http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Defaul of NOW()
On Wed, May 26, 2004 at 06:20:22PM -0700, Scott Haneda wrote: I have a field in mysql 4, using InnoDB Field is timestamp 14 and defualt is set to 00, which I want to be the result of NOW() so that every record made will get NOW() as the value, I can not get it to work... ALTER TABLE `addresses` CHANGE `added` `added` TIMESTAMP( 14 ) DEFAULT 'NOW()'; Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 It tells me it worked, but then it reverts back to the zero's. If you do a SHOW CREATE TABLE on the table, you'll see that it has actually ignored your DEFAULT. (What is has done is actually transformed it to '00', since that is what the string 'NOW()' becomes when you convert it to a TIMESTAMP.) Read this section in the manual for information on how the default value for TIMESTAMP columns is handled: http://dev.mysql.com/doc/mysql/en/TIMESTAMP_pre-4.1.html Support for specifying how TIMESTAMP columns get updated is coming in 4.1.2. Right now, it is only documented in the change notes: http://dev.mysql.com/doc/mysql/en/News-4.1.2.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL User Conference - Session Presentations?
On Wed, Apr 28, 2004 at 02:51:50PM -0400, Mihail Manolov wrote: Does anybody knows if User Conference' presentations were published somewhere on the web? I was told that it will be done shortly after the conference, and it is more than a week after the conference end... They will be published at http://www.mysql.com/uc2004 by the end of the week. (Those that we've collected from the speakers, that is. We'll continue to publish additional ones as we receive them.) Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL cluster
On Thu, Apr 15, 2004 at 03:05:01PM -0400, Wensheng Deng wrote: Is there some version of MySQL cluster available for downloading at the moment? If yes, where is it? Thanks in advance. MySQL Cluster is currently only available in source form as part of the MySQL 4.1 BitKeeper repository (which means it will show up in the nightly snapshots at http://downloads.mysql.com/snaps.php soon), it will be part of the source download for MySQL 4.1.2 when that is released, and binaries will be included in 4.1.2 or later 4.1 releases for those platforms that MySQL Cluster supports. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: blacklist
On Thu, Jan 15, 2004 at 02:39:36PM +0100, Stefaan Van Dooren wrote: Since some days I don't get any mail from this list anymore. After some investigation, I found that it's blacklisted and our mailserver refuses any mail from it. DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed Can this be fixed ? The lists.mysql.com server appears to have been dropped from SpamCop's blocking list. Here's what SpamCop has to say about this blocking list: This blocking list is somewhat experimental and should not be used in a production environment where legitimate email must be delivered. It is growing more stable and is used by many large sites now. However, SpamCop is aggressive and often errs on the side of blocking mail - users should be warned and given information about how their mail is filtered. Ideally they should have a choice of filtering options. Many mailservers can operate with blacklists in a tag only mode, which is preferable in many situations. Given the policies of this blocking list, I would not recommend it to anyone, especially as a single criteria for rejecting mail. It appears trivial for any of SpamCop's users to get any host blacklisted, without any notification to that host. Sorry for the inconvenience. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: This list
On Mon, Jul 14, 2003 at 11:11:04AM +0100, Phil Bitis wrote: Might it be worth looking at the mailing list manager software for this list? ACCU's mailing lists use Majordomo and add this line to the rfc822 headers: Reply-To: [EMAIL PROTECTED] You can still see the sender's email address if you want to reply directly. This is covered in the FAQ for the mailing lists: http://lists.mysql.com/faq.php#replyto Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: fulltext indexing of alphanumeric strings?
On Fri, Jun 27, 2003 at 04:47:43PM -0400, Daniel Whitener wrote: Thanks for the quick reply! Actually I read through that page before and I tried it and still nothing mysql SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*'); Empty set (0.00 sec) any good reason why that wouldn't work? Yes, you need to be doing a boolean full-text search to use the operators like '*'. Your query would look like: SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*' IN BOOLEAN MODE); Note that this requires MySQL 4.0.1 or later. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: More anti-spam annoyance
On Tue, Jun 17, 2003 at 10:52:27AM -0400, Keith C. Ivey wrote: It's not bad enough that we have subscribers with challenge-response systems misconfigured so that they respond to each message from the list. Now one of the list admins is apparently doing something similar. At present rates of growth, it will be interesting to see whether spam or anti-spam responses end up flooding the e-mail system more. As Mark Matthews pointed out, this message is not from one of the list administrators. Whenever you receive a message like this, please forward it to [EMAIL PROTECTED] (including the complete headers), and we will unsubscribe the address causing the messages. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Syntax question
On Mon, Jun 16, 2003 at 12:45:53PM -0400, Martin's - Web Dept. wrote: I am quite willing to acknowledge that I'm new at this ... But I can't find the syntax error in this query: SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb') desc is a field name, usb is the keyword I'm searching for. 'desc' is a reserved word. you need to surround it in backquotes when using it as a field or table name. SELECT * FROM products WHERE MATCH (`desc`) AGAINST ('usb') There's more information about reserved words at: http://www.mysql.com/doc/en/Reserved_words.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble with SELECT AS syntax
On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: SELECT item_name AS name, item_desc AS desc FROM food; 'desc' is a reserved word. Try: SELECT item_name AS name, item_desc AS `desc` FROM food; Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication over SSL
On Sun, Jun 08, 2003 at 01:08:58PM +0100, Gareth Davis wrote: I guess that explains alot. Is there any work around with say, stunnel/ssh etc? Yes, you could certainly use something like stunnel or an ssh tunnel to forward a port between two machines and do replication over that. Here's a couple of articles that may help: http://www.guydavis.ca/projects/oss/docs/ssh_mysql.jsp http://www.stunnel.org/examples/mysql.html One thing to keep in mind is that when you want to connect to a MySQL server via a non-standard port on your local machine, you need to specify the host to connect to as '127.0.0.1', and not 'localhost'. When using 'localhost', MySQL generally tries to connect using a local Unix socket, and ignores the port you specify. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL
Hi Neil. On Wed, Jun 04, 2003 at 02:33:22AM -0230, Neil Zanella wrote: I believe that MySQL is in error in reporting the following message just because I did not specify that the PRIMARY KEY should not be NULL. These days there are standards and SQL92, AFAIK, specifies that if the primary key is not explicitly set to NOT NULL then the RDBMS should automatically and silently assume the user means NOT NULL. After all, any half decent book on relational databases out there will tell you that primary keys cannot be null. So why does MySQL do it this way. By doing this MySQL is breaking the portability of my standard SQL code which works so well with postgreSQL and Oracle 9i. So why donesn't MySQL play nice and abide to the standard? Is this fixed in MySQL 4? I am running MySQL 3.23.54a as distributed with Red Hat 9, which, for some reason has not decided to update their mysql RPMS to MySQL 4 for that release but I am interesting in knowing if this has been fixed in MySQL. I think one of MySQL's goals should be to support standards such as SQL92 (if not SQL99). Even if internally some things don't work as expected, at a minimum, the parsers should be compatible as much as possible, including standard data types and assuming primary keys are not null by default. This bug was fixed in MySQL 4.0.13, after it was reported to our bug tracking system here: http://bugs.mysql.com/390 As Peter Gulutzan notes in a comment to that bug, the previous behavior was consistent with the SQL-92 standard, but that has been relaxed in SQL-99, and we are currently working towards SQL-99 compliance. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication over SSL
Hi Gareth. On Tue, Jun 03, 2003 at 09:59:52AM +0100, Gareth Davis wrote: I guess this is right place for this. I'm trying to setup replication between two hosts over the Internet. My problem is that i can't seem to solve an authentication problem between the slave and the master. Before I tried this I setup a test between two computers here in the office and managed to get it to work. Replication over SSL connections is not currently supported. The current plan is that it will be supported in 4.1. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SELECT query with OUTER JOIN - problem
On Mon, Jun 02, 2003 at 12:48:38PM +0200, Dejan Milenkovic wrote: I have two tables, one is containing data about courses and the second one is containing data about course start date. Is it possible to list all courses with one query which should also return earliest scheduled start dates for courses (which are in the second table). I tried something like this: SELECT c_d.*, MIN(c_s.start) as start FROM course_data c_d RIGHT OUTER JOIN course_start c_s ON c_s.courseid=c_d.courseid WHERE c_s.startNOW() GROUP BY c_s.courseid But this return only courses that have start date if I replace ON condition with 1=1 I get list of all courses but with the same date, if I remove ON condition MySQL return error, I also tried replacing ON c_s.courseid=c_d.courseid with USING (courseid) but that didn't help. Any help is appriciated. Here are the table definitions and test data. CREATE TABLE course_data ( courseid mediumint(9) NOT NULL auto_increment, data varchar(255) NOT NULL default '', PRIMARY KEY (courseid) ) TYPE=MyISAM; INSERT INTO course_data VALUES (1, 'Test data'); INSERT INTO course_data VALUES (2, 'Also test data'); CREATE TABLE course_start ( courseid mediumint(9) NOT NULL, start date NOT NULL default '-00-00' ) TYPE=MyISAM; INSERT INTO course_start VALUES (1, '2004-12-12'); So I need quey that would return both courses where the start column for course 1 would be '2004-12-1 and NULL for course 2. You don't want a RIGHT OUTER JOIN -- you want a LEFT [OUTER] JOIN, because you are trying to get a result for each row from the left-most table. But you also need to explicitly select those results where the start is NULL. So your query would be: SELECT c_d.*, MIN(c_s.start) AS start FROM course_data c_d LEFT JOIN course_start c_s USING (courseid) WHERE c_s.start NOW() OR c_s.start IS NULL GROUP BY c_s.courseid; This returns: +--+++ | courseid | data | start | +--+++ |2 | Also test data | NULL | |1 | Test data | 2004-12-12 | +--+++ Here's an article from SQL-Guru.com that explains the basic join types: http://www.sql-guru.com/sql101/basicjoins.html I hope that helps. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hex search?
On Mon, Jun 02, 2003 at 06:49:42AM -0700, Admin wrote: Is there any way to do a hexadecimal search via MySQL? I've found that the data I uploaded from text files has some end-of-line characters in it, and its causing my data to break in mid-line when spitting out a text file. Would be cool to search the table for offending characters if possible. Yes, you specify hexadecimal strings that you can then use with the various string functions, including the string comparison functions: http://www.mysql.com/doc/en/Hexadecimal_values.html http://www.mysql.com/doc/en/String_functions.html http://www.mysql.com/doc/en/String_comparison_functions.html You could replace all CRLF sequences with spaces in a particular field with a query like: UPDATE mytable SET mytext=REPLACE(mytext, 0x0D0A, ' '); Hope that helps. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: .ezm files
On Thu, May 29, 2003 at 12:59:35PM -0700, 2Hosts.com wrote: sorry for being a thikky, but how do i open a .ezm file? This is answered in the FAQ for the mailing lists at http://lists.mysql.com/faq.php#digest-oe Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0.12 rpm's
On Wed, Mar 26, 2003 at 10:30:32AM -0800, Paul wrote: This may indicate incredible ignorance but all I can find there are tar.gz files which untar into the complete distribution but no rpm's are present. The RPM downloads for 4.0.12 can be found at http://www.mysql.com/downloads/mysql-4.0.html#Linux_x86_RPM (This is the second group of downloads on the page.) Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: List-ID Header
On Sun, Mar 23, 2003 at 10:43:28AM +0100, Joseph Bueno wrote: It seems that emails coming from mysql mailing list don't include 'List-ID: mysql.mysql.com' header anymore. Is this going to be fixed or should we change our email filtering rules ? This List-ID header has been restored. Sorry for the oversight. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]