Top "Mysql" questions

How to define a custom ORDER BY order in mySQL

In MySQL how do I define a custom sorting order. To try to explain what I want consider this table: …

mysql

MySQL Stored Procedure Permissions

I am trying to give a user permission to run a stored procedure at the stored procedure level on a …

mysql stored-procedures permissions grant

MYSQL query / dates older than 1 week ago (all datetimes in UTC)

How do I query a mysql db to return all records with a datetime older than 1 week ago. Note that …

mysql datetime utc

MySQL: How do I join same table multiple times?

I have two tables ticket and attr. Table ticket has ticked_id field and several other fields. Table attr has 3 …

mysql sql group-by left-join

Use results from one sql query in another where statement (subquery?)

I see many similar questions but they're either so complex I can't understand them, or they don't seem to be …

mysql sql subquery

MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of …

mysql amazon-ec2 amazon-web-services amazon-rds grant

MySQL get row position in ORDER BY

With the following MySQL table: +-----------------------------+ + id INT UNSIGNED + + name VARCHAR(100) + +-----------------------------+ How can I select a single row AND …

sql mysql analytic-functions

How to properly set up a PDO connection

From time to time I see questions regarding connecting to database. Most answers is not the way I do it, …

php mysql sql class pdo

MySQL: multiple tables or one table with many columns?

So this is more of a design question. I have one primary key (say the user's ID), and I have …

mysql database-design

A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)

So far, I have not found a clear answer to this. I'd like to know what the equivalent is for …

java mysql sql datetime jdbc