How do I do this select?

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,

How do I do this select?

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,

Re: Certification Question

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

mysql.sock

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

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

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

Re: Bug in Boolean mode fulltext searching.

[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

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

Martijn Tonies wrote: Hi, The manual http://www.mysql.com/doc/en/Open_bugs.html 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

Re: mysql.sock

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

C API

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

Re: 4.1.1 FTS 2-level?

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

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

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:

re: How do I do this select?

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

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

* 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

HTML in Longtext

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: p class=articletxt When I pull the field out of the database via

Longtext Fields

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

Re: Certification Question

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

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

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

Expressing IEEE floating point NaN and Infinity

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?

Merge Replication

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

Re: Problem while installing MySQL, etc.

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

Query takes 1703.57 sec

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 ,

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 ,

RE: Query takes 1703.57 sec

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:

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

Re: Can't create/write to file

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