Browse Moodle Solutions

Is there a fast way of getting all column names from all tables in `MySQL`, without having to list all the tables?

I am getting this error in [WordPress][1]' phpMyAdmin: #145 - Table './DB_NAME/wp_posts' is marked as crashed and should be repaired When...

I have a SQL query where I want to insert multiple rows in single query. so I used something like: $sql = "INSERT INTO beautiful (name, age)...

I'm getting a 1022 error regarding duplicate keys on create table command. Having looked at the query, I can't understand where the duplication is takin...

Currently I am having the following MySQL table: `Employees (empID, empName, department);` I want to change the table to the following: `Employees (empID, de...

This is a much discussed issue for OSX 10.6 users, but I haven't been able to find a solution that works. Here's my setup: Python 2.6.1 64bit Django...

I have a large number of rows that I would like to copy, but I need to change one field. I can select the rows that I want to copy: select * from Tabl...

I installed MySQL via [MacPorts][1]. What is the command I need to stop the server (I need to test how my application behave when MySQL is dead)? [1]: http...

**Error Code: 2013. Lost connection to MySQL server during query** I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total...

I'm looking to be able to run a single query on a remote server in a scripted task. For example, intuitively, I would imagine it would go something like:...

I would like to make a timestamp column with a default value of `CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP` using the Laravel Schema Builder/Migrations. I h...

How to set multiple columns of a table using update query in mysql?

I'm currently creating a Login form and have this code: string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"...

How can I `SELECT` the last row in a MySQL table? I'm `INSERT`ing data and I need to retrieve a column value from the previous row. There's an `au...

I have seen many queries with something as follows: SELECT 1 FROM table What does this `1` mean, how will it be executed, and what will it retu...

I have a table like this: TITLE | DESCRIPTION ---------------|-------------------------------- test1 | value blah blah value test2...

I'm having a bit of a strange problem. I'm trying to add a foreign key to one table that references another, but it is failing for some reason. With my...

I have the following sql create statement mysql> CREATE TABLE IF NOT EXISTS `erp`.`je_menus` ( -> `id` INT(11) NOT NULL AUTO_INCREMEN...

I want to remove the password for user root in localhost. How can I do that? By mistake I have set the password of root user. That's why phpmyadmin is givin...

I know how to use INDEX as in the following code. And I know how to use *foreign key* and *primary key*. ```mysql CREATE TABLE tasks ( task_id...