Browse Moodle Solutions

How can I drop the "Unique Key Constraint" on a column of a MySQL table using phpMyAdmin?

I have a mysqldump backup of my mysql database consisting of all of our tables which is about 440 megs. I want to restore the contents of just one of the tables...

I've just started with Laravel and I get the following error: > Unknown column 'updated_at' insert into gebruikers (naam, wachtwoord, > u...

I have no idea what the problem is. Using MySQL 5.0 I get a compile error when attempting to run the following MySQL update query: UPDATE b SET b.m...

I am trying to create a container with a MySQL database and add a schema to these database. My current Dockerfile is: FROM mysql MAINTAINER (me)...

So I'm trying to add Foreign Key constraints to my database as a project requirement and it worked the first time or two on different tables, but I have two...

```sql SELECT * FROM table ORDER BY string_length(column); ``` Is there a MySQL function to do this (of course instead of `string_length`)?

I would like to know what the max size is for a MySQL VARCHAR type. I read that the max size is limited by the row size which is about 65k. I tried setting...

**Not Duplicate!** looking for some feature have phpmyadmin during export in command line I want to export and import a .sql file to and from a MySQL databas...

What is the difference between `MUL`, `PRI` and `UNI` in MySQL? I'm working on a MySQL query, using the command: desc mytable; One of the fiel...

Currently, I am doing a very basic OrderBy in my statement. SELECT * FROM tablename WHERE visible=1 ORDER BY position ASC, id DESC The problem with th...

I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific table...

I'm using `GROUP_CONCAT()` in a MySQL query to convert multiple rows into a single string. However, the maximum length of the result of this function is `1...

Is it possible to check if a (MySQL) database exists after having made a connection. I know how to check if a table exists in a DB, but I need to check if th...

I installed MySQL on Mac OS X Mountain Lion with `homebrew install mysql`, but when I tried `mysql -u root` I got the following error: > ERROR 2002 (HY000...

I am aware of this command: GRANT ALL PRIVILEGES ON database.* TO 'user'@'yourremotehost' IDENTIFIED BY 'newpassword&#...

The following query: SELECT * FROM `objects` WHERE (date_field BETWEEN '2010-09-29 10:15:55' AND '2010-01-30 14:15:55') returns...

I have a query that inserts using a `SELECT` statement: INSERT INTO courses (name, location, gid) SELECT name, location, gid FROM courses...

I'm setting up a database using phpMyAdmin. I have two tables (`foo` and `bar`), **indexed on their primary keys**. I am trying to create a relational table...

How can I generate a create table script for an existing table in phpmyadmin?