Re: Can't create/write to file

[Louie Miranda]

answer: http://www.mysql.com/doc/en/Cannot_create.html


-- -
Louie Miranda
http://www.axishift.com


- Original Message -
From: "Louie Miranda" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 12, 2004 2:39 PM
Subject: Can't create/write to file


> mysql> alter table os_bcard drop mobile;
> ERROR 1: Can't create/write to file './rpcweb/#sql-1c6_23.MYI' (Errcode:
28)
> mysql>
>
> anyone got any ideas what is this?
>
>
>
> -- -
> Louie Miranda
> http://www.axishift.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't create/write to file

[Louie Miranda]

mysql> alter table os_bcard drop mobile;
ERROR 1: Can't create/write to file './rpcweb/#sql-1c6_23.MYI' (Errcode: 28)
mysql>

anyone got any ideas what is this?



-- -
Louie Miranda
http://www.axishift.com



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Query takes 1703.57 sec

[Nawal Lodha]

Dear Dan,
Have tried that and it works. 
The query executes in less than 0.1 sec with indexes.
Thanks for the immediate help.
Nawal.


-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 11:29 AM
To: Nawal Lodha
Cc: [EMAIL PROTECTED]
Subject: Re: Query takes 1703.57 sec


In the last episode (Jan 11), Nawal Lodha said:
> I have a query like - 
> 
> SELECT  AdvElement.c_objectId  ,  AdvElement.c_createdOn  ,
> AdvElement.c_modifiedOn , AdvElement.c_elementType ,
> AdvElement.c_packageId , AdvElement.c_stereoTypeId ,
> AdvElement.c_objectType , AdvElement.c_versionNumber ,
> AdvModelElement.c_details , AdvModelElement.c_status ,
> AdvModelElement.c_name , AdvModelElement.c_desc ,
> AdvInstance.c_classifierId FROM AdvElement , AdvModelElement ,
> AdvInstance , AdvObject WHERE AdvElement.c_objectID =
> AdvModelElement.c_objectID and AdvModelElement.c_objectID =
> AdvInstance.c_objectID and AdvInstance.c_objectID =
> AdvObject.c_objectID and AdvElement.c_objectType = 'AdvObject'.
> 
> The query takes  1703.57 sec to execute.
> 
> The explain on the query gives 
> ++-+-+--+---++-++--+-+
> | id | select_type | table   | type | possible_keys | key| key_len | ref 
>| rows | Extra   |
> ++-+-+--+---++-++--+-+
> |  1 | SIMPLE  | AdvInstance | ALL  | [NULL]| [NULL] |  [NULL] | 
> [NULL] |  984 | |
> |  1 | SIMPLE  | AdvObject   | ALL  | [NULL]| [NULL] |  [NULL] | 
> [NULL] |  982 | Using where |
> |  1 | SIMPLE  | AdvElement  | ALL  | [NULL]| [NULL] |  [NULL] | 
> [NULL] | 1646 | Using where |
> |  1 | SIMPLE  | AdvModelElement | ALL  | [NULL]| [NULL] |  [NULL] | 
> [NULL] | 1418 | Using where |
> ++-+-+--+---++-++--+-+

Add indexes on all the fields referenced in your WHERE clause.

