Browse Moodle Solutions

Is it possible to somehow get structure of MySQL database, or just some table with simple query? Or is there another way, how can I do it?

What is the best SQL data type for currency values? I'm using MySQL but would prefer a database independent type.

Well here's my problem I have three tables; regions, countries, states. Countries can be inside of regions, states can be inside of regions. Regions are t...

Is there any way to get SQLAlchemy to do a bulk insert rather than inserting each individual object. i.e., doing: INSERT INTO `foo` (`bar`) VALUES (1)...

I'm trying to delete orphan entries in a mysql table. I have 2 tables like this: Table `files`: id | .... ----|------ 1 | .... 2 | .... 7...

I'm trying to figure out how to locate all occurrences of a url in a database. I want to search all tables and all fields. But I have no idea where to start...

I’m trying to modify a table to make its primary key column `AUTO_INCREMENT` after the fact. I have tried the following SQL, but got a syntax error notificatio...

I installed mySQL on my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preferences, I want to know the instructions to start f...

Is it possible to set a user variable based on the result of a query in MySQL? What I want to achieve is something like this (we can assume that both `USER`...

# Background # I'm a first year CS student and I work part time for my dad's small business. I don't have any experience in real world applicatio...

I execute an INSERT INTO statement cursor.execute("INSERT INTO mytable(height) VALUES(%s)",(height)) and I want to get the primary key. M...

I'm trying to connect to my MySQL DB with the Terminal on my Apple (With PHP). Yesterday it worked fine, and now I suddenly get the error in the title....

I've been using indexes on my MySQL databases for a while now but never properly *learnt* about them. Generally I put an index on any fields that I will be...

I want to order by Time,but seems no way to do that ? mysql> show processlist; +--------+-------------+--------------------+------+---------+----...

I'm using `now()` in MySQL query. INSERT INTO table SET data = '$data', date = now() But I want to add 1 day to this date (so that `date...

I have a form on a website which has a lot of different fields. Some of the fields are optional while some are mandatory. In my DB I have a table which holds al...

I've [a table][1] like: +-----------+-------+------------+ | client_id | views | percentage | +-----------+-------+------------+ |...

I currently have just under a million locations in a mysql database all with longitude and latitude information. I am trying to find the distance between one...

The MySQL reference manual does not provide a clearcut example on how to do this. I have an ENUM-type column of country names that I need to add more countri...

Having a table with a column like: `mydate DATETIME` ... I have a query such as: SELECT SUM(foo), mydate FROM a_table GROUP BY a_table.mydate; This...