Top "Mysql" questions

Storing Data in MySQL as JSON

I thought this was a n00b thing to do. And, so, I've never done it. Then I saw that …

mysql json database

How to regex in a MySQL query

I have a simple task where I need to search a record starting with string characters and a single digit …

mysql sql regex innodb

What MySQL data type should be used for Latitude/Longitude with 8 decimal places?

I'm working with map data, and the Latitude/Longitude extends to 8 decimal places. For example: Latitude 40.71727401 Longitude -74.00898606 I saw …

mysql types floating-point

Using column alias in WHERE clause of MySQL query produces an error

The query I'm running is as follows, however I'm getting this error: #1054 - Unknown column 'guaranteed_postcode' in 'IN/ALL/…

mysql sql mysql-error-1054

Fastest Way to Find Distance Between Two Lat/Long Points

I currently have just under a million locations in a mysql database all with longitude and latitude information. I am …

mysql location gis

How do MySQL indexes work?

I am really interested in how MySQL indexes work, more specifically, how can they return the data requested without scanning …

mysql indexing

SQL DELETE with INNER JOIN

There are 2 tables, spawnlist and npc, and I need to delete data from spawnlsit. npc_templateid = n.idTemplate is the …

mysql sql sql-server inner-join sql-delete

Saving timestamp in mysql table using php

I have a field in a MySQL table which has a timestamp data type. I am saving data into that …

php mysql database sql-insert

MySQL compare DATE string with string from DATETIME field

I have a question: Is it possible to select from a MySQL database by comparing one DATE string "2010-04-29" …

mysql datetime comparison

mysql is not recognised as an internal or external command,operable program or batch

I had set the MySQL path, but still getting the same error. Please let me know whether I followed the …

mysql mysql-error-1064