Browse Moodle Solutions

Is it possible to do `mysqldump` by single `SQL query`? I mean to dump the **whole** database, like `phpmyadmin` does when you do export to `SQL`

Can't find anything relevant about Entity Framework/MySQL on Google so I'm hoping someone knows about it.

I have following data in my table "devices" affiliate_name affiliate_location model ip os_type os_version cs1...

I am using MySQL and MySQL Workbench 5.2 CE. When I try to concatenate 2 columns, `last_name` and `first_name`, it doesn't work : select first_name +...

Anyone know a quick easy way to migrate a SQLite3 database to MySQL?

ID FirstName LastName 1 John Doe 2 Bugs Bunny 3 John Johnson I want to select `DISTINCT` resul...

I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did this next: 1. Launch the terminal app to access the Unix comma...

Is there a fast way of getting all column names from all tables in `MySQL`, without having to list all the tables?

I have a SQL query where I want to insert multiple rows in single query. so I used something like: $sql = "INSERT INTO beautiful (name, age)...

Currently I am having the following MySQL table: `Employees (empID, empName, department);` I want to change the table to the following: `Employees (empID, de...

This is a much discussed issue for OSX 10.6 users, but I haven't been able to find a solution that works. Here's my setup: Python 2.6.1 64bit Django...

I have a large number of rows that I would like to copy, but I need to change one field. I can select the rows that I want to copy: select * from Tabl...

I installed MySQL via [MacPorts][1]. What is the command I need to stop the server (I need to test how my application behave when MySQL is dead)? [1]: http...

**Error Code: 2013. Lost connection to MySQL server during query** I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total...

I'm looking to be able to run a single query on a remote server in a scripted task. For example, intuitively, I would imagine it would go something like:...

How can I `SELECT` the last row in a MySQL table? I'm `INSERT`ing data and I need to retrieve a column value from the previous row. There's an `au...

I have a table like this: TITLE | DESCRIPTION ---------------|-------------------------------- test1 | value blah blah value test2...

I'm having a bit of a strange problem. I'm trying to add a foreign key to one table that references another, but it is failing for some reason. With my...

I want to remove the password for user root in localhost. How can I do that? By mistake I have set the password of root user. That's why phpmyadmin is givin...

I know how to use INDEX as in the following code. And I know how to use *foreign key* and *primary key*. ```mysql CREATE TABLE tasks ( task_id...