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

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

For homebrew mysql installs, where's my.cnf? Does it install one?

How can I install the [MySQLdb][1] module for Python using pip? [1]: http://mysql-python.sourceforge.net/MySQLdb.html

Is the database query faster if I insert multiple rows at once: like INSERT.... UNION INSERT.... UNION (I need to...

I am implementing the following model for storing user related data in my table - I have 2 columns - `uid` (primary key) and a `meta` column which stores other...

At what point does a MySQL database start to lose performance? - Does physical database size matter? - Do number of records matter? - Is any performa...