Re: Join question

Hi, what is the difference between your way and Mike Hillyer way?? (I can see the INNER join). But thanx to both of you. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql language

Hi, I was looking in what language what myslq written in? Just curious Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Join question

Hi, I have posted a similar question, but can't find the answers. I'm sorry. What i'm trying to do is that i have 3 tables each has three columns and are indexed. so I want to do something like select everything in 3 tables and display only similar id. Select id from table1 where table1.cl1 = 1

load file

Hi, I have a a text file delimited with | and I don't how to load the data into a table and say delimited by '|' I think it is this: LOAD DATA INFILE 'C:\data.txt' INTO TABLE table2 FIELDS TERMINATED BY '|'l Any clarification would help. Anthony -- MySQL General Mailing List For list archiv

good or bad?

Hi, going to back to the thread of best SQL statment i did: this EXPLAIN SELECT * FROM `zip` WHERE longitude BETWEEN - 98.315 AND - 94.662 AND latitude BETWEEN 31.696 AND 34.587 AND 3963 * acos( cos( latitude ) * cos( 33.1414 ) + sin( latitude ) * sin( 33.1414 ) * cos( - 96.5883 - longitude )

Re: efficient query or not?

Hi, ok thank you, If i do the following SELECT userid FROM location WHERE longitude BETWEEN -80 and -94 AND latitude BETWEEN 30 and 49 AND 3963 * acos(cos(radian(90-place.lat)) * cos(radians(90-mylat)) + sin(radians(90-place.lat)) * sin(radians(90-mylat)) * cos(radians(place.lon-mylon))) < 100

Re: efficient query or not?

Hi, You mention this SELECT loc1.name, loc1.lat, loc1.lon, loc2.name, loc2.lat, loc2.lon, 3963 * acos(cos(radians(90-loc1.lat)) * cos(radians(90-loc2.lat)) + sin(radians(90-loc1.lat)) * sin(radians(90-loc2.lat)) * cos(radians(loc1.lon-loc2.lon))) AS Miles FROM locations AS loc1 INNER

efficient query or not?

Hi, I need to calculate distance from a point and for the select statment I have this SELECT userid FROM place WHERE acos( cos($longitude) * cos($latitude) * cos(place.latitude) *cos(place.longitude) +cos($longitude) * sin($latitude) * cos(place.latitude) * sin(place.longitude) +sin($longitude) *

IN function

Hi, I have written a program that creates statments for me, and sometimes I end with SELECT..WHERE number IN(1) instead of SELECT... WHERE number IN(1,2,3,4) would number IN(1) works, for the moment i have no mean to test it, it is why i'm asking. Regards, Anthony -- MySQL General Mailing

Row Number

Hi, If i have a table with just "Userid,Name,Language" where userid is primary key. now if i search the first 10 people that speaks english i.e SELECT * FROM tablex WHERE language='English' LIMIT 10; Can't i get the row number of the last matched record? So i can do SELECT...LIMIT nex

Re: Advice on improving our current method

Hi, I'm not to familiar with MySQL, but as far as I can seem, you might want to look at programming. I.e a program in C++ or Perl, or Visual Basic. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select Statment Question

Hi, I have to search a big database. Now there are many categories i.e computerlanguage = C++, Perl,Php,Visual Basic, C, Javascript. In my table C++ =1 Perl = 2 PhP = 3 VB = 4 C = 5 Java = 6 and i have a select statment like this SELECT * FROM lang WHERE language = 1 OR language = 2 OR language