comma-separated keys?

hi list, this is one of these faq-questions (for sql queries) nowhere found. normally two tables are joined by two singular keys, for instance "id" which is (1) in both tables. But how do I join them over a id-field like this:(1,2,4)? I know, there is the WHERE id IN(...) function, but if I do a:

Re: Surrounding Rows

But now I think it's the only way. jan - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Jan Peuker" <[EMAIL PROTECTED]> Cc: "Gurhan Ozen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 11:35

Re: Surrounding Rows

very safe. Thanks a lot, jan - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Jan Peuker" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 7:39 PM Subject: Re: Surrounding Rows > Hi, > Can you please explain

Surrounding Rows

Hi list, A nut to crack: I have a medium-sized database(about 1000 rows). The keys contain zip-address-information. Now I want to get the surrounding persons, e.g. someone has zip 12345 I would get(now for 4 entries): +---+--+ | 12340 | personA | | 12345 | personB | <-- I searched

MyISAM internal algorithms

nary-sorted-Trees or Tries. Do you have any short description of this for me? Thanks a lot, Jan Peuker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

FullText Search 3.23.49-nt

Good evening List, I have a problem on my fulltext-search. If I create the sample table from MySQL-Doc it runs perfect. If I create my own - it doesn't. I can't say more: Here is my dump: CREATE TABLE tcl (id int(10) primary key not null, description varchar(254), date timestamp, value int(11),

Re: query problem

Uhm, 3? Didn't you wrote 5? If you want just 3 do this: SELECT name,date FROM dates ORDER BY date LIMIT 0,3 regars, Jan - Original Message - From: "saraswathy saras" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 8:12 AM Subject: query problem > hi everyboby

Re: What is the best way to do this

values enclosed by % % as patterns and do this: select row from table2,table3 where fields-m like table3.patterns; This should work, regards Jan - Original Message - From: "Javier" <[EMAIL PROTECTED]> To: "Jan Peuker" <[EMAIL PROTECTED]> Sent: Monday, April 29,

Re: Can't start mysql-service on Win XP

Hi Sabine (again ;-) ) I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html This could be problems w/ your path or your my.ini (overwritten my mysqladmin). If it won't start anyway, put mysqladmin.exe to your autostart. regards, (Grüße) Jan - Original Message -

Dynamic $table in SELECT?

Here is another question;-) Is there any ability to put tables dynamic in a query? I have to do a select * for many tables and it would be cool if I just do something like this select * from (select t from mytables). Thanks a lot, Jan ---

Re: Performance Select Table/Where

Hi Alec, thanks for this answer. a) My column is not involved by query b) But it is necessary to hold it in the database (and I don't want to set file_priv) c) And it's as long as a whole document, this means 5-10K I think, a Primary Key is as good as an Index. I will use one table for every type

Re: Performance Select Table/Where

That's the point: Users are added about 10 times less than "objects". But your objection about new columns is right, also about system performance. I would have said the main problem is on a query like "show all users with their last object" for an overview, this would be a very hard job (I think

Performance Select Table/Where

My first two questions could not be answered, so, maybe I'll be luck w/ third. A performance question: If I have user numbers and "objects" belonging to them(e.g.bills), is it better to have one table "bills" with many rows or to have one table for every user? This means, is it better to do a sql

Re: (Newbie) Apachie->PHP->MySql

You have to update your seession-path in your php.ini (usually located in %%systemroot%% eg windows) to a valid windows-path like c:\windows\temp Jan - Original Message - From: "r" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 11:19 AM Subject: (Newbie) Apac

SET row dynamic?

Short question: Is there a way to update SET-options without alter table? e.g. if one user is registered in table1 he is allowed(means registered in set-row options) to write his id into table2 ? Thanks, Jan P.S.: For the filter: I want to do a sql query which does something. -

Re: Date function

I never saw the function "date()", to insert current date use: CURRENT_DATE(); regards, Jan - Original Message - From: "Alia Mikati" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 11:27 AM Subject: Date function > Hello > I have the following SQL and I wanna

Re: SELECT the first letter MATCH in mySQL

There is a method using trim() but I think it's better to use RLIKE "^A.*" regards, Jan Peuker - Original Message - From: "Son Nguyen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 8:42 AM Subject: SELECT the first lette

SQL-Statement "Near"

Hi List, I am using MySQL MAX 3.23 on a SuSE Linux System. But my problem is about SQL: Is there a "in the near of my result" statement that returns the surrounding rows, e.g. SELECT name FROM names WHERE name="foo" NEAR(-2,2) which results: ann marie foo bar john? I know, if my keys would be inc

Re: Help! With sql date type

A timestamp-datatype automatically updates itself with the current date if the row has changed, so, in this case timestamp is not the preferred datatype. As far as i know, in MySQL Procedures are just for output, Triggers are not implemented...Only method would be to insert this field using insert