Browse Moodle Solutions

I currently have just under a million locations in a mysql database all with longitude and latitude information. I am trying to find the distance between one...

Having a table with a column like: `mydate DATETIME` ... I have a query such as: SELECT SUM(foo), mydate FROM a_table GROUP BY a_table.mydate; This...

I have a table called `provider`. I have three columns called `person`, `place`, `thing`. There can be duplicate persons, duplicate places, and duplicate things...

Is there a way in a MySQL statement to order records (through a date stamp) by >= NOW() -1 so all records from the day before today to the future are selecte...

I'm trying to follow along [this tutorial](http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html) to enable remote acces...

I am trying to optimize one part of my code that inserts data into MySQL. Should I chain INSERTs to make one huge multiple-row INSERT or are multiple separate I...

There are many conflicting statements around. What is the best way to get the row count using PDO in PHP? Before using PDO, I just simply used `mysql_num_rows`....

I need to change my column type from date to datetime for an app I am making. I don't care about the data as its still being developed. How can I do this...

I'm stumped, I don't know how to go about doing this. Basically I just want to create a table, but if it exists it needs to be dropped and re-created...

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no pri...

Why do you need to place columns you create yourself (for example `select 1 as "number"`) after `HAVING` and not `WHERE` in MySQL? And are there an...

I got the following error while trying to alter a column's data type and setting a new default value: ALTER TABLE foobar_data ALTER COLUMN col VARCHA...

I tried to search posts, but I only found solutions for SQL Server/Access. I need a solution in MySQL (5.X). I have a table (called history) with 3 columns:...

Are JOIN queries faster than several queries? (You run your main query, and then you run many other SELECTs based on the results from your main query) I'...

I have a table with a unique key for two columns: CREATE TABLE `xpo`.`user_permanent_gift` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `fb_u...

I have an SQL table called "posts" that looks like this: id | category ----------------------- 1 | 3 2 | 1 3 | 4 4...

I am getting this error in [WordPress][1]' phpMyAdmin: #145 - Table './DB_NAME/wp_posts' is marked as crashed and should be repaired When...

I'm getting a 1022 error regarding duplicate keys on create table command. Having looked at the query, I can't understand where the duplication is takin...

How to set multiple columns of a table using update query in mysql?

I'm currently creating a Login form and have this code: string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"...