Browse Moodle Solutions

I'm interested in learning some (ideally) database agnostic ways of selecting the *n*th row from a database table. It would also be interesting to see how t...

I asked a question and got this reply which helped. UPDATE TABLE_A a JOIN TABLE_B b ON a.join_col = b.join_col AND a.column_a = b.column_b...

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which e...

From the [MySQL](https://www.mysql.com/) console, what command displays the schema of any given table?

How would I delete all duplicate data from a MySQL Table? For example, with the following data: SELECT * FROM names; +----+--------+ | id...

I have a `datetime` column in MySQL. How can I convert it to the display as **mm/dd/yy H:M (AM/PM)** using PHP?

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH to run some commands (such as `php artisan mig...

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

I'm trying to use a select statement to get all of the columns from a certain MySQL table except one. Is there a simple way to do this? EDIT: There are 5...

Some background: I have a Java 1.6 webapp running on Tomcat 7. The database is MySQL 5.5. Previously, I was using Mysql JDBC driver 5.1.23 to connect to the...

I am having a big problem trying to connect to mysql. When I run: <!-- language: shell --> /usr/local/mysql/bin/mysql start I have the followin...

I would like to know the following: - how to get data from multiple tables in my database? - what types of methods are there to do this? - what are joins a...

I have a table with the following columns in a MySQL database [id, url] And the URLs are like: http://domain1.example/images/img1.jpg I wan...

Basically the question is how to get from this: <pre> foo_id foo_name 1 A 1 B 2 C </pre> to this: <pre>...

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 am trying to execute the following query: INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '02...

Is there a way to get the count of rows in all tables in a MySQL database without running a `SELECT count()` on each table?

I got the > Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I...

I have a MySQL table which is as follows: | id | name | parent_id |:--:|:-----------:|:---------: | 19 | category1 | 0 | 20 | category2...