Browse Moodle Solutions

I have a perplexing issue that I can't seem to comprehend... I have two SQL statements: - The first enters information from a form into the database....

I accidentally installed the PowerPC version of MySQL on my Intel Mac in Snow Leopard, and it installed without a problem but of course doesn't run properly...

Is there a way to check if a table exists *without* selecting and checking values from it? That is, I know I can go `SELECT testcol FROM testtable` and check...

I can't quite get a grasp of MySQL's DECIMAL. I need the row to be able to contain a number anywhere from 00.0001 to 99.9999. How would I structure it t...

Here is a gross oversimplification of an intense setup I am working with. `table_1` and `table_2` both have auto-increment surrogate primary keys as the ID. `in...

Is there a way to detect if a value is a number in a MySQL query? Such as SELECT * FROM myTable WHERE isANumber(col1) = true

In MySQL, is there a way to set the "total" fields to zero if they are NULL? Here is what I have: SELECT uo.order_id, uo.order_total, uo.ord...

I am trying to post on an API with some query params. This is working on PostMan / Insomnia when I am trying to by passing mail and firstname as query paramete...

I recently installed MySQL and it seems I have to reset the password after install. It won't let me do anything else. Now I already reset the password th...

I'm stumped, I don't know how to go about doing this. Basically I just want to create a table, but if it exists it needs to be dropped and re-created...

What's the best way to do following: SELECT * FROM users WHERE created >= today; Note: created is a datetime field.

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no pri...

I had this previously in my normal mysql_* connection: mysql_set_charset("utf8",$link); mysql_query("SET NAMES 'UTF8'");...

In MySQL, can I select columns only where something exists? For example, I have the following query: select phone, phone2 from jewishyellow.user...

The query I'm running is as follows, however I'm getting this error: > \#1054 - Unknown column 'guaranteed_postcode' in 'IN/ALL/ANY subq...

Why do you need to place columns you create yourself (for example `select 1 as "number"`) after `HAVING` and not `WHERE` in MySQL? And are there an...

Do you need to explicitly create an index, or is it implicit when defining the primary key? Is the answer the same for MyISAM and InnoDB?

I have a WordPress production website. I've exported the database by the following commands: `select database > export > custom > select all tab...

I got the following error while trying to alter a column's data type and setting a new default value: ALTER TABLE foobar_data ALTER COLUMN col VARCHA...

When doing: DELETE FROM `jobs` WHERE `job_id` =1 LIMIT 1 It errors: #1451 - Cannot delete or update a parent row: a foreign key constraint fai...