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. I'd like to make it solely MySQL. Here's my current PHP Code: if ($distance != "Any"...

MySQL Query Browser How do I enter NULL?

Stupid question: In SQL, I know I can do UPDATE TableA SET MyColumn=NULL But, how do I enter NULL into a cell graphically? I tried entering 'null' and 'NULL' and '' (nothing/empty string) into...

How does MySQL Auto Increment work?

I was just creating a new table using MySQL Query Browser, and noticed there's a tick under Auto Increment Column. How does that work? When adding to the database programatically, do I just add a...

How do I load content from a PHP file (and executing the script) from another PHP file?

I have a PHP script (index.php) that changes the page shown depending on the query part of the URL (using GET). All the links in the page access different "pages" using ?page=pageName and the...

How to implement a paginator that doesn't call count(*)

I am working on a django website that has a MySQL innodb backend. We have hundreds of thousands of records in several of our tables and this is causing some site stability/performance issues in...

How to change max_allowed_packet size

I am having a problem with BLOB fields in my MySQL database - when uploading files larger than approx 1MB I get an error Packets larger than max_allowed_packet are not allowed. Here is what i've...

Java-mysql highload application crash

I have a problem with my html-scraper. Html-scraper is multithreading application written on Java using HtmlUnit, by default it run with 128 threads. Shortly, it works as follows: it takes a site...

Unable to import a database through phpMyAdmin

I am trying to import a database into MySql using phpMyadmin. It is in the form of an sql. But after i create a new database and try to import the sql in it, the browser goes into the busy mode...

Remote connect to clearDB heroku database

How can i perform a remote connect to ClearDB MySQL database on heroku using for example MySQL Query Browser. Where to get url, port, login and password?

How to retrieve records from past weeks in django

I am having trouble in django on how to retrieve data from last week (not 7 days ago). Using date.isocalendar()[1] would be great. However Some stackoverflow browsing lead me to no satisfactory...

Copy selected query fields name in Mysql Workbench

I am using mysql workbench (SQL Editor). I need copy the list of columns in each query as was existed in Mysql Query Browser. For example Select * From tb I want have the list of fields like as: ...

How to export data to an excel file using PHPExcel

I have taken the source code from limesurvey and have added the PHPExcel library to my limesurvey code to export data to an excel file after you click a link. Currently the excel file opens with...

Connection for controluser as defined in your configuration failed. on iis7.5

i have installed the phpmyadmin on iis7.5 server8 my config.inc.php is ` /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * phpMyAdmin sample configuration, you can use it as base for * manual...

phpMyAdmin reports incorrect query time

MySQL 5.5 I am trying improve speed on this query: SELECT * FROM `core_table` WHERE `id` = '57' AND `model` IN (SELECT `new_models` FROM `raw_table`) I tried to benchmark it in phpMyAdmin by...

PHP Zip file download issue

I know this question has been asked several times in here and I have used so many of the suggestions here but none of them work for me. My Application first creates a list of Feeds and then the...

Importing CSV data using PHP/MySQL - Mysqli syntax

IN THE BOTTOM OF THIS QUESTION THE FINAL CODE THAT FINALLY WORKED! Trying to implement this (https://stackoverflow.com/questions/11448307/importing-csv-data-using-php-mysql). I must be almost...

DBAL Connection query() function and SELECT FOR UPDATE, LOCK

I'm trying to do a 'SELECT FOR UPDATE' query in mysql using the DBAL connection query function. I'm in a symfony project and I made the following test : I have this two functions in my controller...

Unable to retrieve UTF-8 accented characters from Access via PDO_ODBC

I am trying to get an Access DB converted into MySQL. Everything works perfectly, expect for one big monkey wrench... If the access db has any non standard characters, it wont work. My query will...

phpmyadmin error processing request 200

I changed my Wamp's phpmyadmin config.inc.php file few days ago for auto authentication. Phpmyadmin was working fine but now whenever I click anywhere in phpmyadmin it's giving me this error in...

PhpMyAdmin & MAMP : internal relations missing

I have installed MAMP on two computers (Mac OS X.10.5). I have created the pmadb's using the supplied create_tables.sql On one computer, when I open "Relation view", there is only the "foreign key...

Making xampp and node(socket.io) work together

I have a little web app which applies some AngularJS and php for some functions and some queries from the database(xampp's Apache and mySQL). Now I want to apply to a simple chat in the web app...

Java EE, Hibernate, MySql UTF-8 query doesn't work

So I have set up hibernate with Wildfly and MySql. Querying works, but have problem querying UTF-8 character names. On MySql: SELECT * FROM users WHERE firstname = "ნიკა"; Doesn't result...

JavaScript heap out of memory in Angular 7 using Azure DevOps

I am getting FATAL ERROR: CALL_AND_RETRY_LAST Allocation failed - JavaScript heap out of memory after Angular 7.1 upgrade. The previous version 6.1 was working perfectly fine. I get the error only...

Replacing content of block after generating clones using cloneBlock - PHPWord

Please can somebody be so kind to show me the syntax for using cloneblock in phpword. So Ive got data in a MySQL DB, and for the single rows that I need to import into my word doc via phpword it...

Best way to query nested relationships in Laravel/Eloquent

I have built an application with Laravel where I end up having rather deep-nested relationships, that I sometimes need to query. Database is MySQL. For instance, I want to retrieve all Users who...

How to combine REDIS and MySQL for mass INSERT to get better performances (Real Time)

I have to INSERT around 1000 rows each second to MySQL database, since for each visitor i have to add the IP, Browser and Country to a specific Table for a statistics need. Inserting the visits...

NodeJs, if statements inside connection.query

i am a c# guy trying to create a login page using in react, node and mysql. i have a doubt that can i write 'if statements inside connection.query'. Below is the code snippet i am using. When i am...

Elasticsearch "_cat/indices" api update delayed until search?

Elasticsearch (v7.9.2) got an api _cat/indices to show index status, the last change made to docs.count seems not visiable, until a search or another update is made. Is this behaior for the...

How to connect JDBC connector to AWS Athena Federated queries?

I want to query Aurora MySQL database from Athena using Federated queries. As I understand I need to find JDBC connector in Serverless Application Repository service and then follow this...

Critical error when installing Wordpress through XAMPP locally?

I want to install Wordpress Locally with XAMPP but run into a critical error during the second step of the installation. I'm following the easy steps on this guide. As you can see here, I've made...