Browse Moodle Solutions

Currently we are using the following commands in PHP to set the character set to [UTF-8][1] in our application. Since this is a bit of overhead, we'd li...

I want to combine multiple databases in my system. Most of the time the database is MySQL; but it may differ in future i.e. Admin can generate such a reports w...

Renaming a table is not working in MySQL: ```sql RENAME TABLE group TO member; ``` The error message is: ``` #1064 - You have an error in your SQL syntax;...

Every time is set up a new SQL table or add a new `varchar` column to an existing table, I am wondering one thing: what is the best value for the `length`....

I get this error when I try to source a large SQL file (a big `INSERT` query). mysql> source file.sql ERROR 2006 (HY000): MySQL server has gone...

Is it possible for me to turn on audit logging on my mysql database? I basically want to monitor all queries for an hour, and dump the log to a file.

I have a table which has several ID columns to other tables. I want a foreign key to force integrity **only** if I put data in there. If I do an update at a...

I have a WordPress website on my local **WAMP** server. But when I upload its database to live server, I get error #1273 – Unknown collation: ‘utf8mb4_u...

I've seen some overly-complicated variations on this question, and none with a good answer. I've tried to put together the simplest possible example:...

I want to search in all fields from all tables of a MySQL database a given string, possibly using syntax as: SELECT * FROM * WHERE * LIKE '%stuff%&#3...

I'm currently developing an application using a MySQL database. The database-structure is still in flux and changes while development progresses (I chang...

I have been reading about scalable architectures recently. In that context, two words that keep on showing up with regards to databases are *sharding* and *part...

I am using Fedora 14 and I have MySQL and MySQL server 5.1.42 installed and running. Now I tried to do this as root user: gem install mysql But I get...

I tried but failed: mysql> select max(1,0); <pre> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that correspo...

I am trying to rename a column in `MySQL` community server `5.5.27` using this SQL expression: ALTER TABLE table_name RENAME COLUMN old_col_name TO new_c...

I need to add multiple columns to a table but position the columns **after** a column called `lastname`. I have tried this: ALTER TABLE `users` ADD CO...

I have upgraded my system and have installed MySql 5.7.9 with php for a web application I am working on. I have a query that is dynamically created, and when ru...

When we create a table in MySQL with a `VARCHAR` column, we have to set the length for it. But for `TEXT` type we don't have to provide the length. What...

When I run the following query I get an error: SELECT `a`.`sl_id` AS `sl_id`, `a`.`quote_id` AS `quote_id`,...

Bearing in mind that I'll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database?