-- 
Dan Nelson
[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query takes 1703.57 sec

[Dan Nelson]

In the last episode (Jan 11), Nawal Lodha said:
> I have a query like - 
> 
> SELECT  AdvElement.c_objectId  ,  AdvElement.c_createdOn  ,
> AdvElement.c_modifiedOn , AdvElement.c_elementType ,
> AdvElement.c_packageId , AdvElement.c_stereoTypeId ,
> AdvElement.c_objectType , AdvElement.c_versionNumber ,
> AdvModelElement.c_details , AdvModelElement.c_status ,
> AdvModelElement.c_name , AdvModelElement.c_desc ,
> AdvInstance.c_classifierId FROM AdvElement , AdvModelElement ,
> AdvInstance , AdvObject WHERE AdvElement.c_objectID =
> AdvModelElement.c_objectID and AdvModelElement.c_objectID =
> AdvInstance.c_objectID and AdvInstance.c_objectID =
> AdvObject.c_objectID and AdvElement.c_objectType = 'AdvObject'.
> 
> The query takes  1703.57 sec to execute.
> 
> The explain on the query gives 
> ++-+-+--+---++-++--+-+
> | id | select_type | table   | type | possible_keys | key| key_len | ref 
>| rows | Extra   |
> ++-+-+--+---++-++--+-+
> |  1 | SIMPLE  | AdvInstance | ALL  | [NULL]| [NULL] |  [NULL] | 
> [NULL] |  984 | |
> |  1 | SIMPLE  | AdvObject   | ALL  | [NULL]| [NULL] |  [NULL] | 
> [NULL] |  982 | Using where |
> |  1 | SIMPLE  | AdvElement  | ALL  | [NULL]| [NULL] |  [NULL] | 
> [NULL] | 1646 | Using where |
> |  1 | SIMPLE  | AdvModelElement | ALL  | [NULL]| [NULL] |  [NULL] | 
> [NULL] | 1418 | Using where |
> ++-+-+--+---++-++--+-+

Add indexes on all the fields referenced in your WHERE clause.

-- 
Dan Nelson
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query takes 1703.57 sec

[Nawal Lodha]

I have a query like - 

SELECT  AdvElement.c_objectId  ,  AdvElement.c_createdOn  ,  AdvElement.c_modifiedOn  
,  AdvElement.c_elementType  ,  AdvElement.c_packageId  ,  AdvElement.c_stereoTypeId  
,  AdvElement.c_objectType  ,  AdvElement.c_versionNumber  ,  
AdvModelElement.c_details  ,  AdvModelElement.c_status  ,  AdvModelElement.c_name  ,  
AdvModelElement.c_desc  ,  AdvInstance.c_classifierId FROM  AdvElement , 
AdvModelElement , AdvInstance , AdvObject  
WHERE  AdvElement.c_objectID = AdvModelElement.c_objectID  and 
AdvModelElement.c_objectID = AdvInstance.c_objectID  and AdvInstance.c_objectID = 
AdvObject.c_objectID  and  AdvElement.c_objectType = 'AdvObject'.

The query takes  1703.57 sec to execute.

The explain on the query gives 
++-+-+--+---++-++--+-+
| id | select_type | table   | type | possible_keys | key| key_len | ref   
 | rows | Extra   |
++-+-+--+---++-++--+-+
|  1 | SIMPLE  | AdvInstance | ALL  | [NULL]| [NULL] |  [NULL] | 
[NULL] |  984 | |
|  1 | SIMPLE  | AdvObject   | ALL  | [NULL]| [NULL] |  [NULL] | 
[NULL] |  982 | Using where |
|  1 | SIMPLE  | AdvElement  | ALL  | [NULL]| [NULL] |  [NULL] | 
[NULL] | 1646 | Using where |
|  1 | SIMPLE  | AdvModelElement | ALL  | [NULL]| [NULL] |  [NULL] | 
[NULL] | 1418 | Using where |
++-+-+--+---++-++--+-+

please suggest a solution to reduce the execution time.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem while installing MySQL, etc.

[Terry Riley]

Thanks, Matt - I managed by unzipping it all to a new directory then 
renaming the directories so that the new one was c:\mysql and the old one 
became c:\mysql_4017, then run the mysql_fix_privilege_tables script.

Cheers
Terry

--Original Message-  

> Sharma and Terry,
> 
> I believe MySQL only supplies setup.exe files with the versions that 
> have production status. However, if you download the appropriate .zip 
> file from the website, then that will contain all the files that you 
> need. Simply extract it to the default location (C:\mysql in Windows or 
> \usr\local, I believe, in Linux). If you are upgrading, then make sure 
> you back up your old installation as to not override your data.
> 
> HTH,
> Matt
> 
> At 09:25 AM 1/7/2004, Sharma, Saurabh wrote:
> 
> >Hi
> >  I am trying to install MySQL for practice on my PC (Windows XP). I 
> > have all the administrative rights
> >I downloaded the zip file mysql-4.1.1a-alpha.zip from the downloads.
> >I extracted the zip file in a temporary folder.
> >The manual says run setup.exe for installing on Windows but I couldn't 
> >find this file in the temporary folder.
> >Can you help me on this regard
> >
> >Thanks and Regards
> >Saurabh Sharma
> >
> >Fidelity Brokerage Technology
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> At 09:43 AM 1/7/2004, Terry Riley wrote:
> >I have downloaded the correct windows zip file, but unlike previous
> >Windows downloads, this does not include a setup.exe file, but 
> hundreds of
> >other (source?) files.
> >
> >Yes, I have RTFM, which merely tells me to extract to a temporary
> >directory the run the setup.exe file, which is non-existent.
> >
> >How can I upgrade from 4.0.17, please? Or even start again from scratch
> >with 4.1.1?
> >
> >Regards



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Merge Replication

[Chris Wruck]

Can anyone tell me if mysql supports Merge Replication as per MS SQL Server?
This is a prerequisite for us considering a move

Regards 

Chris Wruck 
Pro-Ma Systems (Aust) Pty Ltd 

 

Expressing IEEE floating point NaN and Infinity

[Casey Marshall]

Hi,
I want to insert data into a floating-point column
that is NaN or +/- Infinity.  Since MySQL seems to use
IEEE floating point numbers, how can I insert and test
for these values?

Also, what is the proper string representation of NaN
and Infinity when I load data with LOAD DATA INFILE
command?

Thanks!
Casey

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting the Parent Table for Returned Columns in a Relational Search

[Ivan Cukic (Foment)]

David Hutchison wrote:

I am new to the list and glad to joining the MySQL community.

I am trying to ascertain the table to which each column in a MySQL 
record set belongs in a relational search query. There may well be 
duplicate column names across tables.

How can I query MySQL to tell me the parent table for each column in 
the record set? Thanks kindly.

dave


SELECT a.name as aname, b.name as bname FROM atable as a, btable as b 
WHERE ...;



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Certification Question

[Mike]

>I took the MySQL core certification exam on the 2nd of January and
Passed. 

Congratulations!

>I was just wondering when MySQL actually sends out the
>Certificate and other stuff they said they would send out? Does 
>anyone here have any experience with this ?

>Thanks in advance.

They do indeed, I have a nice certificate on my wall, a couple of MySQL pens in my 
drawer, some MySQL stickers on my monitor, and my daughter plays with the MySQL 
beachball (of course they may have changed the souveniers but I am sure you will get 
the certificate.

Regards,
Mike Hillyer
www.vbmysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Longtext Fields

[Ian O'Rourke]

Is there something about longtext fields I'm missing?

When I return my longtext field (the Content column of a table containing
articles - it contains HTML) and place it in a TextArea on the HTML form it
always has the first so many characters missing. If I continually edit the
article repeatedly it cuts off so much text each time.

Do I have to do something special to retrieve longtext items from the
database correctly? Or is it something to do with my HTML form (I can't
imagine so, but you never know).


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

HTML in Longtext

[Ian O'Rourke]

I seem to be having some problems regarding HTML in Longtext fields - I
think it is something to do with the fact that I have items in double quotes
in the field.

As an example, the html will have double quates along the lines of:



When I pull the field out of the database via the Application Server
(Coldfusion in this case) it displays all correctly and when I look at the
source all is well.

When I put the HTML in a Textarea for editing it cuts out text. But if I
look in the souce all the text is there, though I have double quoted items,
as above, inside my quotes for the value item of the text area?

Am I supposed to be doing something with the content of the textfield to
avoid the issue with the quotes?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting the Parent Table for Returned Columns in a Relational Search

[Roger Baklund]

* David Hutchison 
> I am trying to ascertain the table to which each column in a MySQL 
> record set belongs in a relational search query. There may well be 
> duplicate column names across tables.
> 
> How can I query MySQL to tell me the parent table for each column in 
> the record set? Thanks kindly.

I think you need aliases:

SELECT child.f1 AS childf1,parent.f1 AS parentf1  
  FROM mytable AS child, mytable AS parent 
  WHERE child.parent = parent.id

http://www.mysql.com/doc/en/SELECT.html#IDX1503 >
http://www.mysql.com/doc/en/SELECT.html#IDX1506 >
http://www.mysql.com/doc/en/SELECT.html#IDX1512 >

-- 
Roger

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: How do I do this select?

[jeremy_march]

> This will give me sort of what I am looking for, but it shows the
> UserKey in the first column and I want the UserID.  I have tried a few
> others but just got errors.

> SELECT f.UserKey, UserID FriendID, Name FriendName
> FROM User u, FriendList f
> WHERE f.FriendKey = u.UserKey
> ORDER BY f.UserKey, FriendID;

You need to join user to friendlist twice.  Try this (I don't have time to test it 
now, but it should work):

SELECT u1.UserID UserID, u2.UserID FriendID, u2.Name FriendName
FROM User u1, User u2, FriendList f
WHERE f.UserKey = u1.UserKey AND f.FriendKey = u2.UserKey
ORDER BY UserID, FriendID;



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: Getting the Parent Table for Returned Columns in a Relational Search

[jeremy_march]

Are you working from the mysql command line client?  If so you can't.  If not what 
sort of client are you working with?  There isn't much to go on from your description.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1.1 FTS 2-level?

[Sergei Golubchik]

Hi!

On Jan 11, Matt W wrote:
> Hi,
> 
> - Original Message -
> From: "Sergei Golubchik"
> To: "Steven Roussey"
> Sent: Wednesday, December 10, 2003 7:44 AM
> Subject: Re: 4.1.1 FTS 2-level?
> 
> 
> > Hi!
> >
> > On Dec 09, Steven Roussey wrote:
> > > Does Mysql 4.1.1 have the two level index system integrated into
> > > it for full text searches?
> >
> > What do you mean ?
> > Is it used to optimize searches ? No.
> >
> > Still there could be some speedup because, e.g, MyISAM will use
> > binary search in the key pages instead of linear one, etc.
>
> You're right.  Wow!
> 
> I assume you were comparing it to 4.0.x, not 4.1.0.  Once the data rows
> are cached, the index search in boolean mode seems to be about *7 times*
> faster than 4.0. :-)  2 test searches on the same data went from 48s ->
> 7 and 35 -> 5.  Nice!

Cool :)

> So are these faster index searches only the result of binary vs linear
> search?  (I don't know the exact difference, but binary sounds good.
> ;-))  The actual full-text code itself is NOT any more optimized than
> 4.0?

As far as I remember - no.

The difference is simple - if one has, say, a string or words like

 "just,simply,words,zyx"

that is, comma-separated words in alphabetic order.
Then to find a particular word one needs to compare word1 ("just") with
this particular word, then word "simply", etc. It is because words - as
a sequences of characters - may have different lengths. So the only way
to find where in the string starts the word N is to read all the words
before it.

If it's an array of, say, integers

  int array[100]

then i-th entry is simply array[i], and to find a word in a sorted array
one can use binary search.

These are two different types of pages of a btree in MyISAM index.
If an index includes variable-length segments or(and) compression is used
then different key entries on the page may have different lengths,
MyISAM will use linear search for each key page, time is linear - O(N).
(for keys starting from a char/varchar - like a fulltext index - MyISAM
uses a special variant of the linear search, that does not unpacks each
key for comparison, it's ~2-4 times faster than "normal" linear search,
but still it's linear - O(N))

Otherwise MyISAM will use binary search, time is logarithmic - O(log N)

In normal fulltext index key entry is 
In second level it's only  - and MyISAM uses binary
seacrh for the pages on the 2nd level.

> Are the 2-level indexes solely for FTS to use, or can MyISAM use them in
> general for any indexes?

Fulltext only.

> Just wondering, since you said "Is it used to
> optimize searches? No."  Which sounds like it's being used for
> *storage*, just not the word count statistics for optimization, etc.

Yes, for storage.
But it also used for word count statistics, as new there is only one
entry per word (well, for common enough words, rare words don't matter),
and this entry is the place where per-word statistics is be stored.

> And my index file was reduced from 1.74G in 4.0 to 1.59G, so I thought
> maybe this is where some space was saved.

Yes.
MyISAM does compress fulltext indexes with prefix compression.
That is for each word it stores only the difference from the previous
word on this page. If the words are identical, second entry will take
one or two bytes only (I don't remember exactly). And the first entry on
the page is always not compressed.

So, by converting all entries for some particular word to 2-level
structure saves these one-two bytes per word and
length(word)*(number_of_pages-1)

Usually - with prefix compression - one get about ~250 entries on the
page (I mean for the same common word), thus number_of_pages is,
approximately number_or_rows_with_the_word/250

> BTW, would (re)building the index be slower with 4.1 for any reason?  I
> thought maybe it was, but I'd have to try again to be sure.

I didn't compare :(

But out of my head I don't know any reason why it should be.

Regards,
Sergei

-- 
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/  www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

C API

[Morten Boenloekke Post]

Hey,

I'm currently working on a mini interface to mysql. I've been browsing through
your online documentation as well as mailing list archives but I havent been
able to find an answer there.

I was wondering if there is a way to just return a 'string' or data structure
of the result so I get output much like you do with mysqlclient.

That will make it so much easier to grab data and make it look nice and neat.

Thanks.

-- 
Morten Boenloekke Post * mortens (at) box (dot) sk

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql.sock

[Daniel Kasak]

Mike Mapsnac wrote:

What is the purpose of mysql.sock file in mysql? 
A lot of problems are assosiate with this file.
 

It keeps MySQL's feet warm :)

It's a socket, which is represented by a point on the filesystem. Local 
( ie running on the same computer ) programs can use the socket to 
communicate with MySQL.
What problem(s) are you having with it?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Automatic conversion from `char` TO `varchar`

[Michael Stassen]

Martijn Tonies wrote:

Hi,

The manual  says


The following problems are known and will be fixed in due time:
[...]
All string columns, except BLOB and TEXT columns, automatically have
all trailing spaces removed when retrieved. For CHAR types this is okay,
and may be regarded as a feature according to SQL-92. The bug is that in
MySQL Server, VARCHAR columns are treated the same way.
That seems the reverse of what you are saying.


Indeed. Nevertheless, I'm right at this one :-)
I defer to your expertise on SQL standards.  Regardless of the standard, 
however, mysql does not pad CHARs with spaces.  Thus, CHARs and VARCHARs 
are identical from the client's point of view, so silently changing 
CHARs to VARCHARs for tables with variable length rows does not affect 
the client, but does save space and time.  As I understand it, a string 
is a string in mysql.  CHAR and VARCHAR are just two string storage 
methods.  So long as that's true, mysql is doing you a favor when it 
makes this change.

Chars should be padded.
You mean according to the standard, I assume.  I am unconvinced changing 
mysql to pad CHARS at this point, at the cost of speed and compatibility 
with existing code, is a good idea.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Bug in Boolean mode fulltext searching.

[Michael Stassen]

[EMAIL PROTECTED] wrote:

Description:
	Boolean mode fulltext searching returns zero hits for valid queries. 

How-To-Repeat:
Create a database with a Text column.  Add a fulltext index on it.
Try to search for multiple words with AND or phrase syntax.
	Here are examples:

mysql> select Notice_ID from Notices where match (Text) against ('+pollution +control' 
in boolean mode);
Empty set (0.00 sec)
mysql> select Notice_ID from Notices where match (Text) against ('"pollution control"' 
in boolean mode);
Empty set (0.02 sec)
mysql> select Notice_ID from Notices where Text like '%pollution control%'; 
+---+
| Notice_ID |
+---+
|192090 |
+---+
1 row in set (5.00 sec)
Your LIKE query is not equivalent to your MATCH AGAINST.  For example, 
Text containing "pollution controls" would match LIKE '%pollution 
control%', but would not MATCH AGAINST ('+pollution +control'...).  Have 
you looked at Text for this row to be sure it contains exactly 
"pollution" and "control"?

mysql> select Notice_ID from Notices where match (Text) against ('+pollution +air' in 
boolean mode);
Empty set (0.03 sec)
mysql> select Notice_ID from Notices where match (Text) against ('"air pollution"' in 
boolean mode);
Empty set (0.00 sec)
mysql> select Notice_ID from Notices where Text like '%air pollution%';
+---+
| Notice_ID |
+---+
|196349 |
|196569 |
|188183 |
|192090 |
|192686 |
|199283 |
+---+
6 rows in set (0.17 sec)
(NOTE on the search for air -- my.cnf has ft_min_word_len=3)
Are you certain that air is indexed?  What does

  SELECT COUNT(*) FROM Notices WHERE MATCH (Text) AGAINST ('air');

return?

All OR searches work perfectly fine, as per:

mysql> select count(*) from Notices where match (Text) against ('air pollution');
+--+
| count(*) |
+--+
|  100 |
+--+
1 row in set (0.03 sec)
How many do you get with

  SELECT COUNT(*) FROM Notices WHERE MATCH (Text) AGAINST ('pollution');

If air isn't indexed, I'd expect 0 hits for 'air' and 100 hits for 
'pollution'.

These are not overly common words:

mysql> select count(*) from Notices;
+--+
| count(*) |
+--+
|11990 |
+--+
1 row in set (0.00 sec)

Fix:
Use a WHERE text-column LIKE "%phrase%"  for phrase searching.
No known workaround for AND searches.

Submitter-Id:   
Originator: Joe Rhett
Organization:   
	Isite Services, Inc.

MySQL support: none
Synopsis:   Boolean mode fulltext searching fails.
Severity:   serious
Priority:   high
Category:   mysql
Class:  sw-bug
Release:mysql-4.0.16 (Source distribution)


C compiler:2.95.3
C++ compiler:  2.95.3
Environment:

System: SunOS web031 5.8 Generic_108529-23 i86pc i386 i86pc
Architecture: i86pc
Some paths:  /usr/bin/perl

Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx   1 root root  11 Sep 15 18:17 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 root bin   956112 Jul 29 20:10 /lib/libc.so.1
lrwxrwxrwx   1 root root  11 Sep 15 18:17 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 root bin   956112 Jul 29 20:10 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/opt/mysql' '--localstatedir=/var/mysql' '--without-debug'




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting the Parent Table for Returned Columns in a Relational Search

[David Hutchison]

Dear all,

I am trying to ascertain the table to which each column in a MySQL
record set belongs in a relational search query. There may well be
duplicate column names across tables.
How can I query MySQL to tell me the parent table for each column in
the record set? Thanks kindly.
I think you need aliases:

SELECT child.f1 AS childf1,parent.f1 AS parentf1
  FROM mytable AS child, mytable AS parent
  WHERE child.parent = parent.id
Thank kindly for the help. Unfortunately, this won't do it because I 
cannot count on my users to use aliases. Rather, I was hoping that the 
"explain select" syntax would list the parent table for each column in 
a returned record set.

Any further thoughts anybody?

Regards,
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql.sock

[Mike Mapsnac]

What is the purpose of mysql.sock file in mysql? 
A lot of problems are assosiate with this file.

Re: Certification Question

[Amanullah]

Hi bernard,

Thanks for your swift information on this..

-Aman.

Bernard Clement wrote:

Hello Aman,

For instructions on taking the exam in India goto the URL: 
http://www.vue.com/mysql/ and click on "test center" of "To register for exams 
in India, please contact the test center directly.  This will bring you a 
window containing all the Pearson VUE Test Center in India.

Good luck!

Bernard

On Friday 09 January 2004 22:29, Amanullah wrote:
 

I'm also interested to take up the certification exam on Mysql,
pl. guide me how to proceed to get certification on the same,
I'm in India (chennai).
-aman.

Arjun Subramanian wrote:
   

I took the MySQL core certification exam on the 2nd of January and
Passed. I was just wondering when MySQL actually sends out the
Certificate and other stuff they said they would send out? Does anyone
here have any experience with this ?
Thanks in advance.

Arjun Subramanian
Georgia Tech Station 32003
Atlanta GA 30332
Cell: +404.429.5513
http://www.arjunweb.com
-Original Message-
 

From: Amanullah [mailto:[EMAIL PROTECTED]

   

Sent: Friday, January 09, 2004 10:03 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: New INstall of MySQL
Hi,

make sure the existing directories has been removed fully, then continue

with
new installation, after installation is over, pl. restart the system, if
mysql daemon
has not started, pl. go to ..\mysql\bin\ directory & run
winmysqladmin.exe.
mysql service will be strated to work..

-Aman.

Chris L. White wrote:
 

Ok I have a question.   This is the first time any of us here in our
   

office

 

have installed MySQL or for that fact worked with MySQL.  So I got
   

stuck

 

with trying to figure it out.  Ok here is the problem.  I completely
   

removed

 

the previous MYSQL installation attempt.  I started new to install
   

MYSQL.  I

 

go to setup and run the setup and the status bar does not move much and
   

the

 

installation takes about 5 seconds and then it is done.  I get to the
finished installing screen, but there are no options to choose from
   

like the

 

test in the screen says there should.  Also I have a my.cnf and ny.ini
   

file

 

in the proper places and I still have nothing going.  I am confused and
   

the

 

manual I am finding is not clear enough on this.  I included what the
   

my.cnf

 

and my.ini file looks like.  And also included the error I am getting
   

after

 

installation.  Also after MYSQL is installed should there not be some
   

icons

 

for things related to it, because I don't even have them.  I am trying
   

to

 

install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP
installed.  Please help.


[mysqld]

# set basedir to your installation path

# basedir=C:/mysql

# set datadir to the location of your data directory

#datadir=C:/SQLData



# Example mysql config file.

# Copy this file to c:\my.cnf to set global options

#

# One can use all long options that the program supports.

# Run the program with --help to get a list of available options



# This will be passed to all mysql clients

[client]

#password=my_password

port=3306

#socket=MySQL



# Here is entries for some specific programs

# The following values assume you have at least 32M ram



# The MySQL server

[mysqld]

port=3306

#socket=MySQL

skip-locking

set-variable  = key_buffer=16M

set-variable  = max_allowed_packet=1M

set-variable  = table_cache=64

set-variable  = sort_buffer=512K

set-variable  = net_buffer_length=8K

set-variable  = myisam_sort_buffer_size=8M

server-id   = 1



# Uncomment the following if you want to log updates

log-bin



# Uncomment the following rows if you move the MySQL distribution to
   

another

 

# location

basedir = c:/mysql/

datadir = c:/SQLData





# Uncomment the following if you are NOT using BDB tables

skip-bdb



# Uncomment the following if you are using BDB tables

#set-variable = bdb_cache_size=4M

#set-variable = bdb_max_lock=1



# Uncomment the following if you are using Innobase tables

#innodb_data_file_path = ibdata1:400M

#innodb_data_home_dir = c:\ibdata

#innodb_log_group_home_dir = c:\iblogs

#innodb_log_arch_dir = c:\iblogs

#set-variable = innodb_mirrored_log_groups=1

#set-variable = innodb_log_files_in_group=3

#set-variable = innodb_log_file_size=5M

#set-variable = innodb_log_buffer_size=8M

#innodb_flush_log_at_trx_commit=1

#innodb_log_archive=0

#set-variable = innodb_buffer_pool_size=16M

#set-variable = innodb_additional_mem_pool_size=2M

#set-variable = innodb_file_io_threads=4

#set-variable = innodb_lock_wait_timeout=50



[mysqldump]

quick

set-variable  = max_allowed_packet=16M



[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates



[isamchk]

set-v

How do I do this select?

[Chris W]

I have the following 2 tables.

CREATE TABLE User (
  UserKey   INT NOT NULL AUTO_INCREMENT,
  UserIDCHAR(16) NOT NULL UNIQUE ,
  Name  VARCHAR(20),
  PRIMARY KEY (UserKey)
);
CREATE TABLE FriendList(
  UserKey INT NOT NULL,
  FriendKey   INT NOT NULL,
  PRIMARY KEY (UserKey, FriendKey)
);
The second table is a many to many relationship table.  I want to select
 every row from FriendList and link it to user so the out put looks
something like this.
UserID   FriendID  FriendName
ax x-name
ay y-name
az z-name
ba a-name
bc c-name
bz z-name
cb b-name
cx x-name
This will give me sort of what I am looking for, but it shows the
UserKey in the first column and I want the UserID.  I have tried a few
others but just got errors.
SELECT f.UserKey, UserID FriendID, Name FriendName
FROM User u, FriendList f
WHERE f.FriendKey = u.UserKey
ORDER BY f.UserKey, FriendID;






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How do I do this select?

[Chris W]

I have the following 2 tables.

CREATE TABLE User (
  UserKey   INT NOT NULL AUTO_INCREMENT,
  UserIDCHAR(16) NOT NULL UNIQUE ,
  Name  VARCHAR(20),
  PRIMARY KEY (UserKey)
);
CREATE TABLE FriendList(
  UserKey INT NOT NULL,
  FriendKey   INT NOT NULL,
  PRIMARY KEY (UserKey, FriendKey)
);
The second table is a many to many relationship table.  I want to select 
 every row from FriendList and link it to user so the out put looks 
something like this.

UserID   FriendID  FriendName
ax x-name
ay y-name
az z-name
ba a-name
bc c-name
bz z-name
cb b-name
cx x-name
This will give me sort of what I am looking for, but it shows the 
UserKey in the first column and I want the UserID.  I have tried a few 
others but just got errors.

SELECT f.UserKey, UserID FriendID, Name FriendName
FROM User u, FriendList f
WHERE f.FriendKey = u.UserKey
ORDER BY f.UserKey, FriendID;




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]