Browse Moodle Solutions

I'm using MySQL 5.7.13 on my windows PC with WAMP Server. My problem is while executing this query SELECT * FROM `tbl_customer_pod_uploads`...

I have a table with the following fields: id (Unique) url (Unique) title company site_id Now, I need to remove rows having same `...

I know that you can insert multiple rows at once, is there a way to update multiple rows at once (as in, in one query) in MySQL? Edit: For example I have th...

I am really interested in how MySQL indexes work, more specifically, how can they return the data requested without scanning the entire table? It's off-t...

What's the difference between VARCHAR and CHAR in MySQL? I am trying to store MD5 hashes.

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I...

How can I import a database with mysql from terminal? I cannot find the exact syntax.

I want to keep a backup of all my MySQL databases. I have more than 100 MySQL databases. I want to export all of them at the same time and again import all of t...

I want to add a Foreign Key to a table called "katalog". ALTER TABLE katalog ADD CONSTRAINT `fk_katalog_sprache` FOREIGN KEY (`Spra...

How do I rename a column in table `xyz`? The columns are: Manufacurerid, name, status, AI, PK, int I want to rename to `manufacturerid` I tried usi...

On one server, when I run: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-...

I have an email column that I want to be unique. But I also want it to accept null values. Can my database have 2 null emails that way?

I have a database that is quite large so I want to export it using Command Prompt but I don't know how to. I am using WAMP.

Without local access to the server, is there any way to duplicate/clone a MySQL db (with content and without content) into another without using `mysqldump`?...

Error SQL query: -- -- Database: `work` -- -- -------------------------------------------------------- -- -- Table structure f...

Let's say I am doing a MySQL `INSERT` into one of my tables and the table has the column `item_id` which is set to `autoincrement` and `primary key`. **H...

What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL? In what cases should these be used?

I need to store a url in a MySQL table. What's the best practice for defining a field that will hold a URL with an undetermined length?

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

I'm trying to find out if a row exists in a table. Using MySQL, is it better to do a query like this: SELECT COUNT(*) AS total FROM table1 WHERE ......