Browse Moodle Solutions

While importing the database in mysql, I have got following error: > 1418 (HY000) at line 10185: This function has none of DETERMINISTIC, NO SQL, or READS...

I have two tables in MySQL. Table Person has the following columns: id | name | fruits ---|------|------- The `fruits` column may hold null or an array o...

with the following statement: mysqldump --complete-insert --lock-all-tables --no-create-db --no-create-info --extended-insert --password=XXX -u...

I cant get my mysql to start on os x 10.7. It is located in `/usr/local/mysql/bin/mysql` I get command not found when I type `mysql --version` in the termi...

What good resources exist for understanding database tuning on the major engines and advancing your knowledge in that area? The idea of this question is to c...

I have 1-many number of records that need to be entered into a table. What is the best way to do this in a query? Should I just make a loop and insert one rec...

We're using Doctrine, a PHP ORM. I am creating a query like this: $q = Doctrine_Query::create()->select('id')->from('MyTable');...

I want to install the MySQL client for the command line, not a GUI. I have searched over the web but only found instructions on installing the MySQL server.

I want to move away from PHP a little and learn Python. In order to do web development with Python I'll need a framework to help with templating and other t...

Which is the valid syntax of this query in MySQL? SELECT * FROM courses WHERE (now() + 2 hours) > start_time *note: start_time is a field of course...

It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to comply to certain rules....

In linux I could find the mysql installation directory with the command `which mysql`. But I could not find any in windows. I tried `echo %path%` and it resulte...

I'm a bit confused on how to order by date formats. For the format `YYYY-MM-DD` you would do this: `...ORDER BY date DESC...` How would you order by...

Here's how I do it: 1. Table names are lower case, use underscores to separate words, and are singular (e.g. `foo`, `foo_bar`, etc. 2. I generally (no...

I have this MySQL query. I have database fields with this contents sports,shopping,pool,pc,games shopping,pool,pc,games sports,pub,swimmin...

I have table - **config**. Schema: `config_name | config_value` And I would like to update multiple records in one query. I try like that: UPDATE c...

Does anyone know how to convert JS dateTime to MySQL datetime? Also is there a way to add a specific number of minutes to JS datetime and then pass it to MySQL...

Using MySQL I can run the query: SHOW CREATE TABLE MyTable; And it will return the create table statement for the specificed table. This is useful if...

Recently my server CPU has been going very high. CPU load averages 13.91 (1 min) 11.72 (5 mins) 8.01 (15 mins) and my site has only had a slight increase in...

I am trying to accomplish the following in MySQL (see `pseudo` code) SELECT DISTINCT gid FROM `gd` WHERE COUNT(*) > 10 ORDER BY lastupd...