Browse Moodle Solutions

I've been struggling with this question for quite some months now, but I haven't been in a situation that I needed to explore all possible options befor...

If I have a trigger before the update on a table, how can I throw an error that prevents the update on that table?

How do I store binary data in [MySQL][1]? [1]: http://en.wikipedia.org/wiki/MySQL

I want to begin writing queries in MySQL. `show grants` shows: ```lang-none +--------------------------------------+ | Grants for @localhost...

I have an already existing table with a field that should be unique but is not. I only know this because an entry was made into the table that had the same valu...

When the SQL query below is executed: UPDATE shop_category SET name = 'Secolul XVI - XVIII' AND name_eng = '16th to 18th cent...

I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I try to import the database into the en...

I have a query, and I want to get the last ID inserted. The field ID is the primary key and auto incrementing. I know that I have to use this statement:...

Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench?

I have a file that can contain from 3 to 4 columns of numerical values which are separated by comma. Empty fields are defined with the exception when they are a...

When you limit the number of rows to be returned by a SQL query, usually used in paging, there are two methods to determine the total number of records: ###M...

I've installed MySQL server on a remote Ubuntu machine. The `root` user is defined in the `mysql.user` table this way: mysql> SELECT host, user, pass...

We have a database that has a bunch of records with some bad data in one column, in which an embedded editor escaped some stuff that shouldn't have been esc...

I am trying to alter a table which has no primary key nor auto_increment column. I know how to add an auto increment primary key column. I already have 500 r...

insert into table select * from table where primarykey=1 I just want to copy one row to insert into the same table (i.e., I want to duplicate an existing...

I am using mysql and need to update a column with a null value. I have tried this many different ways and the best I have gotten is an empty string. Is there...

I am working on designing a large database. In my application I will have many rows for example I currently have one table with 4 million records. Most of my qu...

In MySQL how do I define a custom sorting order. To try to explain what I want consider this table: ID Language Text 0 ENU a 0 JPN b...

create table check2(f1 varchar(20),f2 varchar(20)); creates a table with the default collation `latin1_general_ci`; alter table check2 collate lat...

Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it should be UTF8, and now I have issues. Every reco...