I have latitude and longitude and I want to pull the record from the database, which has nearest latitude and longitude by the distance, if that distance gets longer than specified one, then don’t retrieve it. Table structure: id latitude longitude place name city country state zip sealevel 18 Answers 18
I am wondering if there is any difference with regards to performance between the following SELECT … FROM … WHERE someFIELD IN(1,2,3,4) SELECT … FROM … WHERE someFIELD between 0 AND 5 SELECT … FROM … WHERE someFIELD = 1 OR someFIELD = 2 OR someFIELD = 3 … or will MySQL optimize the SQL … Read more
I need to delete all rows from a table but when I add a new row, I want the primary key ID, which has an auto increment, to start again from 0 respectively from 1. 5 Answers 5
This question already has answers here: How can I make SQL case sensitive string comparison on MySQL? (12 answers) Closed 3 years ago. This has been asked on this site before but I couldn’t find a sufficient answer. If I’m doing a query like: Select Seller from Table where Location = ‘San Jose’ How can … Read more
Is there a way to detect if a value is a number in a MySQL query? Such as SELECT * FROM myTable WHERE isANumber(col1) = true 15 Answers 15
I installed mySQL on my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preferences, I want to know the instructions to start from command-line. I do as follows: After su root I start the mySQL server by command-line, but it produces an error as below: sh-3.2# /usr/local/mysql/bin/mysqld 111028 16:57:43 [Warning] Setting … Read more
Well here’s my problem I have three tables; regions, countries, states. Countries can be inside of regions, states can be inside of regions. Regions are the top of the food chain. Now I’m adding a popular_areas table with two columns; region_id and popular_place_id. Is it possible to make popular_place_id be a foreign key to either … Read more
Are table names in MySQL case sensitive? On my Windows development machine the code I have is able to query my tables which appear to be all lowercase. When I deploy to the test server in our datacenter the table names appear to start with an uppercase letter. The servers we use are all on … Read more
Is there a way to check if a table exists without selecting and checking values from it? That is, I know I can go SELECT testcol FROM testtable and check the count of fields returned, but it seems there must be a more direct / elegant way to do it. 19 Answers 19
If you try to create a TEXT column on a table, and give it a default value in MySQL, you get an error (on Windows at least). I cannot see any reason why a text column should not have a default value. No explanation is given by the MySQL documentation. It seems illogical to me … Read more
