Browse Moodle Solutions

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

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

When I attempted to connect to a local MySQL server during my test suite, it fails with the error: OperationalError: (2002, "Can't connect to l...

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

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

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

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

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

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