Browse Moodle Solutions

I am using prepared statements to execute mysql database queries. And I want to implement a search functionality based on a keyword of sorts. For that I nee...

I'm trying to finish this query; my tag field is set to UNIQUE and I simply want the database to ignore any duplicate tag. INSERT INTO table_tags (t...

How can I make a copy values from one column to another? I have: Database name: list ------------------- number | test --------------...

Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' I have gone thro...

I'm trying to run WordPress in my Windows desktop and it needs MySQL. I install everything with `Web Platform Installer` which is provided by Microsoft....

I am working on a project where i need to create a database with 300 tables for each user who wants to see the demo application. it was working fine but today w...

I have two columns in table users namely `registerDate and lastVisitDate` which consist of datetime data type. I would like to do the following. 1. Set regi...

> **Possible Duplicate:** > [Why would someone use WHERE 1=1 AND <conditions> in a SQL clause?](https://stackoverflow.com/questions/242822...

CREATE TABLE foo SELECT * FROM bar copies the table `foo` and duplicates it as a new table called `bar`. How can I copy the schema of `foo` to a new t...

I read many threads about getting only the first row of a left join, but, for some reason, this does not work for me. Here is my structure (simplified of cou...

I've searched around but didn't find if it's possible. I've this MySQL query: INSERT INTO table (id,a,b,c,d,e,f,g) VALUES (1,2,3,4,5,6...

I would like to know how can I output a number with 2 decimal places, without rounding the original number. For example: 2229,999 -> 2229,99 I a...

I have a query where I am using `GROUP_CONCAT` and a custom separator as my results may contain commas: '----' This all works well, however it is sti...

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

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

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

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

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

I've [a table][1] like: +-----------+-------+------------+ | client_id | views | percentage | +-----------+-------+------------+ |...