Browse Moodle Solutions

How to declare a variable in mysql, so that my second query can use it? I would like to write something like: SET start = 1; SET finish = 10;...

When I open XAMPP and click the start MySQL button, it gives me an error. I had started it just before, but now it isn't working. > 12:19:12 PM [mysq...

I try to connect MySQL database with Java using connector 8.0.11. Everything seems to be OK, but I get this exception: Exception in thread "main&q...

How do I drop all tables from a MySQL database, ignoring any foreign key constraints?

I am using MySQL in localhost as a "query tool" for performing statistics in R, that is, everytime I run a R script, I create a new database (A), crea...

Consider: ./mysqladmin -u root -p** '_redacted_' Output (including typing the password): > Enter password: > > mysqladmin: co...

By default, `mysqldump` takes the backup of an entire database. I need to backup a single table in MySQL. Is it possible? How do I restore it?

I am learning MySQL and tried using a `LOAD DATA` clause. When I used it as below: ```mysql LOAD DATA INFILE "text.txt" INTO table mytable; ```...

How can I best write a query that selects 10 rows randomly from a total of 600k?

Is there any query/way to show the last queries executed on **ALL** servers?

In another question I posted someone told me that there is a difference between: ```sql @variable ``` and: ```sql variable ``` in MySQL. He also...

I'm importing a MySQL dump and getting the following error. $ mysql foo < foo.sql ERROR 1153 (08S01) at line 96: Got a packet bigger than &#...

I'm creating a form for sending private messages and want to set the `maxlength` value of a textarea appropriate to the max length of a `text` field in my M...

I'm connected to my Amazon EC2 instance. I can login with MySQL root with this command: mysql -u root -p Then I created a new user bill with host...

How can I convert entire MySQL database character-set to UTF-8 and collation to UTF-8?

What is the difference between `utf8mb4` and `utf8` charsets in *MySQL*? I already know about *ASCII*, *UTF-8*, *UTF-16* and *UTF-32* encodings; but I&#39...

MySQL 5.0.45 What is the syntax to alter a table to allow a column to be null, alternately what's wrong with this: ALTER mytable MODIFY mycolumn v...

I have a table with a primary key that is a varchar(255). Some cases have arisen where 255 characters isn't enough. I tried changing the field to a text, bu...

I am having some problems when trying to install `mysql2` gem for Rails. When I try to install it by running `bundle install` or `gem install mysql2` it gives m...

Given the table created using: CREATE TABLE tbl_Country ( CountryId INT NOT NULL AUTO_INCREMENT, IsDeleted bit, PRIMARY KEY (C...