Browse Moodle Solutions

Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema. I read that `...

I have a innoDB table which records online users. It gets updated on every page refresh by a user to keep track of which pages they are on and their last access...

How do I set the initial value for an "id" column in a MySQL table that start from 1001? I want to do an insert `"INSERT INTO users (name, ema...

I have changed all the php.ini parameters I know: `upload_max_filesize`, and `post_max_size`. Why am I still seeing 2MB? I'm using Zend Server CE on...

How do I get the current AUTO_INCREMENT value for a table in MySQL?

When I issue `SHOW PROCESSLIST` query, only the first 100 characters of the running SQL query are returned in the info column. Is it possible to change MySQL...

I'm using [PuTTY][1] to run: mysql> SELECT * FROM sometable; `sometable` has many fields and this results in many columns trying to be displaye...

If I have a MySQL table looking something like this: company_name| action |pagecount ------------|-----------|-------- Company A | PRINT |3 Company A |...

We are working on a Spring Boot web application, and the database we are using is MySQL; * the setup we have is we first test it *locally* (means we need to...

I've just started getting into Node.js. I come from a PHP background, so I'm fairly used to using MySQL for all my database needs. How can I use MySQ...

I have an unnormalized events-diary CSV from a client that I'm trying to load into a MySQL table so that I can refactor into a sane format. I created a tabl...

I have been very excited about MongoDb and have been testing it lately. I had a table called posts in MySQL with about 20 million records indexed only on a fiel...

How do you connect to a MySQL database in Java? When I try, I get java.sql.SQLException: No suitable driver found for jdbc:mysql://database/table...

I need to get UTF-8 working in my Java webapp (servlets + JSP, no framework used) to support `äöå` etc. for regular Finnish text and Cyrillic alp...

I have a column in a table which might contain null or empty values. How do I check if a column is empty or null in the rows present in a table? (e.g. nu...

In MySQL, I know I can list the tables in a database with: SHOW TABLES However, I want to insert these table names into another table, for instance:...

I'd like to get all of a MySQL table's column names into an array in PHP. Is there a query for this?

I want to store many records in a MySQL database. All of them contains money values. But I don't know how many digits will be inserted for each one. Whic...

In a MySQL `JOIN`, what is the difference between `ON` and `USING()`? As far as I can tell, `USING()` is just more convenient syntax, whereas `ON` allows a litt...

I want to store a hashed password (using BCrypt) in a database. What would be a good type for this, and which would be the correct length? Are passwords hashed...