Search found 95 matches

by sebs
Tue Nov 29, 2005 7:14 am
Forum: Databases
Topic: UNION
Replies: 3
Views: 718

The 2 querys I am making are almoust the same.The querys are big.Depends how?If you know?Thanks!
by sebs
Tue Nov 29, 2005 6:27 am
Forum: Databases
Topic: UNION
Replies: 3
Views: 718

UNION

If I make a union on 2 tables works slower then making a single select on those 2 tables united?
by sebs
Fri Nov 25, 2005 7:26 am
Forum: Databases
Topic: sql search
Replies: 2
Views: 633

Thanks!
by sebs
Fri Nov 25, 2005 6:41 am
Forum: Databases
Topic: sql search
Replies: 2
Views: 633

sql search

I have a field in which the user enters some text.If the user enters Bulevard London it finds the results but if he enters London Bulevard it doesn't find anything because in the database I have Bulevard London(example) and not London Bulevard.How can I make an sql query that searches for the words ...
by sebs
Fri Nov 04, 2005 9:19 am
Forum: Databases
Topic: foreign key
Replies: 3
Views: 642

i WILL use join but for the join to work faster?IDm is not primary key.Instead of making a index on ID and IDm can I write something like IDm has foreign key ID?
by sebs
Fri Nov 04, 2005 7:13 am
Forum: Databases
Topic: foreign key
Replies: 3
Views: 642

foreign key

I have ID in table1 and IDm in table2,ID is primary key in it's table.Is there anyway I can make a relation between those 2 keys so the compare between them works faster(foreign key or...)?
by sebs
Thu Nov 03, 2005 7:19 am
Forum: Databases
Topic: query help
Replies: 2
Views: 902

simple!I should figgered that out by myself but I was blind and maybe sometimes outside help is great!Thanks..
by sebs
Thu Nov 03, 2005 7:03 am
Forum: Databases
Topic: query help
Replies: 2
Views: 902

query help

I have in table "TEL" all telefones,names,adresses,City,Region ->many fields inserted in it I want to move distinct City and Region in another table "Region". can you help m with the select query? it should be something like this but don't work: insert into Region(City,Region) va...
by sebs
Mon Oct 31, 2005 9:31 am
Forum: PHPDN Suggestions
Topic: reputation
Replies: 9
Views: 8003

reputation

You could put a reputation on every user.This way if somebody is very satisfied of the answers he receives he can increase the reputation to the one that answered by one.
by sebs
Fri Oct 28, 2005 7:48 am
Forum: Databases
Topic: subquery
Replies: 14
Views: 1488

Thanks guys,your great!It's working how you told me but it's not as fast as I wanted with a subquery.I will see what I will do be faster!
by sebs
Fri Oct 28, 2005 7:18 am
Forum: Databases
Topic: subquery
Replies: 14
Views: 1488

Inner join does not help me so much because it's too slow.I make the same number of comparison as if I the second table had it's fields in the first table.
by sebs
Fri Oct 28, 2005 7:05 am
Forum: Databases
Topic: subquery
Replies: 14
Views: 1488

I will try what you told me!
by sebs
Fri Oct 28, 2005 6:55 am
Forum: Databases
Topic: subquery
Replies: 14
Views: 1488

I am sure that this is the version.Thank you for taking time to consider my question.The only way is to change th version of mysql?
by sebs
Fri Oct 28, 2005 6:50 am
Forum: Databases
Topic: subquery
Replies: 14
Views: 1488

The version I have is 3.23.58!Is there anyway I could change the subquery to integrated in the main query?
by sebs
Fri Oct 28, 2005 6:40 am
Forum: Databases
Topic: subquery
Replies: 14
Views: 1488

CLient Api version 3.23.58