Browse Moodle Solutions

We are working on a Spring Boot web application, and the database we are using is MySQL; * the setup we have is we first test it *locally* (means we need to...

I need to get UTF-8 working in my Java webapp (servlets + JSP, no framework used) to support `äöå` etc. for regular Finnish text and Cyrillic alp...

I have a WordPress website on my local **WAMP** server. But when I upload its database to live server, I get error #1273 – Unknown collation: ‘utf8mb4_u...

I am using Fedora 14 and I have MySQL and MySQL server 5.1.42 installed and running. Now I tried to do this as root user: gem install mysql But I get...

I need to add multiple columns to a table but position the columns **after** a column called `lastname`. I have tried this: ALTER TABLE `users` ADD CO...

I'm running the following MySQL `UPDATE` statement: mysql> update customer set account_import_id = 1; ERROR 1205 (HY000): Lock wait timeout e...

I looked around some and didn't find what I was after so here goes. SELECT * FROM trees WHERE trees.`title` LIKE '%elm%' This works fine,...

I have a simple mysql table: CREATE TABLE IF NOT EXISTS `pers` ( `persID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(35) NOT NULL,...

I seem to be unable to re-create a simple user I've deleted, even as root in MySQL. My case: user 'jack' existed before, but I deleted it from my...

SELECT id, amount FROM report I need `amount` to be `amount` if `report.type='P'` and `-amount` if `report.type='N'`. How do I add this t...

I am connecting MySQL - 8.0 with MySQL Workbench and getting the below error: > Authentication plugin 'caching_sha2_password' cannot be loaded: &...

I'm using a MySql database with a Java program, now I want to give the program to somebody else. How to export the MySQL database structure without the d...

I'm setting up a new server and keep running into this problem. When I try to log into the MySQL database with the root user, I get the error: > ER...

Is it possible to create a temporary (session only) table from a select statement without using a create table statement and specifying each column type? I know...

The following query: ``` SELECT year, id, rate FROM h WHERE year BETWEEN 2000 AND 2009 ORDER BY id, rate DESC ``` yields: ``` year | id | r...

What's the difference between `INNER JOIN`, `LEFT JOIN`, `RIGHT JOIN` and `FULL JOIN` in ***MySQL***?

I accidentally enabled **ONLY_FULL_GROUP_BY** mode like this: SET sql_mode = 'ONLY_FULL_GROUP_BY'; How do I disable it?

I am using: gpg --gen-key Is there a better way to create a PGP key? What does this program want? A fully slammed server? > Not enough random b...

I have accounts in **GitHub** and **GitLab**. I generated and added an RSA key to my account in **GitLab**, but now I need to work with **GitHub** on a second p...

I have just reinstalled latest tensorflow on ubuntu: $ sudo pip install --upgrade https://storage.googleapis.com/tensorflow/linux/cpu/tensorflow-0.7.1-cp...