Browse Moodle Solutions

I am trying to make sure that my app container does not run migrations / start until the db container is started and READY TO accept connections. So I decide...

I need to delete all rows from a table but when I add a new row, I want the primary key ID, which has an auto increment, to start again from 0 respectively from...

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

I have table name called "Person" with following column names P_Id(int), LastName(varchar), FirstName (varchar). I forgot to give...

Are there are any Linux mysql command line tools that don't require the entire mysql db installation package to be installed? What I'm trying to do...

I have latitude and longitude and I want to pull the record from the database, which has nearest latitude and longitude by the distance, if that distance gets l...

I am wondering if there is any difference with regards to performance between the following SELECT ... FROM ... WHERE someFIELD IN(1,2,3,4) SE...

What is the equivalent of varchar(max) in MySQL?

Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I'd like to use VARCHAR as the primary key for referen...

I have been trying to reset my MySQL root password. I have run `mysqld_safe --skip-grant-tables`, updated the root password, and checked the user table to make...

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

What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to...

I'm looking at MySQL procedures and functions. What is the real difference? They seem to be similar, but a function has more limitations. I'm lik...

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