Browse Moodle Solutions

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 running the latest build of the [Docker Apple Silicon Preview.][1] I created the tutorial container/images and it works fine. When I went to create a cu...

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?

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

I want to copy a live production database into my local development database. Is there a way to do this without locking the production database? I'm cur...

We offer a platform for video- and audio-clips, photos and vector-grafics. We started with MySQL as the database backend and recently included [MongoDB][1] for...

Is there a MySQL command to locate the `my.cnf` configuration file, similar to how PHP's `phpinfo()` locates its `php.ini`?

How can I see the list of the stored procedures or stored functions in mysql command line like `SHOW TABLES;` or `SHOW DATABASES;` commands.

I've got a very large MySQL table with about 150,000 rows of data. Currently, when I try and run SELECT * FROM table WHERE id = '1'; the c...

I'm just getting started learning [SQLite][1]. It would be nice to be able to see the details for a table, like MySQL's `DESCRIBE [table]`. `PRAGMA tabl...

I am running this query on MySQL SELECT ID FROM ( SELECT ID, msisdn FROM ( SELECT * FROM TT2 ) ); and it...