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

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.

Re: "union" operator problems in MySQL v3.23?

e 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 I

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, e

Re: Falcon and Foreign Key Constraints

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...

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:

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?&quo

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.

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

Re: why is `load data from master` obsolete?

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 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 le

Re: ODBC Drivers 3 and 5

ports 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.mysq

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 >

Re: [LICENSING] why so hazy? Comparing to Samba.

L 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 l

Re: [LICENSING] why so hazy? Comparing to Samba.

r 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: htt

Re: Why release 5.0.23 instead of 5.0.24?

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

ter 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

lling 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:

Re: Differences between MySQL 4 and 5 for scripts

e 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

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 ha

Re: Sub-query optimizer improvements scheduled?

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 re

Re: mysql4.0

ase. 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.

e 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

Re: Where is the more detailed document of MySQL Network?

pport 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 Maili

Re: Download older versions

ves 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.0&v=4.0.26

Re: 5.1 Delopment source

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

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"

-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

Re: MySQL Control Center

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 Fo

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.

Re: Aborting slipped keys

ot;> > > 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 &

Re: Problem ( large problem ) with date fields after 4.0.x to 4.1.x upgrade

| > +--+ > 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. -- M

Re: Does the MySQL mailing list use MySQl to manage the mailing list?

lm.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 Li

Re: Federated engine and "comment"???

elease. 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/my

Re: mysql user name length

f > 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:/

Re: Issues on Debian-AMD64 - looking for ideas or help.

IVE_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

lists.mysql.com maintenance - Friday, June 10

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

Re: No Longer Receiving Emails

[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 ???

ersonally, 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: Why building obsolete versions.

ed 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: h

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: 2 MySQL Errors

ve 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 "

Re: Password (str) vs. MD5 (str)

irm > 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 M

Re: Full Text Wild Card Searches

re 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

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 archi

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 t

Re: SQL syntax error

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: $s

Re: Works with MySQL Logo

QL 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:

Re: MySQL 4.1 table/column names in UTF8

g 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?

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.

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

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?

; 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

Re: Unable to download MySQL (fwd)

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)

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 u

Re: [mysql] Question about the reference manual

sively 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

Re: Display of "?" and Hex conversion

ce, 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: 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

Re: average in Group By

mbol; > > 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.mys

Re: Where is Release mysql-4.1.2a-alpha-win.zip

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???

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

Re: query to see if db exists...........mysql_query( myQuery)

gestions? 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: Defaul of NOW()

mation 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

Re: Determine table type and comments

LE 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: MySQL User Conference - Session Presentations?

... 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.mys

Re: MySQL cluster

(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 Wi

Re: blacklist

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: MySQL 5.0 and Stored Procedures

ation was included with the > download, the only other thing around is the blurb on mysql.com In the MySQL 5.0 tree, the file Docs/sp-implemented.txt details the current state of the stored procedures implementation. Examples of the syntax can be found in mysql-test/t/sp.test Jim Winstea

Re: This list

ill 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?

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);

Re: More anti-spam annoyance

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

; 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 reserve

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 a

Re: Replication over SSL

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://list

Re: Replication over SSL

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

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

m/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://l

Re: hex search?

.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 Ge

Re: SELECT query with OUTER JOIN - problem

_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

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: h

Re: 4.0.12 rpm's

oads/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

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]