Browse Moodle Solutions

I knew boolean in mysql as `tinyint (1)`. Today I see a table with defined an integer like `tinyint(2)`, and also others like `int(4)`, `int(6)` ... What...

I need to ALTER my existing database to add a column. Consequently I also want to update the UNIQUE field to encompass that new column. I'm trying to remove...

I am doing `SELECT GROUP_CONCAT(categories SEPARATOR ' ') FROM table`. Sample data below: categories ---------- test1 test2 test3...

What's the simplest (and hopefully not too slow) way to calculate the median with MySQL? I've used `AVG(x)` for finding the mean, but I'm having a h...

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:...

I'm designing my database schema using MySQL Workbench, which is pretty cool because you can do diagrams and it converts them :P Anyways, I've decide...

I've recently taken over an old project that was created 10 years ago. It uses MySQL 5.1. Among other things, I need to change the default character...

While starting mysql server 5.7.17 using mysqld_safe, following error occcours. 2017-02-10T17:05:44.870970Z mysqld_safe Logging to '/var/log/mysql/er...

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'...

Being new to MySQL, I have installed the latest version of the MySQL Workbench (5.2.33). I would like to know how you can create a database with this applicatio...

I would like to write a script which copies my current database `sitedb1` to `sitedb2` on the same mysql database instance. I know I can dump the sitedb1 to a s...

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 +...

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...

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 have an SQL table called "posts" that looks like this: id | category ----------------------- 1 | 3 2 | 1 3 | 4 4...

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...