Browse Moodle Solutions

Given the following code: <!-- language: lang-php --> DB::table('users')->get(); I want to get the raw SQL query string that the d...

I want to find an SQL query to find rows where field1 does not contain $x. How can I do this?

What is the best method to copy the data from a table in one database to a table in another database when the databases are under different users? I know t...

I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +-...

In the footer of my page, I would like to add something like "last updated the xx/xx/200x" with this date being the last time a certain mySQL table ha...

To find out the start command for mysqld (using a mac) I can do: ps aux|grep mysql I get the following output, which allows me to start mysql server....

I can't start the mysql service in Snow Leopard, and in the panel prefs appears the message, > warning the user/local/mysql/data directory is not owne...

I am not very familiar with databases and the theories behind how they work. Is it any slower from a performance standpoint (inserting/updating/querying) to us...

When I execute this command in MySQL: SET FOREIGN_KEY_CHECKS=0; Does it affect the whole engine or it is only my current transaction?

How to calculate the difference between two dates, in the format `YYYY-MM-DD hh: mm: ss` and to get the result in seconds or milliseconds?

So here's what I want to do on my _MySQL_ database. I would like to do: SELECT * FROM itemsOrdered WHERE purchaseOrder_ID = &#39...

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

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

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

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