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

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

Re: union operator problems in MySQL v3.23?

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

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,

Re: Falcon and Foreign Key Constraints

, 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

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

Re: innodb to be removed? and...

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

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?

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

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

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

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

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

. 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

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

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

Re: Why release 5.0.23 instead of 5.0.24?

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

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

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

Re: Differences between MySQL 4 and 5 for scripts

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

Re: Sub-query optimizer improvements scheduled?

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

Re: mysql4.0

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

? 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

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

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

Re: Download older versions

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

Re: 5.1 Delopment source

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

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

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

Re: MySQL Control Center

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

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

Re: Aborting slipped keys

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

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

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?

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

Re: Federated engine and comment???

, 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

Re: mysql user name length

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

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

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

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

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

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

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

Re: 2 MySQL Errors

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

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

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

Re: Full Text Wild Card Searches

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

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

Re: SQL syntax error

. 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

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

Re: Works with MySQL Logo

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

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?

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

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?

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

Re: Unable to download MySQL (fwd)

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)

. 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

Re: [mysql] Question about the reference manual

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

-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

, 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

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

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

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

-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

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

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

://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()

/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

Re: MySQL User Conference - Session Presentations?

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

Re: MySQL cluster

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

Re: blacklist

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

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?

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

Re: More anti-spam annoyance

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

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

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

Re: Replication over SSL

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

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

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

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

Re: SELECT query with OUTER JOIN - problem

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

Re: hex search?

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

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

Re: 4.0.12 rpm's

.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

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]