Popular "mysql" questions | Page 127

MySQL Great Circle Distance (Haversine formula)

I've got a working PHP script that gets Longitude and Latitude values and then inputs them into a MySQL query. …

php mysql great-circle

MySQL - DATE_ADD month interval

I face a problem with the function DATE_ADD in MySQL. My request looks like this : SELECT * FROM mydb WHERE …

mysql sql select dateadd

MySql sum elements of a column

I have a table with 3 columns (A,B,C). I want to select some rows from the table and then …

mysql sum

Does MySQL ignore null values on unique constraints?

I have an email column that I want to be unique. But I also want it to accept null values. …

mysql database unique-constraint

#1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'

Hopefully someone can help me, for I have queried the web with no success or concrete answer to this error. …

mysql phpmyadmin

SELECT last id, without INSERT

I'm trying to retrieve the id of one table A to insert into another table B. I cannot use last_…

mysql lastinsertid

the MySQL service on local computer started and then stopped

the MySQL service on local computer started and then stopped. Some services stop automatically if they are not in use …

mysql service window

Found 'OR 1=1/* sql injection in my newsletter database

I found the following in the "e-mail" field of my newsletter subscriber database: ' OR 1=1/* I know it's a SQL …

mysql security sql-injection

How to close this ssh tunnel?

I opened a ssh tunnel as described in this post: Zend_Db: How to connect to a MySQL database over …

mysql macos ubuntu ssh

MySQL Multiple Where Clause

I have a table like this: id image_id style_id style_value ----------------------------------- 1 45 24 red 1 45 25 big 1 47 26 small 1 45 27 round 1 49 28 rect I …

mysql sql where-clause

Top "Mysql" questions