Browse Moodle Solutions

I understand that this question has been asked before, but most of the time it is asked in relation to a specific database or table. I cannot find an answer on...

What is main difference between `INSERT INTO table VALUES ..` and `INSERT INTO table SET`? Example: INSERT INTO table (a, b, c) VALUES (1,2,3)...

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432...

I have tables that I've tried setting PK FK relationships on but I want to verify this. How can I show the PK/FK restraints? I saw [this][1] manual page, bu...

I've been trying to figure out how I can make a query with MySQL that checks if the value (string `$haystack` ) in a certain column contains certain data (s...

I have a function that returns five characters with mixed case. If I do a query on this string it will return the value regardless of case. How can I make My...

Is there a query (command) to truncate all the tables in a database in one operation? I want to know if I can do this with one single query.

I'm trying to setup up MySQL on mac os 10.6 using Homebrew by `brew install mysql 5.1.52`. Everything goes well and I am also successful with the `mysql_...

I am moving away from Linode because I don't have the Linux sysadmin skills necessary; before I complete the transition to a more noob-friendly service, I n...

Someone sent me a SQL query where the `GROUP BY` clause consisted of the statement: `GROUP BY 1`. This must be a typo right? No column is given the alias 1....

I have installed a recent community version of MySQL from MySQL site. The version is `5.6.x`. It was done using an installer and I also chose the option to c...

I have just installed Debian Lenny with Apache, MySQL, and PHP and I am receiving a PDOException `could not find driver`. This is the specific line of code i...

What is the correct format to pass to the `date()` function in PHP if I want to insert the result into a MySQL `datetime` type column? I've been trying `...

I am having a problem with BLOB fields in my MySQL database - when uploading files larger than approx 1MB I get an error `Packets larger than max_allowed_packet...

I've got the following two tables (in MySQL): Phone_book +----+------+--------------+ | id | name | phone_number | +----+------+------...

My Current Data for SELECT PROD_CODE FROM `PRODUCT` is PROD_CODE 2 5 7 8 22 10 9 11 I have tried all...

How do you select all the columns from one table and just some columns from another table using JOIN? In MySQL.

When I tried running the following command on MySQL from within Terminal: mysql -u $user -p$password -e "statement" The execution works as e...

How can you connect to MySQL from the command line in a Mac? (i.e. show me the code) I'm doing a PHP/SQL tutorial, but it starts by assuming you're...

I'm testing the speed of some queries in MySQL. The database is caching these queries making it difficult for me to get reliable results when testing how fa...